pgaccess not connecting
Running Debian 2.2.
Had to reinstall postgresql 7.02
Can access database with psql but not pgaccess.
The log that follows is from a stop and restart of postmaster.
Script started on Sat Aug 26 01:17:33 2000
kgb10:/home/billb# /etc/init.d/postgresql stop
Stopping PostgreSQL postmaster
Stopped /usr/lib/postgresql/bin/postmaster (pid 24386).
kgb10:/home/billb# /etc/init.d/postgresql stop
kgb10:/home/billb# /etc/init.d/postgreql start -i
Starting PostgreSQL postmaster
kgb10:/home/billb# ps ax | grep postmaster
24746 pts/5 S 0:00 /usr/lib/postgresql/bin/postmaster -b
/usr/lib/postgresql/bin/postgres -B 128 -D
/var/lib/postgres/data -d 0
24749 pts/5 S 0:00 grep postmaster
kgb10:/home/billb# ls -al /tmp | grep .s.PGSQL
srwxrwxrwx 1 postgres postgres 0 Aug 26 01:18 .s.PGSQL.5432
kgb10:/home/billb# exit
What could account for the missing -i switch in the running postmaster?
The last 2 lines of /etc/init.d/postgresql/pg_hda.conf:
# By default, allow anything over UNIX domain sockets and localhost.
local all trust
host all 127.0.0.1 255.255.255.255 trust
Thanks
Bill Barnes
Bill Barnes <bbarnes@operamail.com> writes:
kgb10:/home/billb# /etc/init.d/postgreql start -i
Starting PostgreSQL postmaster
kgb10:/home/billb# ps ax | grep postmaster
24746 pts/5 S 0:00 /usr/lib/postgresql/bin/postmaster -b
/usr/lib/postgresql/bin/postgres -B 128 -D
/var/lib/postgres/data -d 0
What could account for the missing -i switch in the running postmaster?
Are you sure your /etc/init.d/postgreql is designed to pass its own
commandline switches on to the invoked postmaster? Usually startup
scripts don't do that, since they are not designed to be run by hand
but from /etc/rc. My bet is that there is a config file somewhere that
the init.d script is reading (which is where the other switches given
to the postmaster are coming from). You need to put -i in that file.
regards, tom lane
That's it.
Found the switch in /etc/postgresql/postmaster.init.
Thank you very much,
Bill
Show quoted text
===== Original Message From Tom Lane <tgl@sss.pgh.pa.us> =====
Bill Barnes <bbarnes@operamail.com> writes:kgb10:/home/billb# /etc/init.d/postgreql start -i
Starting PostgreSQL postmaster
kgb10:/home/billb# ps ax | grep postmaster
24746 pts/5 S 0:00 /usr/lib/postgresql/bin/postmaster -b
/usr/lib/postgresql/bin/postgres -B 128 -D
/var/lib/postgres/data -d 0What could account for the missing -i switch in the running postmaster?
Are you sure your /etc/init.d/postgreql is designed to pass its own
commandline switches on to the invoked postmaster? Usually startup
scripts don't do that, since they are not designed to be run by hand
but from /etc/rc. My bet is that there is a config file somewhere that
the init.d script is reading (which is where the other switches given
to the postmaster are coming from). You need to put -i in that file.regards, tom lane
Import Notes
Resolved by subject fallback
Check the script in /etc/rc.d/init.d/postgresql it doesn't accept
parameters in the command linea except start, stop, status. Change the
line that runs postmaster adding -i option.
--
Jesus Aneiros Sosa
mailto:aneiros@jagua.cfg.sld.cu
http://jagua.cfg.sld.cu/~aneiros
On Sat, 26 Aug 2000, Tom Lane wrote:
Show quoted text
Bill Barnes <bbarnes@operamail.com> writes:
kgb10:/home/billb# /etc/init.d/postgreql start -i
Starting PostgreSQL postmaster
kgb10:/home/billb# ps ax | grep postmaster
24746 pts/5 S 0:00 /usr/lib/postgresql/bin/postmaster -b
/usr/lib/postgresql/bin/postgres -B 128 -D
/var/lib/postgres/data -d 0What could account for the missing -i switch in the running postmaster?
Are you sure your /etc/init.d/postgreql is designed to pass its own
commandline switches on to the invoked postmaster? Usually startup
scripts don't do that, since they are not designed to be run by hand
but from /etc/rc. My bet is that there is a config file somewhere that
the init.d script is reading (which is where the other switches given
to the postmaster are coming from). You need to put -i in that file.regards, tom lane
Thanks for the response.
You will already have my last posting. The script, BTW, I referred to at
/etc/postgresql/postmaster.init has the tag PGALLOWTCPIP=yes/no and the
default is no.
regards,
Bill
Show quoted text
===== Original Message From Jesus Aneiros <aneiros@jagua.cfg.sld.cu> =====
Check the script in /etc/rc.d/init.d/postgresql it doesn't accept
parameters in the command linea except start, stop, status. Change the
line that runs postmaster adding -i option.--
Jesus Aneiros Sosa
mailto:aneiros@jagua.cfg.sld.cu
http://jagua.cfg.sld.cu/~aneirosOn Sat, 26 Aug 2000, Tom Lane wrote:
Bill Barnes <bbarnes@operamail.com> writes:
kgb10:/home/billb# /etc/init.d/postgreql start -i
Starting PostgreSQL postmaster
kgb10:/home/billb# ps ax | grep postmaster
24746 pts/5 S 0:00 /usr/lib/postgresql/bin/postmaster -b
/usr/lib/postgresql/bin/postgres -B 128 -D
/var/lib/postgres/data -d 0What could account for the missing -i switch in the running postmaster?
Are you sure your /etc/init.d/postgreql is designed to pass its own
commandline switches on to the invoked postmaster? Usually startup
scripts don't do that, since they are not designed to be run by hand
but from /etc/rc. My bet is that there is a config file somewhere that
the init.d script is reading (which is where the other switches given
to the postmaster are coming from). You need to put -i in that file.regards, tom lane
Import Notes
Resolved by subject fallback