pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / 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