Re: File systems backup problem - Mailing list pgsql-admin

From Rajesh Kumar Mallah.
Subject Re: File systems backup problem
Date
Msg-id 200205231714.41143.mallah@trade-india.com
Whole thread Raw
In response to File systems backup problem  (l.malaspina@focal.fr)
List pgsql-admin
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.



pgsql-admin by date:

Previous
From: Andreas Schlegel
Date:
Subject: Postgresql support
Next
From: "Rajesh Kumar Mallah."
Date:
Subject: Re: Réf. : Re: [ADMIN] File systems