Hi ,
I would appreciate if you mark a CC to the mailing list also
in future communications so that others also get to know.
please find my answer inlined.
On Thursday 23 May 2002 08:35 pm, l.malaspina@focal.fr wrote:
> Database "test" does not exist in the system catalog.)
Can you connect to database template1 ?
what does "psql -l" gives? eg in my case it gives
psql -h 192.168.0.11 -U tradein -l
List of databases
Name | Owner
-----------------+----------
access_log | tradein
rt2 | postgres
sysstat | tradein
template0 | postgres
template1 | postgres
tradein_clients | tradein
(6 rows)
are you sure the database "test" existed while the filesystem backup was taking place.
howmany folders are existing inside /var/lib/pgsql/data/base currently?
each folder there corresponds to one database in my case eg it is
[root@system11 base]# ls -l
total 48
drwx------ 2 postgres postgres 4096 Apr 29 01:55 1
drwx------ 2 postgres postgres 4096 Apr 29 01:55 16555
drwx------ 3 postgres postgres 28672 May 23 16:11 378968
drwx------ 2 postgres postgres 4096 Apr 29 02:07 378969
drwx------ 2 postgres postgres 4096 May 21 16:18 7865515
drwx------ 2 postgres postgres 4096 May 23 20:36 8990396
[root@system11 base]#
do such folders exists in your case?
regds
Mallah.
>
> Perhaps the directory '/var/lib/pgsql/data/' should be clean before the
> restore of the database ?
> Any idea ?
>
>
>
>
> "Rajesh Kumar Mallah."
> <mallah@trade-india.co Pour :
> l.malaspina@focal.fr, pgsql-admin@postgresql.org m>
> cc :
> Envoyé par : Objet : Re: [ADMIN]
> File systems backup problem pgsql-admin-owner@post
> gresql.org
>
>
> 23/05/02 13:44
>
>
>
>
>
>
> 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.