> > On Thu, Feb 24, 2005 at 09:00:46PM +, Charl Gerber wrote:
> > I'm trying to create a function that takes 1
> > paramater (eg an integer) as input, then does 5
> > database updates or deletes in 5 different SQL
> > statements and returns 5 integers (in one resultset)
> > indicating how many
gt;
> Help?
Postgresql is not running anymore. You have to restart it. How you
would do that depends on the operating system you are using. But
usually the startup scripts are in either /etc/rc.d or
/usr/local/etc/rc.d. You could also use the postmaster or pg_ctl to
start it up manually.
On Sun, 30 Jan 2005 21:12:08 -0500, Sven Willenberger <[EMAIL PROTECTED]> wrote:
> I assume you added these variables to either the GENERIC or a custom
> kernel in /usr/src/sys/i386/conf. If you created a custom kernel called
> CUSTOM, then you would:
That's what I did.
> cd /usr/src
> make bui
I tried the settings you gave and they worked (with some caveats).
After I recompiled the FreeBSD kernel with the options:
options SYSVSHM
options SYSVMSG
options SYSVSEM
options SHMMAXPGS=131072
options SEMMNI=128
options SEMMNS=512
options
On Sun, 30 Jan 2005 20:50:21 +, Richard Poole <[EMAIL PROTECTED]> wrote:
> On Sun, Jan 30, 2005 at 03:21:25PM -0500, Rick Apichairuk wrote:
>
> > I am trying to increase the number of max_connections to 200 and found
> > out I couldn't even start postg
Greetings,
I am trying to increase the number of max_connections to 200 and found
out I couldn't even start postgresql. So I tried to increase
max_connections gradually (currently at 50 from 40 default) and adjust
shared memory settings along the way. Even at 50 max_connections, I
still cannot get