The easiest way is to shut down both postmaters and do a plain copy of the data cluster directories. Another way (with doubling space) is to use pg_dumpall
|-----Original Message----- |From: Ing. Jhon Carrillo [mailto:[EMAIL PROTECTED] |Sent: Mittwoch, 18. Mai 2005 15:28 |To: [email protected] |Subject: [ADMIN] database A to database B | | |Hi all, | |I have two postgresql 7.4 (Linux) servers: | |Server A: it has a original database. |Server B: it doesn't have nothing. | | |I need to transfer the database/server A to database/server B |through the |some command directly. | |thanks. | |Jhon Carrillo |Ingeniero en Computaci�n |[EMAIL PROTECTED] |+584145246033 |Caracas - Venezuela | | | | |---------------------------(end of |broadcast)--------------------------- |TIP 7: don't forget to increase your free space map settings | ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
