Re: Backup DB not getting connected

From: Shane Ambler <pgsql(at)007Marketing(dot)com>
To: J S B <jsbali(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Backup DB not getting connected
Date: 2006-10-13 18:22:39
Message-ID: 452FD96F.4010600@007Marketing.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2006-10-13 18:32:26 Re: more anti-postgresql FUD
Previous Message Tom Lane 2006-10-13 18:19:12 Re: some log statements ignored