Subject: Re: [vserver] PostgreSQL 9.0 in guest
From: "Roderick A. Anderson" <raanders@cyber-office.net>
Date: Tue, 16 Aug 2011 18:15:37 -0700

Christian Bricart wrote:
> Am 16.08.2011 22:55, schrieb Roderick A. Anderson:
>> Anyone running PostgreSQL 9.0 in a guest.
>>
>>      Kernel: 2.6.32-131.2.1.el5.vs2.3.0.36.29.6.18.i686
>>      VS-API: 0x00020308
>>         VCI: 0x0000000013011f11
>> util-vserver: 0.30.216-pre2981; Jun  7 2011, 12:14:10
>>
>> The LV install is on top of a CentOS 5.5.  No update was done.
>>
>> Error is from an attempt of the init script to write to /proc/self/oom_adj
>>
>> I have PostgreSQL 8.4 running in a guest on this system just fine.
>>
>>       Kernel: 2.6.22.19-vs2.3.0.34.1
>>       VS-API: 0x00020302
>> util-vserver: 0.30.216-pre2883; May 26 2010, 01:58:19
>>
>> Application of a clue-stick is requested.  I'm having no joy finding any
>> thing on the web site.  (My search foo needs upgrading.)
> 
> See a similar bug with openssh and quotes from linux-vserver folks at:
> http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=487325#17

Thanks that was the first part.  The lack of a localhost entry in a LV 
guest was the other.

For the record I modified the /etc/init.d/postgresql-9.0 script and 
commented out the PG_OOM_ADJline.

Then I edited /var/lib/pgsql/data/postgresql.conf and made the 
listen_addresses equal to the guests IP.


Rod
-- 
> 
> So, look at a possible setting in /etc/default/postgres* (if that file
> exists). As a last resort there should be a quoted paragraph w/i the
> provided init script /etc/init.d/postgres* (<- I've found that paragraph
> in Ubuntu's init script..) that hint's to a possible solution.
> 
> Christian