From: Steve Howe <howe@carcass.dhs.org>
To: pgsql-interfaces-owner@postgresql.org, ozric tentacle <ozric02@yahoo.gr>
Cc: pgsql-questions@postgresql.org
Cc: pgsql-interfaces@postgresql.org
Subject: Re: HELP FOR POSTGRESQL NEEDED...
Date: Mon, 8 Jul 2002 13:41:33 -0300
Message-ID: <8495444191.20020708134133@carcass.dhs.org> (raw)
In-Reply-To: <20020706122244.55874.qmail@web13106.mail.yahoo.com>
References: <20020706122244.55874.qmail@web13106.mail.yahoo.com>
Hello ozric,
Saturday, July 6, 2002, 9:22:44 AM, you wrote:
ot> Hello.I am experiencing a quite strange behavior with my
ot> postgreSQL database.
ot> I have edited the file pg_hba.conf like this:
ot> # TYPE DATABASE IP_ADDRESS MASK AUTH_TYPE AUTH_ARGUMENT
ot> local all password
ot> host all 127.0.0.1 255.255.255.255 password
ot> in order to require user authentication.This works perfectly when
ot> I connect to the database with psql or pgaccess and I'm able to
ot> perform
ot> all kinds of queries.
ot> However when I try to connect to the database with C++ even though
ot> it allows me to connect (providing the correct username &
ot> password)
ot> all the queries fail...The C++ code I use is the following:
Did you start the postmaster with -i parameter so that it allows
TCP/IP connections ?
Run a nmap localhost command to check if your 5432 port is open. If
PostgreSQL is running and accepting connections, it should be listed
as open.
Psql will connect through unix sockets, not as TCP sockets.
-------------
Best regards,
Steve Howe mailto:howe@carcass.dhs.org
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: howe@carcass.dhs.org, ozric02@yahoo.gr, pgsql-questions@postgresql.org
Subject: Re: HELP FOR POSTGRESQL NEEDED...
In-Reply-To: <8495444191.20020708134133@carcass.dhs.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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