From: Jose Aparicio <aparicio@bgumail.bgu.ac.il>
To: vincent leycuras <e97249@essec.fr>
To: pgsql-docs@postgresql.org
Subject: Re: [DOCS] prob with pgaccess
Date: Tue, 31 Aug 1999 17:43:01 +0200
Message-ID: <004c01bef3c7$81d2f440$21754884@macareux> (raw)
References: <001401bef390$415ff340$18bfdcc3@sical.crhea.cnrs.fr>
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
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-docs@postgresql.org
Cc: aparicio@bgumail.bgu.ac.il, e97249@essec.fr
Subject: Re: [DOCS] prob with pgaccess
In-Reply-To: <004c01bef3c7$81d2f440$21754884@macareux>
* 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