Réf. : Re: File systems backup problem

For the moment the problem isn't resolv but i'm working on.

I want to know. What is the files under the directory  pg_xlog.
Is this directory contains the logs for the systems transactions ?

I ask this questions because when i restore the filesystem.
When i firts restart the database. The postmaster say :
     - Database not shutdown cleanly
     - Redo

So perhaps when the postamaster restart, the action made by the redo  tell
the postamaster that the database test doesn't exists ????
Is there other possibility ?






                 
                    "Rajesh Kumar Mallah."
                 
                    <mallah@trade-india.co        Pour :  l.malaspina@focal.fr
                 
                    m>                            cc :    pgsql-admin <pgsql-admin@postgresql.org>
                 
                    Envoyé par :                  Objet :      Re: [ADMIN] File systems   backup problem
                 
                    pgsql-admin-owner@post
                 
                    gresql.org
                 

                 

                 
                    26/05/02 12:30
                 

                 

                 





Did you problem finally got resolved?


regds
mallah.

On Thursday 23 May 2002 09:13 pm, l.malaspina@focal.fr wrote:
> Sorry for CC,
>
> psql -h 192.168.133.15 -l
>      List of  available databases :
>
>       Name       |  Owner
> -----------------+----------
>  template0       | alf
>  template1       | alf
>  otherdb       | alf
>
> Directory base :
>
> [alf@cpa-linux3 base]$ ll
> total 24
> drwx------    2 alf      alf          4096 mai 23 07:36 1
> drwx------    2 alf      alf          4096 mar 28 15:39 16555
> drwx------    3 alf      alf          8192 mai 22 17:27 31450335
> drwx------    2 alf      alf          4096 mai 22 17:27 45136415
> drwx------    2 alf      alf          4096 mai 23 16:24 46004129
>
> And if i undestand what you say, normally i would have 5 database return
by
> the command "psql -l" and i have only 3.
>
>
>
>
>
>                     "Rajesh Kumar
>                     Mallah."              Pour :  l.malaspina@focal.fr
>                     <mallah@trade-        cc :    pgsql-admin
> <pgsql-admin@postgresql.org> india.com>            Objet :      Re: Réf.
:
> Re: [ADMIN] File systems   backup problem
>
>                     23/05/02 17:16
>
>
>
>
>
>
> 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?

--
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.



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly