Skip site navigation (1) Skip section navigation (2)

Re: Recover data

From: jseymour(at)LinxNet(dot)com (Jim Seymour)
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Recover data
Date: 2004-04-27 21:50:03
Message-ID: 20040427215003.28805430E@jimsun.LinxNet.com (view raw or flat)
Thread:
Lists: pgsql-admin
eups(at)cefet-al(dot)br wrote:
> 
> 
> Hello,
>    I have a problem and I would like somebody help me.
>    Well, i have a data base server that was formated, unfortunatelly it wasn't 
> made the dump of the postgres, but it was saved the directory of the postgres.
>    How can to recover my data, is it possible?

It sounds like what you're saying is that, although you didn't do a
dump, from which you can restore, you do have a copy of the old pgsql
database directory still intact.  If so: Just shut down pgsql, point
PGDATA at the old directory (which I would carefully back up, first!)
and re-start pgsql.  Providing the server version hasn't changed, all
should be well.

-- 
Jim Seymour                | Spammers sue anti-spammers:
jseymour(at)LinxNet(dot)com       |     http://www.LinxNet.com/misc/spam/slapp.php
http://jimsun.LinxNet.com  | Please donate to the SpamCon Legal Fund:
                           |     http://www.spamcon.org/legalfund/

In response to

pgsql-admin by date

Next:From: Christopher Kings-LynneDate: 2004-04-28 01:30:44
Subject: Re: [JDBC] [PERFORM] is a good practice to create an index on the
Previous:From: Edoardo CeccarelliDate: 2004-04-27 21:42:58
Subject: Re: [JDBC] [PERFORM] is a good practice to create an index on the

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group