Replication in PG 9 between Windows and Linux boxes
- by mlaverd
I have PostgreSQL 9 running on Windows 2003 SP2. I am trying to replicate it on a Fedora 12 system running PostgreSQL 9 as well.
I am hitting this error message:
/usr/pgsql-9.0/bin/postgres -D /var/lib/pgsql/9.0/data/ -p 5432
2011-02-11 17:43:26 ISTFATAL: incorrect checksum in control file
Because of firewall restrictions, I could not follow the official instructions to the letter. Instead, I zipped the contents of the data directory when the server was offline and copied that to the Linux box.
I ran a sha1deep on both directories and there were no mismatches.
I changed the rights so that only the postgres user and group had access to the files.
Now, what can I do for replication to work? I tried with a 'pg_dumpall', but the system complains that the database IDs do no match.