Re: Backup DB not getting connected

The user in the client machine is usrxyz (a unix user role) and user role
that owns newDB is userxyz (a db user role)....
works fine with another database in the same database server with same user
role combination.
Don't know whats going wrong..

On 10/13/06, Shane Ambler <pgsql(at)007marketing(dot)com> wrote:
>
> 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.
>