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