Re: How to install latest stable postgresql on Debian - Mailing list pgsql-general

From Andrus
Subject Re: How to install latest stable postgresql on Debian
Date
Msg-id 773BC2CC9BC44A4E972693A4D68CE60D@dell2
Whole thread Raw
In response to Re: How to install latest stable postgresql on Debian  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: How to install latest stable postgresql on Debian  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Scott,

Thank you.

>Just add them to the bottom then run
>sudo sysctl -p
>to make them take effect.

It seems that if this value is greater than RAM, linux kerner silently uses
max possible value.
Linuxes are used mostly to run PostgreSql only but ram may vary depending on
virtual maschine configuration at runtime.
Is it reasonable to use large value, eq.  8GB as SHMMAX in sysctl.conf file
always ?
In this case root and SSH access to server is not required if RAM amount
changes. This simplifies server administration. Only postgresql.conf needs
changed which can be done from 5432 port using pgAdmin.

>btw, the standard way to control rc stuff is update-rc.d Odd name but
>it's pretty easy, just look up the man page.

Debian seems to require update-rc.d and Centos chkconfig
How to use single command for every distro ?

"/etc/init.d/postgresql start" works in all distros. Adding to postgresql to
startup requires different commands in different distros ?!

Andrus


pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Installed. Now what?
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: invalid byte sequence for encoding "UTF8": 0x00