Thread: Cant connect if -B 1024 was set to postmaster
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
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 >
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: > > 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
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
"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
"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