Re: [GENERAL] Transfer data to another server

From: Dustin Sallings <dustin(at)spy(dot)net>
To: Virat Luevisadpaibul <virat(at)iname(dot)com>
Cc: pgsql-general(at)hub(dot)org
Subject: Re: [GENERAL] Transfer data to another server
Date: 2000-01-09 10:38:18
Message-ID: Pine.NEB.4.10.10001090237260.6877-100000@foo.west.spy.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, 9 Jan 2000, Virat Luevisadpaibul wrote:

# I use Postgres 6.4 in server1 and I want to change my server to
# server2 with Postgres 6.5. Please tell me how to transfer my data in
# server1 to server2. Virat.

pg_dump -h server1 databasename | psql -h server2 databasename

--
dustin sallings The world is watching America,
http://2852210114/~dustin/ and America is watching TV.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message admin 2000-01-09 22:37:43 can't seem to use index
Previous Message Ed Loehr 2000-01-09 09:12:05 Re: [GENERAL] Transfer data to another server