Re: File systems backup problem

Hi There,

does the postmaster start successfully in you case.
i feel you are not specifying the right $PGDATA folder.

if you installed from RPM it shud be /var/lib/pgsql/data/
in redhat 7.2

i would suggest you start the postmaster in foreground and
observer the messages , if every thing is alright.

you can do it like this.

$ su -
# su - postgres
$ /usr/bin/postmaster -D  /var/lib/pgsql/data  -d 2  <enter>

observer for messages here........

it might go for recovery and it shud say
"database system is ready".

i would also suggest not connecting or
attemping to connect to it while recovering..

or better make tcpip_socket=false in postgresql.conf
while recovering..

please do not panic, we are here for all the help
;-)

regds
mallah.


On Thursday 23 May 2002 04:07 pm, l.malaspina@focal.fr wrote:
> I'm new to postgresql . I use the version 7.2 on RedHat 7.2
>
> I have made a mistake.  I drop a database but not the good database.
> And I have a file systems backup.
> But what I didn't know until now, is that the postmaster should be stop in
> order to make the backup.
> So when the backup is made, the postmaster isn't stop.
> And now when I want to use the backup in order to restore the database I
> drop, this doesn't work.
> The files are restored but when I restart the postmaster and want to
> connect to the restored database,
> the postmaster reply that it doesn't know the database in the system
> catalog.
>
> Is there a solution to repair the database  ?
>
> In advance, thanks for your reply.
>
> Malaspina Loic
> www.focalsystems.fr
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.