From: | Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com> |
---|---|
To: | soumitra bhandary <soumitra(dot)bhandary(at)hotmail(dot)com> |
Cc: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS |
Date: | 2019-03-01 05:59:49 |
Message-ID: | CAGDYbUP_Z3jJSEpckv-O0zcJPVZAkF7JxpvEC0=kuAAro6FuiA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)bhandary(at)hotmail(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ron | 2019-03-01 06:07:16 | Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS |
Previous Message | soumitra bhandary | 2019-03-01 05:07:27 | Installation of Postgres 10.0 and running application with HA without postgres user at OS |