Re: Need help to restore database - Mailing list pgsql-admin

From Ray Stell
Subject Re: Need help to restore database
Date
Msg-id 20090317133216.GB11376@cns.vt.edu
Whole thread Raw
In response to Re: Need help to restore database  (<adamr@informatyka.gdansk.pl>)
List pgsql-admin
On Tue, Mar 17, 2009 at 12:01:01PM +0100, adamr@informatyka.gdansk.pl wrote:
> On Tue, 17 Mar 2009 09:50:55 +0100, "Lori, Giancarlo"
> <giancarlo.lori@eds.com> wrote:
> > the postmaster process run, but any command pg_dump, etc I try to
> > execute failed. The system respond that there are not database in the
> > system. Can anyone help us ?


I'm no expert, the quiet from the pros is deafening to me.

What does the postmaster log say when you start up?
What is the exact error msg that you refer to as "there are not database in the system?"
What does the \l meta-command say, anything like this:

template1=# \l
        List of databases
    Name     |  Owner  | Encoding
-------------+---------+----------
 postgres    | pgadmin | UTF8
 template0   | pgadmin | UTF8
 template1   | pgadmin | UTF8
(3 rows)



pgsql-admin by date:

Previous
From: c k
Date:
Subject: Re: [GENERAL] different results for large objects
Next
From: Simon Riggs
Date:
Subject: Re: Need help to restore database