Thread: Transfer data to another server

Transfer data to another server

From
"Virat Luevisadpaibul"
Date:
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.
 

Re: [GENERAL] Transfer data to another server

From
Ed Loehr
Date:
These might help you along...

    http://www.postgresql.org/docs/postgres/manage-ag15722.htm
    http://www.postgresql.org/docs/postgres/app-pg-upgrade.htm

Cheers,
Ed Loehr


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
transfermy data in server1 to server2.Virat. 


Re: [GENERAL] Transfer data to another server

From
Dustin Sallings
Date:
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.