Postgresql 7.1 "No database files found"

From: meaghana(at)magtech(dot)com(dot)au (Meaghan)
To: pgsql-admin(at)postgresql(dot)org
Subject: Postgresql 7.1 "No database files found"
Date: 2002-03-05 07:02:51
Message-ID: 794514bc.0203042302.436a32d0@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

We recently installed pgsql 7.1 on Mandrake 8.1, and did a pg_dumpall
to import our old pgsql 7.0.2 databases.

This morning, we tried to restart postgresql after a system crash, and
we find that we suddenly have an error starting postgresql with the
following message:

[root(at)ocean home]# /etc/init.d/postgresql start
Checking postgresql installation: no database files found.
[ OK ]
Starting postgresql service: [FAILED]

The strange thing is, is that the database and postgresql/postmaster
etc has been running for a month with no problems.

By looking at the startup script, we noted that it needs a "template1"
directory, which we don't seem to have. We restored an old backup of
the pgsql directory, and it doesn't seem to exist there either. So
basically, we are not sure whether we have lost files in a system
crash, or something really weird is going on with postgresql.

After doing an initdb, we noticed that template1 directory was
actually renamed to /var/lib/pgsql/data/1. Do this simply mean that
the startup script is incorrect?

Does anyone have any suggestions?

TIA,

Meaghan

Browse pgsql-admin by date

  From Date Subject
Next Message Gaetano Mendola 2002-03-05 15:38:38 Re: postmaster problem....
Previous Message Tom Lane 2002-03-05 06:41:10 Re: index item size 4496 exceeds maximum 2713