Re: Detaching database

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: pgsql-general-owner(at)postgresql(dot)org on behalf of Petr
Sent: Tue 12/27/2005 3:39 PM
To: pgsql-general(at)postgresql(dot)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!