From: Chander Ganesan <chander@otg-nc.com>
To: yogesh@banasdairy.coop
Cc: pgsql-admin@postgresql.org
Subject: Re: Restore Database From data folder
Date: Mon, 05 May 2008 18:38:36 -0400
Message-ID: <481F8C6C.8040406@otg-nc.com> (raw)
In-Reply-To: <46633.10.1.1.53.1208236287.squirrel@10.1.1.31>
References: <46633.10.1.1.53.1208236287.squirrel@10.1.1.31>
yogesh@banasdairy.coop wrote:
> i have a backup of data folder of my old postgresql database on 7.54
>
> now i want to restore my complete database from data folder in ver 8.1
>
I assume you mean you wish to upgrade your 7.4 installation of
PostgreSQL to PostgreSQL 8.1 ?
The short answer:
You'll need to start the 7.4 version of the server, with your old data
directory and run the version of 'pg_dumpall' that comes with PostgreSQL
8.1 . Once you've generated a dump and saved it, you can install 8.1
and then use the 'psql' utility to re-load the dump on 8.1 . The 7.4
data directory isn't compatible with 8.1, so you'll need to perform the
dump and subsequent restore.
You'll probably also want to go through the 7.4 pg_hba.conf and
postgresql.conf files and port over any changes you need that are 8.1
compatible.
--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
919-463-0999/877-258-8987
http://www.otg-nc.com
Expert PostgreSQL & PostGIS training - delivered worldwide.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: chander@otg-nc.com, yogesh@banasdairy.coop
Subject: Re: Restore Database From data folder
In-Reply-To: <481F8C6C.8040406@otg-nc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox