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:jdigital@xxxxxxxxx] |Sent: Mittwoch, 18. Mai 2005 15:28 |To: pgsql-admin@xxxxxxxxxxxxxx |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 |jdigital@xxxxxxxxx |+584145246033 |Caracas - Venezuela | | | | |---------------------------(end of |broadcast)--------------------------- |TIP 7: don't forget to increase your free space map settings |
