pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Upgrade Data from 7.x.x to 8.x.x 2+ messages / 2 participants [nested] [flat]
* Upgrade Data from 7.x.x to 8.x.x @ 2005-06-02 18:17 Patrick Brennan <patrick.brennan@bsdfirst.com> 2005-06-06 02:43 ` Re: Upgrade Data from 7.x.x to 8.x.x Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: Patrick Brennan @ 2005-06-02 18:17 UTC (permalink / raw) To: pgsql-admin Hi there, Hopefully a simple question. I have a copy of the data from an old PostgreSQL installation (it's not a dump, it's a copy of the PGDATA directory). I have two questions, is there a simple way for me to determine the version of PostgreSQL that this data belongs to? Secondly, is there anyway to import this data into PostgreSQL 8.0 without need to run a 7.x postmaster? Any suggestions would be greatly appreciated. Regards, Patrick B.T.W. For those curious, this data came from a RAID5 array in which two disks had failed. I spent a week messing with pyflag before I managed to recover this data. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Upgrade Data from 7.x.x to 8.x.x 2005-06-02 18:17 Upgrade Data from 7.x.x to 8.x.x Patrick Brennan <patrick.brennan@bsdfirst.com> @ 2005-06-06 02:43 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2005-06-06 02:43 UTC (permalink / raw) To: patrick.brennan@bsdfirst.com; +Cc: pgsql-admin "Patrick Brennan" <patrick.brennan@bsdfirst.com> writes: > Hopefully a simple question. I have a copy of the data from an old > PostgreSQL installation (it's not a dump, it's a copy of the PGDATA > directory). I have two questions, is there a simple way for me to > determine the version of PostgreSQL that this data belongs to? Read the PG_VERSION file that appears at the top level. > Secondly, is there anyway to import this data into PostgreSQL 8.0 > without need to run a 7.x postmaster? No. You need to run a matching 7.x postmaster and do pg_dumpall. regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-06-06 02:43 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2005-06-02 18:17 Upgrade Data from 7.x.x to 8.x.x Patrick Brennan <patrick.brennan@bsdfirst.com> 2005-06-06 02:43 ` Tom Lane <tgl@sss.pgh.pa.us>
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