Cant connect if -B 1024 was set to postmaster

I remember having this problem. You need to pass the '-i' switch.
Try: '-B 1024 -i'

I don't know if this behavior is an error or not.

Poul L. Christiansen

On Mon, 19 Mar 2001, Vilson farias wrote:

Great! Now it's ok. Thanks.

----- Original Message -----
From: Poul L. Christiansen <poulc@cs.auc.dk>
To: Vilson farias <vilson.farias@digitro.com.br>
Cc: <pgsql-general@postgresql.org>; SIMONE Carla MOSENA
<simone.mosena@digitro.com.br>
Sent: Segunda-feira, 19 de Mar�o de 2001 11:23
Subject: Re: [GENERAL] Cant connect if -B 1024 was set to postmaster

: I remember having this problem. You need to pass the '-i' switch.
: Try: '-B 1024 -i'
:
: I don't know if this behavior is an error or not.
:
: Poul L. Christiansen
:
: On Mon, 19 Mar 2001, Vilson farias wrote:
:
: > Greetings,
: >
: > There are a very weird problem here.
: >
: > I changed my /etc/rc.d/init.d/postgresql. The postmaster line now is :
: > su -l postgres -c "/usr/bin/pg_ctl -o '-B 1024' -D $PGDATA -p
: > /usr/bin/postmaster start >/dev/null 2>&1" < /dev/null
: >
: > That mean now are 8Mb (1024 buffers of 8Kb) available for postgres
: > processes. Ok, but if I set this '-B 1024' all my non-local connections
: > don't work. Then, If I simply remove this -B statement everything work
: > again. Besides, there are lots of -B configurations simply dont work
here,
: > like -B 2048, -B 4096... when I try to call /etc/rc.d/init.d/postgressql
: > start, it checks installation (ok), but postmaster fails.
: >
: > Do you know why this is happening?
: >
: > I'm using RedHat 6.2, AMD K6 400, 256Mb RAM with Postgre 7.0.2.
: > and a Pentium 75, 32Mb RAM, RedHat 6.2 with Postgre 7.0.3 and both has
the
: > same problem.
: >
: > Regards,
: >
: > Jos� Vilson de Mello de Farias
: >
: >
: >
: > ---------------------------(end of broadcast)---------------------------
: > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
: >
:

"Poul L. Christiansen" wrote:

On Mon, 19 Mar 2001, Vilson farias wrote:

I changed my /etc/rc.d/init.d/postgresql. The postmaster line now is :
su -l postgres -c "/usr/bin/pg_ctl -o '-B 1024' -D $PGDATA -p
/usr/bin/postmaster start >/dev/null 2>&1" < /dev/null

I remember having this problem. You need to pass the '-i' switch.
Try: '-B 1024 -i'

Add the line '-B 1024' to /var/lib/pgsql/data/pg_options along with the
-i that is there already, then restart with '/etc/rc.d/init.d/postgresql
restart'.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

Hmmmm, don't you mean /var/lib/pgsql/data/postmaster.opts ?

My pg_options file contains:
verbose=2
query=2
syslog=0

I'm running PostgreSQL 7.0.2 on Redhat 7.0.

Poul L. Christiansen

Lamar Owen wrote:

"Poul L. Christiansen" wrote:

Hmmmm, don't you mean /var/lib/pgsql/data/postmaster.opts ?

Yes, I do. Monday morning..... :-) GUC is much nicer in 7.1......one
file.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

3/19/2001 8:36:58 AM, "Vilson farias" <vilson.farias@digitro.com.br> wrote:

Great! Now it's ok. Thanks.

: I remember having this problem. You need to pass the '-i' switch.
: Try: '-B 1024 -i'

Can anyone shed some light on why adding '-i' worked?

Brent

"Brent R. Matzelle" <bmatzelle@yahoo.com> writes:

3/19/2001 8:36:58 AM, "Vilson farias" <vilson.farias@digitro.com.br> wrote:

Great! Now it's ok. Thanks.

: I remember having this problem. You need to pass the '-i' switch.
: Try: '-B 1024 -i'

Can anyone shed some light on why adding '-i' worked?

I'm guessing that he had a postmaster start script that defaulted to
providing -i, but only if no options were provided manually. I've
coded such things myself --- they usually seem like a good idea at
the time ...

regards, tom lane

"Brent R. Matzelle" wrote:

: I remember having this problem. You need to pass the '-i' switch.
: Try: '-B 1024 -i'

Can anyone shed some light on why adding '-i' worked?

Yes. The default RPM installation includes a 'postmaster.opts' file
with '-i' already in place. The additional command line parameters
apparently broke the extant -i. How did I know this was an RPM
installation? Familiarity breeds contempt -- and I'm the RPM
maintainer. :-)

Just in case you don't know, the '-i' parameter is what allows
poastmaster to accept TCP/IP connections. Without -i, postmaster only
accepts local Unix domain sockets, not TCP/IP ones.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11