Re: Backup DB not getting connected - Mailing list pgsql-general

From Shane Ambler
Subject Re: Backup DB not getting connected
Date
Msg-id 452FD96F.4010600@007Marketing.com
Whole thread Raw
In response to Backup DB not getting connected  ("J S B" <jsbali@gmail.com>)
Responses Re: Backup DB not getting connected  ("J S B" <jsbali@gmail.com>)
Re: Backup DB not getting connected  ("J S B" <jsbali@gmail.com>)
List pgsql-general
J S B wrote:
> Hi,
> I took a back up of my database and restored it in a new DB..When I'm
> trying
> to connect to the new DB from a client machine using ECPG connection
> techniques, it says newDB doesn't exist.
> There's another DB in the same DB server and if I try and connect to
> that DB
> then it doesn't cry over anything.
>
> Thanks
> Jas
>
I am guessing that you can verify that the newDB exists and has the data
you just have trouble from the ECPG client from any machine.

I would check access privileges - does the user you log in as using ECPG
have access to newDB? - the 'DB doesn't exist' may be a wrong error
which should say access denied.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: some log statements ignored
Next
From: Stephen Frost
Date:
Subject: Re: more anti-postgresql FUD