Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group