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

What error did you face during connectivity?

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

On Thu, Mar 7, 2019 at 10:08 AM soumitra bhandary <
soumitra(dot)bhandary(at)hotmail(dot)com> wrote:

> Hi Shreeyansh ,
>
> Thanks for the response .
>
> I installed postgres 10.0 rpm . It created osuser postgres and executed
> initdb and cluster is up and running .
>
> Then I took my current user (not root) to create another cluster using
> initdb . It successfully created but I am not able to log in to the new
> cluster using psql and current user(through which initdb was executed).
>
> Thanks,
> Soumitra
> ------------------------------
> *From:* Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>
> *Sent:* Friday, March 1, 2019 11:29 AM
> *To:* soumitra bhandary
> *Cc:* pgsql-admin(at)lists(dot)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
>
> 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
>
>