Skip site navigation (1) Skip section navigation (2)

Re: Need help to restore database

From: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
To: adamr(at)informatyka(dot)gdansk(dot)pl
Cc: "Lori, Giancarlo" <giancarlo(dot)lori(at)eds(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Need help to restore database
Date: 2009-03-17 13:32:16
Message-ID: 20090317133216.GB11376@cns.vt.edu (view raw or flat)
Thread:
Lists: pgsql-admin
On Tue, Mar 17, 2009 at 12:01:01PM +0100, adamr(at)informatyka(dot)gdansk(dot)pl wrote:
> On Tue, 17 Mar 2009 09:50:55 +0100, "Lori, Giancarlo"
> <giancarlo(dot)lori(at)eds(dot)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)



In response to

pgsql-admin by date

Next:From: Simon RiggsDate: 2009-03-17 14:10:20
Subject: Re: Need help to restore database
Previous:From: c kDate: 2009-03-17 13:27:35
Subject: Re: [GENERAL] different results for large objects

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group