Thread: Using pgaccess and xpg

Using pgaccess and xpg

From
Michal Lijowski
Date:
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


Re: Using pgaccess and xpg

From
Sean Davis
Date:
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