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

In addition to this.

Try with below command

psql -p db_port -d dbname -U username

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

On Thu, Mar 7, 2019 at 12:54 PM Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>
wrote:

> 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
>>
>>