Обсуждение: Restore Database From data folder

hi all<br /><br />i have a backup of data folder of my old  postgresql database on 7.54<br /><br />now i want to
restoremy complete database from data folder in ver 8.1<br /><br />so can any gurus give me the idea about it<br /><br
/>Yogesh<br/>Senior Officer (System)<br /><br /><br /><br /><br />-- <br />This message has been scanned for viruses
and<br />dangerous content by <a href="http://www.banasdairy.coop/"><b>BanasDairy(Amul)</b></a>, and is <br />believed
tobe clean.  

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.