Re: Postgresql 7.1 "No database files found" - Mailing list pgsql-admin

From Henshall, Stuart - WCP
Subject Re: Postgresql 7.1 "No database files found"
Date
Msg-id E2870D8CE1CCD311BAF50008C71EDE8E01F7481D@MAIL_EXCHANGE
Whole thread Raw
In response to Postgresql 7.1 "No database files found"  (meaghana@magtech.com.au (Meaghan))
List pgsql-admin
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
>

pgsql-admin by date:

Previous
From: "Henshall, Stuart - WCP"
Date:
Subject: Re: can i use it on windows
Next
From: "Henshall, Stuart - WCP"
Date:
Subject: Re: client connection