I just noticed that the list has not been copied on most of this exchange. Please keep the list copied, as others are likely to contribute useful ideas. Renato Oliveira <renato.oliveira@xxxxxxxxxxx> wrote: > Can I ask few questions about it, if possible? Sure. Please keep it "on list", though. > We are running Linux Redhat 4. That should make building from source pretty easy. > [postgres@78674-db1 ~]$ pg_config > VERSION = PostgreSQL 8.2.4 > [postgres@db2 ~]$ pg_config > VERSION = PostgreSQL 8.3.4 Well, there's your problem, right there. Your primary is 8.2.4, but your secondary is 8.3.4. The other information matches nicely and there were no special build options -- it's just that there are two different major versions of PostgreSQL here, and PITR backups definitely won't deal with that. Is there a reason for having your secondary server on a newer major release (like there was some query which wouldn't run correctly or within a reasonable amount of time without it)? Wait -- I just had a thought. Old version copying to new version. Slony in the mix. This sounds like a situation where the old DBA was trying to use Slony to upgrade with minimal down time. Problem was, you haven't been able to keep the newer version up-to-date through Slony, so you couldn't cut over? If that's the situation, it changes the focus. And it also means we need someone who understands Slony in the discussion.... -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
