| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Stefan Schwarzer <stefan(dot)schwarzer(at)grid(dot)unep(dot)ch> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Forgot to dump old data before re-installing machine |
| Date: | 2008-01-15 14:52:37 |
| Message-ID: | 20080115145237.GB7865@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-patches |
On Tue, Jan 15, 2008 at 02:42:05PM +0100, Stefan Schwarzer wrote:
> Thanks a lot for this. Still trying. But although the postmaster did
> run at one time, now, after copying back and forth, it doesn't want to
> do anything anymore... Gush, getting really frustrated...
If it really doesn't work, try this:
http://svana.org/kleptog/pgsql/pgfsck.html
Point it at the right directory and it can give you a dump of data.
It's not pretty, doesn't handle arrays or some of the less common
datatypes but it should get you 99% of the way.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stefan Schwarzer | 2008-01-15 15:12:28 | Re: Forgot to dump old data before re-installing machine |
| Previous Message | Richard Huxton | 2008-01-15 14:32:20 | Re: Postgres installation on Leopard; database on Mac-User-Level |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2008-01-15 14:54:51 | Re: SSL over Unix-domain sockets |
| Previous Message | Martijn van Oosterhout | 2008-01-15 14:23:53 | Re: SSL over Unix-domain sockets |