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: 542

Filed under:
|
|

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

Related posts about replication

Related posts about postgresql