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

Re: Question about pgaccess

From: Constantin Teodorescu <teo(at)flex(dot)ro>
To: "Rich(dot)Martin" <Rich(dot)Martin(at)wcom(dot)com>, PostgreSQL Interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: Question about pgaccess
Date: 2000-10-27 05:20:19
Message-ID: 39F91093.95AF4856@flex.ro (view raw or flat)
Thread:
Lists: pgsql-interfaces
"Rich.Martin" wrote:
> 
> Hello,
> Ok, I'll admit it I'm a newbee. However, I can't find an answer to this
> problem in the documentation anywhere.
> 
> I'm running Red Hat linux 6.1 and have my PostgreSQL server going (and I
> have -i variable set), and pgaccess starts up fine. I've created several
> users and databases in postgress, but when I go to open them in pgaccess I
> get the following message:
> 
>         Error trying to connect to database 'dbname' on host localhost
> 
>         PostgreSQL error message: Connection to 'database' failed FATAL 1: Database
> 'dbname' does not exist in pg_database"
> 
> So, I hunted down the file pg_database in the /var/lib/pgsql/ directory and
> opened it. The only thing in it is a $. How do I get PostgreSQL to write to
> that file, if it should? It was the only one with that name on the system.
> 
> The only thing I could think that might be wrong would be the path (Plus I
> never did find a file called .login in my home directory).

If psql could open that database, PgAccess should open it also.
are you opening PgAccess under a user that have been defined for
postgresql ?
try the same thing as 'postgres' user!

-- 
Constantin Teodorescu
General Investment Group
Braila, ROMANIA

In response to

pgsql-interfaces by date

Next:From: Peter MountDate: 2000-10-27 07:46:26
Subject: RE: JDBC 2.0 Api compliancy and integration
Previous:From: Jamie WalkerDate: 2000-10-27 00:26:25
Subject: Re: Re: new maintainer for the ODBC driver?

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