pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedQuestion about pgaccess
2+ messages / 2 participants
[nested] [flat]
* Question about pgaccess
@ 2000-10-25 19:37 Rich.Martin <Rich.Martin@wcom.com>
2000-10-27 05:20 ` Re: Question about pgaccess Constantin Teodorescu <teo@flex.ro>
0 siblings, 1 reply; 2+ messages in thread
From: Rich.Martin @ 2000-10-25 19:37 UTC (permalink / raw)
To: pgsql-interfaces@hub.org
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).
Any ideas?
Thanks,
Rich
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Question about pgaccess
2000-10-25 19:37 Question about pgaccess Rich.Martin <Rich.Martin@wcom.com>
@ 2000-10-27 05:20 ` Constantin Teodorescu <teo@flex.ro>
0 siblings, 0 replies; 2+ messages in thread
From: Constantin Teodorescu @ 2000-10-27 05:20 UTC (permalink / raw)
To: Rich.Martin <Rich.Martin@wcom.com>; 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-10-27 05:20 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-10-25 19:37 Question about pgaccess Rich.Martin <Rich.Martin@wcom.com>
2000-10-27 05:20 ` Constantin Teodorescu <teo@flex.ro>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox