Hello,
Are the database files created by
32-bit PostgreSQL identical to the files created by 64-bit PostgreSQL? The
database files would reside on a SAN or DAS device external to the servers. If
the server running a 64-bit installation of PostgreSQL were to fail, would we be
able to bring a server running a 32-bit installation online and run it against
the original database files?
We would absolutely not be
simultaneously running two instances of the database against the same database
files. My background is with MS SQL Server, where a database can be “reattached”
to a different instance of the software (although not between 32-bit and 64-bit
versions). We would be running PostgreSQL on RHEL/CentOS
5.
I realize having a separate server
is not a sufficient disaster recovery strategy. We do regular database backups
to tape in the event of data corruption or catastrophic
failure.
Replication with Slony-I is also an
option, however a complete hot or warm spare configuration would require
additional storage space. Is it possible to replicate from 64-bit to
32-bit?
If you haven’t already guessed, we
are trying to save a few dollars by switching to a capable open source database
and running our failover systems with older 32-bit hardware rather than an
identical new 64-bit machine.
Thank you,
Adam
Talaat