Re: [ADMIN] moving database to diff. server

2005-06-28 Thread Tom Arthurs
use initdb to create the cluster (including the template db's), if you haven't already done so. Paul Keyes wrote: Hi All, I'm confused about one aspect of backing up and moving a database to a different server. I've used pg_dump to dump the database and moved he resulting file to the new serve

Re: [ADMIN] moving database to diff. server

2005-06-27 Thread Michael Fuhr
On Wed, Jun 22, 2005 at 04:02:24PM -0400, Paul Keyes wrote: > > I'm confused about one aspect of backing up and moving > a database to a different server. > I've used pg_dump to dump the database and moved he > resulting file to the new server, where Postgresql is > istalled and configured (as far

[ADMIN] moving database to diff. server

2005-06-27 Thread Paul Keyes
Hi All, I'm confused about one aspect of backing up and moving a database to a different server. I've used pg_dump to dump the database and moved he resulting file to the new server, where Postgresql is istalled and configured (as far as I know). But I know that before I run psql on the backup I h