From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | rodneyr(at)embratel(dot)com(dot)br |
Cc: | pgsql-interfaces(at)hub(dot)org |
Subject: | Re: [INTERFACES] Opening database with PGACCESS |
Date: | 1999-08-02 04:33:12 |
Message-ID: | 29872.933568392@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
rodneyr(at)embratel(dot)com(dot)br writes:
> When I try to open my database (mydb) with the pgaccess, I receive the
> following message:
> "Error connecting database. Connection to database failed
> connectDB() failed: Is the postmaster running and accepting
> TCP/IP (with -i) connections at 'localhost' on port '5432'"
> The postmaster is running and I can connect to mydb using "psql":
>> psql mydb
psql defaults to connecting via Unix sockets. If you make it connect
via TCP (by saying "psql -h localhost mydb") I'll bet it fails too.
Most likely, your pg_hba.conf is set up to allow Unix socket connections
but not TCP connections, not even from localhost.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Brandon Huey | 1999-08-02 07:04:54 | Re: [Interfaces] Read-Only ODBC, MS/ACCESS |
Previous Message | Oliver Elphick | 1999-08-02 04:31:08 | Re: [INTERFACES] Opening database with PGACCESS |