moving postgres data

From: "Duncan Adams (DNS)" <duncan(dot)adams(at)vcontractor(dot)co(dot)za>
To: pgsql-novice(at)postgresql(dot)org
Subject: moving postgres data
Date: 2001-10-31 09:17:01
Message-ID: C54EF5B83335D311BCB50000C11042B102C8C6F7@vodabemail1.vodacom.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all

I have data in a postgres database on one server and have to move it to a
new server that has been set up with a new version of postgres. The
database is an exact copy. what is the best way of moving the thing across?
do i set up the tables on the new box and write scripts to move it across or
is there another way of doing this?

I don't have root access on the new server but can probably talk the sys
admin into a little work if i have to.

ta

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Mo Holkar 2001-10-31 09:46:46 Re: moving postgres data
Previous Message Sharon Cowling 2001-10-31 02:53:19 Returning results from function