Re: Réf. : Re: [ADMIN] File systems - Mailing list pgsql-admin

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.