Bug 1889660

Summary:	[DDF] Please add an indication about which user to use for this step.
Product:	Red Hat Enterprise Linux 8	Reporter:	Direct Docs Feedback <ddf-bot>
Component:	Documentation	Assignee:	Lenka Špačková <lkuprova>
Documentation sub component:	DDF	QA Contact:
Status:	CLOSED CURRENTRELEASE	Docs Contact:
Severity:	unspecified
Priority:	high	CC:	panovotn, rhel-docs
Version:	8.0	Keywords:	Documentation
Target Milestone:	rc
Target Release:	8.0
Hardware:	All
OS:	All
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2021-05-31 11:43:50 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Direct Docs Feedback 2020-10-20 10:41:54 UTC

Please add an indication about which user to use for this step.
Should the DB be initialized as root or postgres user?
Is it recommended to create additional users?

Reported by: bram.mertens

https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/8/html/deploying_different_types_of_servers/using-databases#annotations:cd14667d-d415-418a-8d00-e481cf5cfb9b

Comment 4 Patrik Novotný 2021-03-19 13:09:39 UTC

By default, the `postgresql-setup --initdb` initialises data in the RH recommended directory. This is independent from the current working directory when issuing this command.

Any `postgresql-setup` command is to be run as `root`. The script itself runs specific tasks required to be run as the `postgres` user under this user itself (via `su postgres -c [command]`) internally.

Comment 5 Lenka Špačková 2021-03-19 15:03:20 UTC

We are currently working on rewriting the procedures to clarify information about users.

Comment 8 Lenka Špačková 2021-05-31 11:43:50 UTC

The Using PostgreSQL part has been rewritten. Instructions about users have been added to the respective procedures. A new chapter about PostgreSQL users have been added.

https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/8/html-single/deploying_different_types_of_servers/index#using-postgresql
https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/8/html-single/deploying_different_types_of_servers/index#con_postgresql-users_using-postgresql

Thanks again for your valuable feedback!