| 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: | Whole Thread | Raw Message | 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 |