From: Sorin Mocanu <sorin.mocanu@sealite.ro>
To: pgsql-docs@postgresql.org
To: pgsql-bugs@postgresql.org
Subject: PSQL Problem
Date: Sat, 25 Aug 2001 18:47:30 +0300
Message-ID: <000b01c12d7d$4542eb60$db4f9cd9@zoryn> (raw)
Hi !
My name is Sorin Mocanu and I am the database manager for Sealite Systems.
I am running Postgresql 6.5.2 on a Redhat Linux OS. We've been using it for about an year and we had some crashes due to low disk space. The last crash was fatal and now PostgreSQL does not see any record and any table from any database anymore. The funny thing is that in the base directory there are directories with the names of our databases and inside - files with the names of the tables (between other pg_* files).
I have started to build a script that will recover the data inside, knowing the structure, and it seems to be working for some records. However, I would need to know what to do to be able to fully recover my lost data that postgres does not see. I am planning to install a newer version, but in the same time I need to dump the data from the actual db.
Could you please help me with a link to an appropriate Postgres utility or a table file format documentation ?
Thank you,
Sorin Mocanu
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-docs@postgresql.org
Cc: sorin.mocanu@sealite.ro, pgsql-bugs@postgresql.org
Subject: Re: PSQL Problem
In-Reply-To: <000b01c12d7d$4542eb60$db4f9cd9@zoryn>
* 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