Petr,
As long as the new server is the same operating system, and the versions of
postgres are the same, you can do a binary copy of the data directory and move
it to the new machine, point the new server's postgres to the copied and data
and start it up. Indexes, statistics, etc. all are intact and ready to go. On
the negative side I think you need to idle the source database during the
initial copy.
We've done this to move databases in the 5-10 gigabyte range on postgres 7.4.
I am not familiar with those other database's capabilities so if mu humble
suggestion is not what you want, a bit more information about the problem might
be of help.
HTH,
Greg Williamson
-----Original Message-----
From: [EMAIL PROTECTED] on behalf of Petr
Sent: Tue 12/27/2005 3:39 PM
To: pgsql-general@postgresql.org
Cc:
Subject: [GENERAL] Detaching database
Hi.
Is any way how to detach complete database, and attach it into other Postgre
server (like MSSQL, Interbase etc. databases movability) ?
Moving database via SQL export is crazy way for me (and for my customers).
Thanks and forgive me for my poor english.
Petr
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
!DSPAM:43b1d0f4175415020319812!
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
