Обсуждение: PG 9.0 streaming replication cfg question

Поиск
Список
Период
Сортировка

PG 9.0 streaming replication cfg question

От
Isabella Ghiurea
Дата:
Hi All,
I'm trying to configure PG 9.0.1 with streaming replication and WAL
shipping in same time, what will be pros and cons  for using  dedicated
user for  replication aka: replication_user than the regular user
:postgres. Any issues with WAL files ownership when they must be  copied
and loaded on standby server ?
Thank you
Isabella
--

-----------------------------------------------------------
Isabella A. Ghiurea

Isabella.Ghiurea@nrc-cnrc.gc.ca
Canadian Astronomy Data Centre |http://www.nrc-cnrc.gc.ca/eng/services/hia/data-centre.html
National Research Council of Canada, Herzberg Institute of Astrophysics
5071 West Saanich Road, Victoria BC V9E 2E7, Canada
Phone: 250 363-3446 fax: 250 363-0045