From: | "Jonny Hinojosa" <Jonny(at)TCA(dot)net> |
---|---|
To: | "PostgreSQL General" <pgsql-general(at)postgreSQL(dot)org> |
Subject: | RE: [GENERAL] pg_database corrupted(?) If so, what do I do???? |
Date: | 1999-05-10 19:26:36 |
Message-ID: | 000701be9b1b$050e5440$03000004@TCA.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)postgreSQL(dot)org
[mailto:owner-pgsql-general(at)postgreSQL(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-05-10 21:31:15 | IRC, webcam, IM |
Previous Message | Bruce Momjian | 1999-05-10 16:46:27 | Re: [GENERAL] cluster truncates table name? |