pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedprob with pgaccess
2+ messages / 2 participants
[nested] [flat]
* prob with pgaccess
@ 1999-08-31 09:07 vincent leycuras <e97249@essec.fr>
0 siblings, 1 reply; 2+ messages in thread
From: vincent leycuras @ 1999-08-31 09:07 UTC (permalink / raw)
To: pgsql-docs@hub.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [DOCS] prob with pgaccess
@ 1999-08-31 15:43 Jose Aparicio <aparicio@bgumail.bgu.ac.il>
parent: vincent leycuras <e97249@essec.fr>
0 siblings, 0 replies; 2+ messages in thread
From: Jose Aparicio @ 1999-08-31 15:43 UTC (permalink / raw)
To: vincent leycuras <e97249@essec.fr>; pgsql-docs
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1999-08-31 15:43 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-08-31 09:07 prob with pgaccess vincent leycuras <e97249@essec.fr>
1999-08-31 15:43 ` Jose Aparicio <aparicio@bgumail.bgu.ac.il>
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