Thread: Transfer data to another server
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.
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.
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.