Postgres Pro
Downloads
Home   >   mailing lists

Re: converting an old databaes to postgresql 8.1 - Mailing list pgsql-novice

From Frank Bax
Subject Re: converting an old databaes to postgresql 8.1
Date
Msg-id 4A775AB5.9060900@sympatico.ca
Whole thread Raw
In response to converting an old databaes to postgresql 8.1  (Roger D Vargas <roger@ehtsc.co.cu>)
Responses Re: converting an old databaes to postgresql 8.1  (Sean Davis <sdavis2@mail.nih.gov>)
List pgsql-novice
Tree view 
Roger D Vargas wrote:
> After a reinstall, I lost my most recent backup in sql format and
> instead I have the database directory. The big problem is that it is in
> some old format, 8.1 doesnt accept it and 8.0.15 neither. Is there any
> way to convert such database files to the recent format?



YES, install the same version that was used to create the database; then
create another backup.  The database directory should have a file called
PG_VERSION which contains this version number.

pgsql-novice by date:

Previous
From: Roger D Vargas
Date:
Subject: converting an old databaes to postgresql 8.1
Next
From: Lacey Powers
Date:
Subject: Re: Retrieve the primary key of a table