RE : Re: Problem with template1 database

--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> a écrit :

> Michael Fuhr <mike(at)fuhr(dot)org> writes:
> > On Fri, Sep 15, 2006 at 02:46:21PM +0200, toto
> titi wrote:
> >> pg_dumpall: could not connect to database
> "template1": FATAL: database "template1" does not
> exist
> >> DETAIL: The database subdirectory
> "/var/lib/pgsql/data/base/1" is missing.
> >>
> >> And effectively the /var/lib/pgsql/data/base/1
> directory is missing on my server.
>
> > Do you know how template1's directory went
> missing? That's a mystery
> > that deserves investigation so you can prevent it
> from happening again.
>
> Indeed. If you don't know that, I'm not sure that
> I'd trust the cluster
> enough to try to continue to work with it. I'd
> suggest dumping whatever
> databases you have individually with pg_dump
> (instead of using
> pg_dumpall) and then initdb and reload. Note that
> pg_dump alone won't
> save info about your users and groups, so make notes
> about those so you
> can re-create them by hand.

Thanks Tom and Michael for your answers. After a try
on a test server, I've applied your procedure Tom and
now it works perfectly well!

I could not figure out why template1 directory went
missing.

--
Marc

___________________________________________________________________________
Découvrez un nouveau moyen de poser toutes vos questions quelque soit le sujet !
Yahoo! Questions/Réponses pour partager vos connaissances, vos opinions et vos expériences.
http://fr.answers.yahoo.com