Replication in PG 9 between Windows and Linux boxes
Posted
by
mlaverd
on Server Fault
See other posts from Server Fault
or by mlaverd
Published on 2011-02-11T07:02:18Z
Indexed on
2011/02/11
7:26 UTC
Read the original article
Hit count: 541
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.
© Server Fault or respective owner