Re: [GENERAL] How to install latest stable postgresql on Debian

On sön, 2011-11-20 at 12:09 +0200, Andrus wrote: > Debian seems to require update-rc.d and Centos chkconfig > How to use single command for every distro ? apt-get install chkconfig > "/etc/init.d/postgresql start" works in all distros. Adding to > postgresql to startup requires different commands

Re: [GENERAL] How to install latest stable postgresql on Debian

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 confi

Re: [GENERAL] How to install latest stable postgresql on Debian

2011/11/19 Andrus : >> From here(look familiar): >> http://wiki.postgresql.org/wiki/Performance_Optimization >> http://linuxfinances.info/info/quickstart.html >> http://www.westnet.com/~gsmith/content/postgresql/pg-5minute.htm > > Thank you. > I tried > > # sysctl -w kernel.shmmax=419430400 > kerne

Re: [GENERAL] How to install latest stable postgresql on Debian

From here(look familiar): http://wiki.postgresql.org/wiki/Performance_Optimization http://linuxfinances.info/info/quickstart.html http://www.westnet.com/~gsmith/content/postgresql/pg-5minute.htm Thank you. I tried # sysctl -w kernel.shmmax=419430400 kernel.shmmax = 419430400 # sysctl -n kernel.

Re: [GENERAL] How to install latest stable postgresql on Debian

On Saturday, November 19, 2011 5:34:59 am Andrus wrote: > >To check whether this is the case, look in the appropriate /etc/rc*.d > > directory for the runlevel you're using, and see if there is an "S" > symlink to /etc/init.d/postgresql-9.1 (or something like that) in there. > > Thank you. >

Re: [GENERAL] How to install latest stable postgresql on Debian

On Saturday, November 19, 2011 10:36:37 am Andrus wrote: > Adrian, > > >For tuning tips a good start is: > >http://wiki.postgresql.org/wiki/Performance_Optimization > >In particular: > >http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server > >For books take a look at: > >http://www.postgre

Re: [GENERAL] How to install latest stable postgresql on Debian

Adrian, For tuning tips a good start is: http://wiki.postgresql.org/wiki/Performance_Optimization In particular: http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server For books take a look at: http://www.postgresql.org/docs/books/ thank you very much. Reading them requires lot of time.

Re: [GENERAL] How to install latest stable postgresql on Debian

On Friday, November 18, 2011 3:58:26 pm Andrus wrote: > >How did you uninstall 8.4? > >From below it would seem it is still around. > > Thank you. > After adding -t switch to apt-get I was able to install 9.1. > > To start it I invoked /etc/init.d/postgresql manually. > > How to force it to sta

Re: [GENERAL] How to install latest stable postgresql on Debian

To check whether this is the case, look in the appropriate /etc/rc*.d directory for the runlevel you're using, and see if there is an "S" symlink to /etc/init.d/postgresql-9.1 (or something like that) in there. Thank you. There are S18postgresql symlinks in may rc?.d directories. They seems

Re: [GENERAL] How to install latest stable postgresql on Debian

On 18/11/2011 23:58, Andrus wrote: >> How did you uninstall 8.4? From below it would seem it is still >> around. > > Thank you. After adding -t switch to apt-get I was able to install > 9.1. > > To start it I invoked /etc/init.d/postgresql manually. > > How to force it to start after server is

Re: [GENERAL] How to install latest stable postgresql on Debian

How did you uninstall 8.4? From below it would seem it is still around. Thank you. After adding -t switch to apt-get I was able to install 9.1. To start it I invoked /etc/init.d/postgresql manually. How to force it to start after server is rebooted automatically ? free -g returns

Re: [GENERAL] How to install latest stable postgresql on Debian

On Friday, November 18, 2011 3:15:01 pm Andrus wrote: > Adrian, > > thank you. I'm sorry for stupid mistake. > I uninstalled 8.4. Trying to install 9.1 now returns How did you uninstall 8.4? From below it would seem it is still around. > > Andrus. -- Adrian Klaver adrian.kla...@gmail.com -

Re: [GENERAL] How to install latest stable postgresql on Debian

Adrian, thank you. I'm sorry for stupid mistake. I uninstalled 8.4. Trying to install 9.1 now returns root@EEPOLDB01:~# apt-get install postgresql-9.1 Reading package lists... Done Building dependency tree Reading state information... Done Some packages could not be installed. This may mean that

Re: [GENERAL] How to install latest stable postgresql on Debian

On Friday, November 18, 2011 2:59:44 pm Andrus wrote: > Ray, > > thank you. > > >Did you do "apt-get update" after adding the line to the source list? > > Yes I tried. I tried it again and it looks like the instructons provided in > debian site are invalid. > How to fix ? Take out the www. htt

Re: [GENERAL] How to install latest stable postgresql on Debian

Ray, Did you do "apt-get update" after adding the line to the source list? I fixed this but now another issue arises. Installaton fails with error below. How to fix this ? root@EEPOLDB01:~# apt-get install postgresql-9.1 Reading package lists... Done Building dependency tree Reading state inf

Re: [GENERAL] How to install latest stable postgresql on Debian

Ray, thank you. Did you do "apt-get update" after adding the line to the source list? Yes I tried. I tried it again and it looks like the instructons provided in debian site are invalid. How to fix ? Andrus. root@EEPOLDB01:~# cat /etc/apt/sources.list deb http://www.backports.debian.org/

Re: [GENERAL] How to install latest stable postgresql on Debian

On 18/11/2011 19:59, Andrus wrote: > I tried to install latest PostgreSql on plain Debian using instructions from > > http://backports-master.debian.org/Instructions/ > > I added line described there to sources and tried > > root@EEPOLDB01 :~# apt-get -t squeeze-backpor