Discussion:
Recover data
(too old to reply)
e***@cefet-al.br
2004-04-27 19:25:31 UTC
Permalink
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?
[]'s Eunice


-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html
Jim Seymour
2004-04-27 21:50:03 UTC
Permalink
Post by e***@cefet-al.br
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:
***@LinxNet.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/

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org
Loading...