From: Baudrion Philippe <Philippe.Baudrion@adm.unige.ch>
To: pgsql-admin@postgresql.org
Subject: Retore Postgres DB without dump
Date: Fri, 11 Apr 2008 16:14:05 +0200
Message-ID: <47FF722D.20705@adm.unige.ch> (raw)
Hello all,
I had a look at your last year archive without finding my solution, but
I suppose it's a common problem.
I am trying to restore an old database from their relations files, I
don't have any dump, is it possible and how ?
System information:
Original - db: Postgres v.7.4, OS: Linux Mandriva 2006
Current - db: Postgres v.8.1.11, OS: Suse SLES10sp1
What I have tried is :
- To copy the files directly in an empyty db, I got a message like this
when trying to connect: "Error: wrong files version, these are 7.4 files
version and you are running 8.1"
- So, I have build and installed a 7.4 version of Postgres
- Copy the files in an empty database
- Connection was ok, but "\dt" told me "no relations found".
What can I try next ?
I also have the original "pg_clog" and "pg_xlog" directories, and I have
also tried to replace them. What can I do with the WAL segments ?
Thanks for your help,
Philippe
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Philippe.Baudrion@adm.unige.ch
Subject: Re: Retore Postgres DB without dump
In-Reply-To: <47FF722D.20705@adm.unige.ch>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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