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

Re: moving a database.

From: Chuck <chuckr(at)velofish(dot)com>
To: Frank Bax <fbax(at)sympatico(dot)ca>, pgsql-novice(at)postgresql(dot)org
Subject: Re: moving a database.
Date: 2008-01-10 23:16:41
Message-ID: p06230946c3ac5712e5a2@[] (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
At 11:56 AM -0500 1/10/08, Frank Bax wrote:
>LWATCDR wrote:
>>I have an old postgres 7.1 data base that I must migrate to a new
>>server running 8.2.6.
>>The problem is everything I have tried has failed. The database has
>>blobs in it but other than that it is pretty simple.
>>So my question is what command line should I use to try and migrate
>>this old database to the new server?
>>I set up the old one years ago and it frankly has just worked but I
>>have to move it to a new machine and I am way out of practice.
>>So what command line should I use on the new server to try and copy
>>the database from the old server?
>Just use your backup/restore procedure (you do have one, right? and 
>you test it regularly, right?); backup on 7.1; restore on 8.2.
>If it doesn't work; post your commands and an error message.

Could you post a backup/restore procedure or point to some 
documentation that suggests one? I need to set this up for an 8.2.5 
cluster and I'm new to Postgres. It sounds like a few people could 
possibly benefit as well.


In response to


pgsql-novice by date

Next:From: Rodrigo E. De León PlicetDate: 2008-01-11 07:50:40
Subject: Re: question: n:m association between three tables
Previous:From: LWATCDRDate: 2008-01-10 20:24:23
Subject: Re: moving a database.

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