Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_database corrupted(?) If so, what do I do????

pg_database corrupted(?) If so, what do I do????

From
"Jonny Hinojosa"
Date:
Solaris 7 : snapshot dated 0506

The system has been running fine for several months.  Yesterday it crashed
and I have not been able to get it back.

This is the message I get when I try to access the db from psql :

bash-2.02$ psql
Connection to database 'cdmwhere' failed.
FATAL 1:  Database 'cdmwhere' does not exist.
        We know this because the directory '/data/base/cdmw H' does not
exist.
        You can create a database with the SQL command CREATE DATABASE.
        To see what databases exist, look at the subdirectories of
'/data/base/'
.

bash-2.02$

Why does it think the directory '/data/base/cdmw H' should exist?  Shouldn't
that be '/data/base/cdmwhere'?

Any ideas on how I can recover?
Jonny

RE: [GENERAL] pg_database corrupted(?) If so, what do I do????

From
"Jonny Hinojosa"
Date:
More info:

    bash-2.02$ psql -l
    datname  |datdba|encoding|datpath
    ---------+------+--------+---------
    template1|  1002|       0|template1
    jonny    |  1001|       0|jonny
    hom      |  1003|       0|H
    cdmwhere |  1005|       0|cdmw H
    (4 rows)

    bash-2.02$

The last 2 entries have been corrupted.  How do I (can I) correct these
entries ??????

Jonny



-----Original Message-----
From: owner-pgsql-general@postgreSQL.org
[mailto:owner-pgsql-general@postgreSQL.org]On Behalf Of Jonny Hinojosa
Sent: Monday, May 10, 1999 9:48 AM
To: PostgreSQL General
Subject: [GENERAL] pg_database corrupted(?) If so, what do I do????


Solaris 7 : snapshot dated 0506

The system has been running fine for several months.  Yesterday it crashed
and I have not been able to get it back.

This is the message I get when I try to access the db from psql :

bash-2.02$ psql
Connection to database 'cdmwhere' failed.
FATAL 1:  Database 'cdmwhere' does not exist.
        We know this because the directory '/data/base/cdmw H' does not
exist.
        You can create a database with the SQL command CREATE DATABASE.
        To see what databases exist, look at the subdirectories of
'/data/base/'
.

bash-2.02$

Why does it think the directory '/data/base/cdmw H' should exist?  Shouldn't
that be '/data/base/cdmwhere'?

Any ideas on how I can recover?
Jonny

RE: [GENERAL] pg_database corrupted(?) If so, what do I do????

From
Herouth Maoz
Date:
At 22:26 +0300 on 10/05/1999, Jonny Hinojosa wrote:


> The last 2 entries have been corrupted.  How do I (can I) correct these
> entries ??????

Have you tried logging into psql (template1) as postgres and updating the
pg_database table?

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma