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

Moving an existing database from an old version?

From: Howard Eglowstein <howard(at)yankeescientific(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Moving an existing database from an old version?
Date: 2007-01-12 23:23:50
Message-ID: 45A81886.1070301@yankeescientific.com (view raw or flat)
Thread:
Lists: pgsql-novice
I'm sorry if this has been answered before, but I've searched through 
the archives and haven't found anything.

I have a machine that was built about two years ago and runs Debian. I 
just built a new machine running Fedora and PostgreSQL 8.x. The old 
machine has an older version of PostgreSQL running on it that seems to 
keep data in different locations than the new one. I have found the 
.conf files and they don't seem to tell me where the data lives.

What I want to do is simply transplant the existing application onto the 
new database. I'd be happy to simply copy the files over and hack the 
.conf files appropriately, or if it's better, can I use PG_DUMP to 
somehoe backup the old data and restore it to the new installation?

I appreciate any pointers you may have or suggestions as to where else I 
might look.

Or if you want to help out in exchange for lunch money, that could be 
arranged too. :)

Thanks!

Howard

Responses

pgsql-novice by date

Next:From: Chad WagnerDate: 2007-01-13 00:09:34
Subject: Re: Moving an existing database from an old version?
Previous:From: Sven SporerDate: 2007-01-12 16:54:32
Subject: User Management, drop privilege

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