Problems starting postmaster with maxconnections changed

From: "Tauren Mills" <tauren(at)servlets(dot)net>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Problems starting postmaster with maxconnections changed
Date: 2001-06-07 09:34:51
Message-ID: NBBBLBKDJMGDNPMDGAABMEGBAEAB.tauren@servlets.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I'm running PostgreSQL 7.1 (not 7.1.2) as installed from the RPM on a Red
Hat 6.2 machine. It automatically installs a startup script into
/etc/rc.d/init.d. By default, the server does not listen to tcp/ip
connections. Since I'll be using JDBC, I need it to do this. I also need
more than 32 connections.

So I've tried adding some configuration directives to
/var/lib/pgsql/data/postgresql.conf, including the following:

tcpip_socket = true
max_connections = 128
log_connections = on

Then, I stop and start the server with these commands:

/etc/rc.d/init.d/postgresql stop
/etc/rc.d/init.d/postgresql start

It has a problem restarting if I have max_connections set at 128 or 64. If
I comment it out or set it to 32, it starts fine.

For instance, when I set max_connections to 128 and issue the "restart"
command, I get this output:

[root(at)s2 data]# /etc/rc.d/init.d/postgresql restart
Stopping postgresql service: postmaster successfully shut down

Checking postgresql installation: [ OK ]
/etc/rc.d/init.d/postgresql: [: 2914: unary operator expected
Starting postgresql service: [FAILED]

But it works fine set at 32!

What is wrong? Do I need to tweak other settings to get more than 32
connections available?

Thanks,
Tauren

Browse pgsql-admin by date

  From Date Subject
Next Message Tauren Mills 2001-06-07 09:45:06 Problems starting postmaster with maxconnections changed
Previous Message Romuald Lobet 2001-06-07 09:17:21 Re: What CASE tools and clients for Postgres?