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
>