pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedOpening database with PGACCESS
4+ messages / 4 participants
[nested] [flat]
* Opening database with PGACCESS
@ 1999-08-02 00:41 rodneyr@embratel.com.br
1999-08-02 04:31 ` Re: [INTERFACES] Opening database with PGACCESS Oliver Elphick <olly@lfix.co.uk>
1999-08-02 04:33 ` Re: [INTERFACES] Opening database with PGACCESS Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 4+ messages in thread
From: rodneyr@embratel.com.br @ 1999-08-02 00:41 UTC (permalink / raw)
To: pgsql-interfaces@hub.org
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
"Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: mydb
mydb=> "
Which is the problem? How can I fix it?
Thanks,
Rodney.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] Opening database with PGACCESS
1999-08-02 00:41 Opening database with PGACCESS rodneyr@embratel.com.br
@ 1999-08-02 04:31 ` Oliver Elphick <olly@lfix.co.uk>
1999-08-02 08:44 ` Re: Opening database with PGACCESS Eric Marsden <emarsden@mail.dotcom.fr>
1 sibling, 1 reply; 4+ messages in thread
From: Oliver Elphick @ 1999-08-02 04:31 UTC (permalink / raw)
To: rodneyr@embratel.com.br; +Cc: pgsql-interfaces@hub.org
rodneyr@embratel.com.br wrote:
>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":
pgaccess uses a TCP/IP connection through localhost, so you have to use the
-i option when starting the postmaster, even though you have no other
machines connecting to it.
--
Vote against SPAM: http://www.politik-digital.de/spam/
========================================
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
"All scripture is given by inspiration of God, and is
profitable for doctrine, for reproof, for correction,
for instruction in righteousness;"
II Timothy 3:16
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Opening database with PGACCESS
1999-08-02 00:41 Opening database with PGACCESS rodneyr@embratel.com.br
1999-08-02 04:31 ` Re: [INTERFACES] Opening database with PGACCESS Oliver Elphick <olly@lfix.co.uk>
@ 1999-08-02 08:44 ` Eric Marsden <emarsden@mail.dotcom.fr>
0 siblings, 0 replies; 4+ messages in thread
From: Eric Marsden @ 1999-08-02 08:44 UTC (permalink / raw)
To: pgsql-interfaces@hub.org
>>>>> "oe" == Oliver Elphick <olly@lfix.co.uk> writes:
rod> "Error connecting database. Connection to database failed
rod> connectDB() failed: Is the postmaster running and accepting
rod> TCP/IP (with -i) connections at 'localhost' on port '5432'"
rod>
rod> The postmaster is running and I can connect to mydb using "psql":
oe> pgaccess uses a TCP/IP connection through localhost, so you have
oe> to use the -i option when starting the postmaster, even though
oe> you have no other machines connecting to it.
well, there's a trick to get around that. If you provide an empty host
name and port number in the pgaccess connection dialog, it will switch
to a unix socket connection, and will work even without `-i'.
Has worked for me in the past, anyway.
--
Eric Marsden
It's elephants all the way down
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] Opening database with PGACCESS
1999-08-02 00:41 Opening database with PGACCESS rodneyr@embratel.com.br
@ 1999-08-02 04:33 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 4+ messages in thread
From: Tom Lane @ 1999-08-02 04:33 UTC (permalink / raw)
To: rodneyr@embratel.com.br; +Cc: pgsql-interfaces@hub.org
rodneyr@embratel.com.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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~1999-08-02 08:44 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-08-02 00:41 Opening database with PGACCESS rodneyr@embratel.com.br
1999-08-02 04:31 ` Oliver Elphick <olly@lfix.co.uk>
1999-08-02 08:44 ` Eric Marsden <emarsden@mail.dotcom.fr>
1999-08-02 04:33 ` Tom Lane <tgl@sss.pgh.pa.us>
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