pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRestore Database From data folder
2+ messages / 2 participants
[nested] [flat]
* Restore Database From data folder
@ 2008-04-15 05:11 yogesh@banasdairy.coop
2008-05-05 22:38 ` Re: Restore Database From data folder Chander Ganesan <chander@otg-nc.com>
0 siblings, 1 reply; 2+ messages in thread
From: yogesh@banasdairy.coop @ 2008-04-15 05:11 UTC (permalink / raw)
To: pgsql-admin
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 restore my 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 to be clean.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Restore Database From data folder
2008-04-15 05:11 Restore Database From data folder yogesh@banasdairy.coop
@ 2008-05-05 22:38 ` Chander Ganesan <chander@otg-nc.com>
0 siblings, 0 replies; 2+ messages in thread
From: Chander Ganesan @ 2008-05-05 22:38 UTC (permalink / raw)
To: yogesh@banasdairy.coop; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-05-05 22:38 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-04-15 05:11 Restore Database From data folder yogesh@banasdairy.coop
2008-05-05 22:38 ` Chander Ganesan <chander@otg-nc.com>
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