Thread: pgaccess

pgaccess

From
"Eduardo José Hernández Cisneros"
Date:
Hi, I am a new user of PostgreSQL and  a new user of RedHat Linux 7.2. I
installed PostgreSQL 7.2 (http://people.redhat.com/teg/pg/) I would like to
use "pgaccess" to manipulate my databases, but when I run:

%pgaccess atpcdb

I got this error:

Error trying to connect to database 'atpcdb' on host localhost.
PostgreSQL error message: Connection to database failed
Could not connect to server: Connection refused
Is the server running on host localhost and accepting TCP/IP connections on
port 5432?

I suppose that I need to add -i option to the database server (postmaster)
but in the scrip file: /etc/init.d/postgresql I do not know where to add it.
Is it right? How can I resolve this?

Best Regards

Eduardo


_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com


Re: pgaccess

From
Oliver Elphick
Date:
On Wed, 2002-02-27 at 22:34, Eduardo Jos Hernndez Cisneros wrote:
> Hi, I am a new user of PostgreSQL and  a new user of RedHat Linux 7.2. I
> installed PostgreSQL 7.2 (http://people.redhat.com/teg/pg/) I would like to
> use "pgaccess" to manipulate my databases, but when I run:
>
> %pgaccess atpcdb
>
> I got this error:
>
> Error trying to connect to database 'atpcdb' on host localhost.
> PostgreSQL error message: Connection to database failed
> Could not connect to server: Connection refused
> Is the server running on host localhost and accepting TCP/IP connections on
> port 5432?
>
> I suppose that I need to add -i option to the database server (postmaster)

Not unless you _want_to enable TCP/IP access.  If you have nothing at
all in the host field in pgaccess' connect dialog, it will use Unix
sockets instead.  If you have "localhost" it uses TCP/IP on the loopback
interface.

> but in the scrip file: /etc/init.d/postgresql I do not know where to add it.
> Is it right? How can I resolve this?

Add

 tcpip_socket = yes

in postgresql.conf, or use "-o -i" as an option to pg_ctl (if that is
what is used in the init.d script).

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "Give, and it will be given to you. A good measure,
      pressed down, taken together and running over,
      will be poured into your lap. For with the same
      measure that you use, it will be measured to
      you."         Luke 6:38