Did you start the postmaster with the -i flag. If not, you might try
that.
Sean
On Aug 10, 2004, at 12:31 PM, Michal Lijowski wrote:
> Hello,
>
> I have a question regarding settings which are necessary
> to use pgaccess and/or xpg with existing database which is
> located on localhost.
> I can access the database by invoking psql with name of database
> as well as through C++ program using libpqxx library.
>
> Invoking xpg produces window Connection to PostgreSQL with
> entries
>
> Host localhost
> Database database01
> User postgres
> Password
> Port 5432
>
> Replacing database01 and postgres with the existing User and
> existing database produces error message
> Connection refused. Check that the hostname and port is correct,
> and that the postmaster is running with the -i flag which enables
> TCP/IP networking.
>
> If I invoke pgaccess > sh pgaccess.tcl I am getting the similar
> message
>
> Error trying to connect to database 'RabStudies' on host localhost
>
> PostgreSQL error message: Connection to database failed
> could not connect to server:
> Is the server running on host "localhost"
> and accepting TCP/IP connection
> on port 5432?
>
> My platform is Fedora Core 2, postgresql-7.4.2-1 installed from rpm.
>
> I appreciate any comments.
>
> Michal
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend