Re: Moving a database

From: "Eft, Aaron" <Aaron(dot)Eft(at)avnet(dot)com>
To: "'Kent Rigby'" <kent(dot)rigby(at)att(dot)net>, PGSQL Novice List <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Moving a database
Date: 2002-12-24 20:02:55
Message-ID: DC570C9C688E284ABE0DBE7C266599441CA266@amer31.avnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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(dot)rigby(at)att(dot)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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Reshat Sabiq 2002-12-24 22:09:50 Re: Moving a database
Previous Message Kent Rigby 2002-12-24 19:53:52 Moving a database