Received: from mail.mailbox.ro (mail.mailbox.ro [193.226.118.6])
	by postgresql.org (8.11.3/8.11.4) with ESMTP id f7PFlof70977;
	Sat, 25 Aug 2001 11:47:50 -0400 (EDT)
	(envelope-from sorin.mocanu@sealite.ro)
Received: from zoryn ([217.156.79.219])
	by mail.mailbox.ro (8.11.0/8.11.0) with SMTP id f7PEoBo12672;
	Sat, 25 Aug 2001 17:50:16 +0300
Message-ID: <000b01c12d7d$4542eb60$db4f9cd9@zoryn>
From: "Sorin Mocanu" <sorin.mocanu@sealite.ro>
To: <pgsql-docs@postgresql.org>, <pgsql-bugs@postgresql.org>
Subject: PSQL Problem
Date: Sat, 25 Aug 2001 18:47:30 +0300
Organization: Sealite Systems
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0008_01C12D96.653B8B70"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
X-Archive-Number: 200108/27
X-Sequence-Number: 914

This is a multi-part message in MIME format.

------=_NextPart_000_0008_01C12D96.653B8B70
Content-Type: text/plain;
	charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable

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 cras=
h was fatal and now PostgreSQL does not see any record and any table from a=
ny database anymore. The funny thing is that in the base directory there ar=
e directories with the names of our databases and inside - files with the n=
ames 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 wou=
ld need to know what to do to be able to fully recover my lost data that po=
stgres does not see. I am planning to install a newer version, but in the s=
ame 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


------=_NextPart_000_0008_01C12D96.653B8B70
Content-Type: text/html;
	charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-2" http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi !</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>My name is Sorin Mocanu and I am the datab=
ase=20
manager for Sealite Systems.</FONT></DIV>
<DIV><FONT face=3D"Arial CE" size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3D"Arial CE" size=3D2>I am running Postgresql 6.5.2 on a Re=
dhat=20
Linux OS. We've been using it for about an year and we had some crashes due=
 to=20
low disk space. The last crash was fatal and now PostgreSQL does not see an=
y=20
record and any table from any database anymore. The funny thing is that in =
the=20
base directory there are directories with the names of our databases and in=
side=20
- files with the names of the tables (between other pg_* files).</FONT></DI=
V>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3D"Arial CE" size=3D2>I have started to build a script that=
 will=20
recover the data inside, knowing the structure, and it seems to be working =
for=20
some records. However, I would need to know what to do to be able to fully=
=20
recover my lost data that postgres does not see. I am planning to install a=
=20
newer version, but in the same time I need to dump the data from the actual=
=20
db.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3D"Arial CE" size=3D2>Could you please help me with a link =
to an=20
appropriate Postgres utility or a table file format documentation ?</FONT><=
/DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3D"Arial CE" size=3D2>Thank you,</FONT></DIV>
<DIV><FONT face=3D"Arial CE" size=3D2>Sorin Mocanu</FONT></DIV>
<DIV>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_0008_01C12D96.653B8B70--