Обсуждение: 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 >===== 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 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
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: > 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 >
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 >===== 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/~aneiros > >On 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 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 >>