Postgres Pro
Downloads
Home   >   mailing lists

Re: Database Transfer - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: Database Transfer
Date
Msg-id Pine.LNX.4.21.0006181623500.562-100000@localhost.localdomain
Whole thread Raw
In response to Database Transfer  (Craig May <craig.may@s2.enthdimension.com.au>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: find the number of rows for each table
Next
From:
Date:
Subject: capacity of copy command??