Thread: Postgresql 7.1 "No database files found"

Postgresql 7.1 "No database files found"

From
meaghana@magtech.com.au (Meaghan)
Date:
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@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

Re: Postgresql 7.1 "No database files found"

From
"Henshall, Stuart - WCP"
Date:
In 7.1 the directory names changed to be the oids. It appears to
be you're start up script that is at fault.
Hope this helps,
- Stuart

> -----Original Message-----
> From: meaghana@magtech.com.au [mailto:meaghana@magtech.com.au]
> Sent: 05 March 2002 07:03
>
>
> 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@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
>