From: soumitra bhandary <soumitra.bhandary@hotmail.com>
To: Shreeyansh Dba <shreeyansh2014@gmail.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS
Date: Thu, 7 Mar 2019 04:38:33 +0000
Message-ID: <MA1PR01MB35482F804330305944E7597AE04C0@MA1PR01MB3548.INDPRD01.PROD.OUTLOOK.COM> (raw)
In-Reply-To: <CAGDYbUP_Z3jJSEpckv-O0zcJPVZAkF7JxpvEC0=kuAAro6FuiA@mail.gmail.com>
References: <MA1PR01MB3548B99882021F0283A2B330E0760@MA1PR01MB3548.INDPRD01.PROD.OUTLOOK.COM>
<CAGDYbUP_Z3jJSEpckv-O0zcJPVZAkF7JxpvEC0=kuAAro6FuiA@mail.gmail.com>
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@gmail.com>
Sent: Friday, March 1, 2019 11:29 AM
To: soumitra bhandary
Cc: pgsql-admin@lists.postgresql.org; pgsql-admin@postgresql.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<http://www.shreeyansh.com;
On Fri, Mar 1, 2019 at 10:37 AM soumitra bhandary <soumitra.bhandary@hotmail.com<mailto: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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: soumitra.bhandary@hotmail.com, shreeyansh2014@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS
In-Reply-To: <MA1PR01MB35482F804330305944E7597AE04C0@MA1PR01MB3548.INDPRD01.PROD.OUTLOOK.COM>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox