[INSTRM-200] Add postgresql database role Created: 21/Sep/17  Updated: 06/Aug/18  Resolved: 06/Aug/18

Status: Done
Project: Instrument control development
Component/s: ics_ansible
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Normal
Reporter: shimono Assignee: shimono
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Sprint: 2017-10A

 Description   

Add postgresql role which is to be used at production.



 Comments   
Comment by shimono [ 23/May/18 ]

added tasks to install packages and configure site-wide parameters.

Comment by shimono [ 23/May/18 ]

added tasks for initdb, but need to be careful... we may use existing data cluster for most cases but not having fresh one. need to mount remote filesystem (via iscsi or nfs) well before running this.

Comment by shimono [ 26/May/18 ]

i found postgres 10.x has /etc/postgres/10/main but not 10.x like 9.x.
might be better to have some parameter rather than detecting directory name.
or list existing directory and choose one?

Generated at Sat Feb 10 16:22:33 JST 2024 using Jira 8.3.4#803005-sha1:1f96e09b3c60279a408a2ae47be3c745f571388b.