Message-ID: <58E3F97F.5030905@nrc-cnrc.gc.ca>
Date: Tue, 4 Apr 2017 12:52:31 -0700
From: ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:17.0) Gecko/20130110 Thunderbird/17.0.2
MIME-Version: 1.0
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: pgsql and lxc containers input
Content-Type: text/plain; charset="ISO-8859-1"; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Hi List,
  I am looking to get some feedback using LXC containers and Pgsql, I am 
not able to find to much online , almost everything points to docker 
type container and PG., this was  Sysadmin choice for db container.  I  
would like to have some user cases or sample scripts for this type of 
containers for  a production PG  db  with size 200GB.
  The basic lxc containers Sysadmin had come out  is a one persistent 
volume :/var/lib/pgsql/data which would contain everything ( pg_xlog, 
200 GB user database, archive dir , errorlog, ...etc etc ) and the 
default postgresql.conf ,
  I would prefer to both of this item customized ( multiple mount 
points, customize postgres.conf, how I can upload my own postgresql.conf 
or make changes to  default existing one ? ,
  I see docker has Docker composer what will be lLXC equivalent ? ) , 
also how  will run DB maintenance jobs  in container ( we need crontab 
installed and a way to call maintenance shell scripts ?)

Thank you
Isabella


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin