Re: Postgresql 7.1 "No database files found"

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
>