Re: Database Transfer

Peter Eisentraut <peter_e@gmx.net>

From: Peter Eisentraut <peter_e@gmx.net>

To: Craig May <craig.may@s2.enthdimension.com.au>

Cc: PGSQL-SQL <pgsql-sql@postgresql.org>

Date: 2000-06-18T14:24:43Z

Lists: pgsql-hackers

Craig May writes:

> I have two servers running pgsql.  Is there a command to transfer the
> databases
> between them?

pg_dump and psql. "Back up" one database and "restore" it on the other
server. Don't even think about moving files around. :)

-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden