Re: Installation of Postgres 10.0 and running application with HAwithout postgres user at OS

Поиск
Список
Период
Сортировка
От Shreeyansh Dba
Тема Re: Installation of Postgres 10.0 and running application with HAwithout postgres user at OS
Дата
Msg-id CAGDYbUP_Z3jJSEpckv-O0zcJPVZAkF7JxpvEC0=kuAAro6FuiA@mail.gmail.com
обсуждение исходный текст
Ответ на Installation of Postgres 10.0 and running application with HAwithout postgres user at OS  (soumitra bhandary <soumitra.bhandary@hotmail.com>)
Ответы Re: Installation of Postgres 10.0 and running application with HAwithout postgres user at OS
Список pgsql-admin
Дерево обсуждения
Hi Sumintra,

You have to create a postgres OS user,initdb must be run as the user that will own the server process, because the server needs to have access to the files and directories that initdb creates. Since the server cannot be run as root, you must not run initdb as root either. (It will in fact refuse to do so.)

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com


On Fri, Mar 1, 2019 at 10:37 AM soumitra bhandary <soumitra.bhandary@hotmail.com> wrote:
Hi , 

I am using RHEL to install Postgres 10 and setting up replication . But in my OS no postgres user exists . Installed it with sudo access . Can I run the postgres DB with all it's utility (like psql, vaccumdb , pg_rewind , initdb etc.) along with Master slave replication, archival process without postgres user. 

If it can be done , do I need to follow any extra step to the os user apart from postgres ?

Is there any way to skip postgres os user ?

Thanks , 
Soumitra 

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

Предыдущее
От: soumitra bhandary
Дата:
Сообщение: Installation of Postgres 10.0 and running application with HAwithout postgres user at OS
Следующее
От: Ron
Дата:
Сообщение: Re: Installation of Postgres 10.0 and running application with HAwithout postgres user at OS