Postgres Pro
Downloads
Home   >   mailing lists

Re: Moving a database - Mailing list pgsql-novice

From Eft, Aaron
Subject Re: Moving a database
Date
Msg-id DC570C9C688E284ABE0DBE7C266599441CA266@amer31.avnet.com
Whole thread Raw
In response to Moving a database  (Kent Rigby <kent.rigby@att.net>)
Responses Re: Moving a database
List pgsql-novice
Tree view
I would suggest doing a
 
pg_dump > filename
 
then save that to disk, email it, ftp, whatever to the destination server, and
 
createdb databaseName
psql databaseName < filename
 
-Aaron
 
-----Original Message-----
From: Kent Rigby [mailto:kent.rigby@att.net]
Sent: Tuesday, December 24, 2002 12:54 PM
To: PGSQL Novice List
Subject: [NOVICE] Moving a database

Can someone please tell me the easiest method for moving a database from one server to another?

Pleaes be explicit, I am in the Novice group for a reason.

Kent

pgsql-novice by date:

Previous
From: Kent Rigby
Date:
Subject: Moving a database
Next
From: "Reshat Sabiq"
Date:
Subject: Re: Moving a database