pgsql and lxc containers input

Поиск
Список
Период
Сортировка
От ghiureai
Тема pgsql and lxc containers input
Дата
Msg-id 58E3F97F.5030905@nrc-cnrc.gc.ca
обсуждение исходный текст
Ответы Re: pgsql and lxc containers input  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-admin
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




В списке pgsql-admin по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: PostgreSQL 9.6.1 - Windows 64bit - HDD crash due to power outage
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: pgsql and lxc containers input