Re: WAL file compatibility - Mailing list pgsql-admin

From Tom Lane
Subject Re: WAL file compatibility
Date
Msg-id 26679.1256048720@sss.pgh.pa.us
Whole thread Raw
In response to WAL file compatibility  (Radamanthus Batnag <rad.batnag@devex.com>)
Responses Re: WAL file compatibility
Re: WAL file compatibility
List pgsql-admin
Radamanthus Batnag <rad.batnag@devex.com> writes:
> I have a PostgreSQL production server running on CentOS (compiled from
> source), and I'm planning to setup a hot standby database on another
> server, running on Ubuntu (default Ubuntu binaries).

> The production server is running on 8.3.5, and the planned Ubuntu hot
> standby is running on 8.3.x. Can I use the production WAL files on the
> Ubuntu standby without problems?

The source and destination servers have to be the same major PG release,
same architecture (no 32-bit vs 64-bit for instance), and built with the
same configure options.  OS per se shouldn't matter, but you could
easily get burnt on configure options if you use binaries obtained from
different packagers.  Compare pg_config output or check the fields
listed by pg_controldata.

            regards, tom lane

pgsql-admin by date:

Previous
From: Anj Adu
Date:
Subject: server process crash
Next
From: Jaime Casanova
Date:
Subject: Re: WAL file compatibility