RE: pgaccess not connecting

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(at)jagua(dot)cfg(dot)sld(dot)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(at)jagua(dot)cfg(dot)sld(dot)cu
>http://jagua.cfg.sld.cu/~aneiros
>
>On Sat, 26 Aug 2000, Tom Lane wrote:
>
>> Bill Barnes <bbarnes(at)operamail(dot)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
>>