Thread: prob with pgaccess

Salud Vincent,

If I understood your problem all you need is to restart the postmaster with
the "-i" option, this allows TCP/IP connects to the db system:
1.- stop the postmaster:
/etc/rc.d/init.d/postgresql stop
2.- edit the file"/etc/rc.d/init.d/postgresql " as root, adding this line:
------------------------------
case "$1" in
  start)
        echo -n "Starting postgresql service: "
        su postgres -c '/usr/bin/postmaster -i -S -D/var/lib/pgsql'
<<<<<<<
        sleep 1
        pid=`pidof postmaster
----------------------------------
3.- restart postmaster
/etc/rc.d/init.d/postgresql start

Now you need to allow connections to your database editing
/var/lib/pgsql/pg_hba.conf
and there u go!
Everything is explained in the file, although I have never managed to get
postgresql to deny a connection when I am giving the right loging but no
password. If anyone knows a doc on access rights, etc tell me please.
This file is readed on every new connection so you can edit it without
touching the pstmastr process.

Hope this was your question
Regards
J.Aparicio







----- Original Message -----
From: vincent leycuras
To: pgsql-docs@hub.org
Sent: Tuesday, August 31, 1999 11:07 AM
Subject: [DOCS] prob with pgaccess


Could someone help me please !!!!

I'm having problems with that TCI/IP connection pgaccess requires to connect
to the server. But I just can't figure out where to find a parameter to
change to make it work. I read in some magazine that it was called
PGALLOWTCPIP and that it was located in /etc/postmaster.init, but that file
just does not exist on my version (6.5.1), nor did exist on the previous one
I had (6.4.2)
Apparently, this problem extends to preventing me from making any client
connect to the postmaster
thanks in advance!! Vincent Leycuras