pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedData file compatibility between 32-bit and 64-bit
2+ messages / 2 participants
[nested] [flat]
* Data file compatibility between 32-bit and 64-bit
@ 2008-01-25 20:05 Adam Talaat <adam@illumen.org>
2008-01-25 20:33 ` Re: Data file compatibility between 32-bit and 64-bit Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Adam Talaat @ 2008-01-25 20:05 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Data file compatibility between 32-bit and 64-bit
2008-01-25 20:05 Data file compatibility between 32-bit and 64-bit Adam Talaat <adam@illumen.org>
@ 2008-01-25 20:33 ` Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Scott Marlowe @ 2008-01-25 20:33 UTC (permalink / raw)
To: Adam Talaat <adam@illumen.org>; +Cc: pgsql-admin
On Jan 25, 2008 2:05 PM, Adam Talaat <adam@illumen.org> wrote:
>
>
> Hello,
>
> Are the database files created by 32-bit PostgreSQL identical to the files
> created by 64-bit PostgreSQL?
No.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-01-25 20:33 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-01-25 20:05 Data file compatibility between 32-bit and 64-bit Adam Talaat <adam@illumen.org>
2008-01-25 20:33 ` Scott Marlowe <scott.marlowe@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox