pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedInstallation of Postgres 10.0 and running application with HA without postgres user at OS
12+ messages / 5 participants
[nested] [flat]
* Installation of Postgres 10.0 and running application with HA without postgres user at OS
@ 2019-03-01 05:07 soumitra bhandary <soumitra.bhandary@hotmail.com>
2019-03-01 05:59 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-01 06:07 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Ron <ronljohnsonjr@gmail.com>
2019-03-01 08:39 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 3 replies; 12+ messages in thread
From: soumitra bhandary @ 2019-03-01 05:07 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>; pgsql-admin
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
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS
2019-03-01 05:07 Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
@ 2019-03-01 05:59 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-07 04:38 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
2 siblings, 1 reply; 12+ messages in thread
From: Shreeyansh Dba @ 2019-03-01 05:59 UTC (permalink / raw)
To: soumitra bhandary <soumitra.bhandary@hotmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>; 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
>
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS
2019-03-01 05:07 Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
2019-03-01 05:59 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Shreeyansh Dba <shreeyansh2014@gmail.com>
@ 2019-03-07 04:38 ` soumitra bhandary <soumitra.bhandary@hotmail.com>
2019-03-07 07:24 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Shreeyansh Dba <shreeyansh2014@gmail.com>
0 siblings, 1 reply; 12+ messages in thread
From: soumitra bhandary @ 2019-03-07 04:38 UTC (permalink / raw)
To: Shreeyansh Dba <shreeyansh2014@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>; pgsql-admin
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
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS
2019-03-01 05:07 Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
2019-03-01 05:59 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-07 04:38 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
@ 2019-03-07 07:24 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-07 07:34 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-07 07:40 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
0 siblings, 2 replies; 12+ messages in thread
From: Shreeyansh Dba @ 2019-03-07 07:24 UTC (permalink / raw)
To: soumitra bhandary <soumitra.bhandary@hotmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>; pgsql-admin
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.bhandary@hotmail.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@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
>
>
> 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
>
>
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS
2019-03-01 05:07 Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
2019-03-01 05:59 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-07 04:38 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
2019-03-07 07:24 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Shreeyansh Dba <shreeyansh2014@gmail.com>
@ 2019-03-07 07:34 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-07 11:30 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
1 sibling, 1 reply; 12+ messages in thread
From: Shreeyansh Dba @ 2019-03-07 07:34 UTC (permalink / raw)
To: soumitra bhandary <soumitra.bhandary@hotmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>; pgsql-admin
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@gmail.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.bhandary@hotmail.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@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
>>
>>
>> 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
>>
>>
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS
2019-03-01 05:07 Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
2019-03-01 05:59 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-07 04:38 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
2019-03-07 07:24 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-07 07:34 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Shreeyansh Dba <shreeyansh2014@gmail.com>
@ 2019-03-07 11:30 ` soumitra bhandary <soumitra.bhandary@hotmail.com>
2019-03-08 05:27 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
0 siblings, 1 reply; 12+ messages in thread
From: soumitra bhandary @ 2019-03-07 11:30 UTC (permalink / raw)
To: Shreeyansh Dba <shreeyansh2014@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>; pgsql-admin
Yes same commands I am using
Sent from my iPhone
On 07-Mar-2019, at 1:04 PM, Shreeyansh Dba <shreeyansh2014@gmail.com<mailto:shreeyansh2014@gmail.com>> wrote:
In addition to this.
Try with below command
psql -p db_port -d dbname -U username
Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com<http://www.shreeyansh.com;
On Thu, Mar 7, 2019 at 12:54 PM Shreeyansh Dba <shreeyansh2014@gmail.com<mailto:shreeyansh2014@gmail.com>> wrote:
What error did you face during connectivity?
Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com<http://www.shreeyansh.com;
On Thu, Mar 7, 2019 at 10:08 AM soumitra bhandary <soumitra.bhandary@hotmail.com<mailto:soumitra.bhandary@hotmail.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@gmail.com<mailto:shreeyansh2014@gmail.com>>
Sent: Friday, March 1, 2019 11:29 AM
To: soumitra bhandary
Cc: pgsql-admin@lists.postgresql.org<mailto:pgsql-admin@lists.postgresql.org>; pgsql-admin@postgresql.org<mailto: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
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS
2019-03-01 05:07 Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
2019-03-01 05:59 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-07 04:38 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
2019-03-07 07:24 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-07 07:34 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-07 11:30 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
@ 2019-03-08 05:27 ` soumitra bhandary <soumitra.bhandary@hotmail.com>
2019-03-08 12:13 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 1 reply; 12+ messages in thread
From: soumitra bhandary @ 2019-03-08 05:27 UTC (permalink / raw)
To: Shreeyansh Dba <shreeyansh2014@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>; pgsql-admin
Hi Shreyansh ,
Thanks !!!
The issue was different in file permission . So now I am able to log in . But can not start this postges instance (running on different user apart from postgres) as a systemd utility . Only way to start or stop the instance is pg_ctl . Even after changing PGDATA in systemd file and reloaded .
What could be issue if my postgres is not running as a service from root .
Thanks
Soumitra
________________________________
From: soumitra bhandary <soumitra.bhandary@hotmail.com>
Sent: Thursday, March 7, 2019 5:00 PM
To: Shreeyansh Dba
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
Yes same commands I am using
Sent from my iPhone
On 07-Mar-2019, at 1:04 PM, Shreeyansh Dba <shreeyansh2014@gmail.com<mailto:shreeyansh2014@gmail.com>> wrote:
In addition to this.
Try with below command
psql -p db_port -d dbname -U username
Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com<http://www.shreeyansh.com;
On Thu, Mar 7, 2019 at 12:54 PM Shreeyansh Dba <shreeyansh2014@gmail.com<mailto:shreeyansh2014@gmail.com>> wrote:
What error did you face during connectivity?
Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com<http://www.shreeyansh.com;
On Thu, Mar 7, 2019 at 10:08 AM soumitra bhandary <soumitra.bhandary@hotmail.com<mailto:soumitra.bhandary@hotmail.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@gmail.com<mailto:shreeyansh2014@gmail.com>>
Sent: Friday, March 1, 2019 11:29 AM
To: soumitra bhandary
Cc: pgsql-admin@lists.postgresql.org<mailto:pgsql-admin@lists.postgresql.org>; pgsql-admin@postgresql.org<mailto: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
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS
2019-03-01 05:07 Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
2019-03-01 05:59 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-07 04:38 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
2019-03-07 07:24 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-07 07:34 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-07 11:30 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
2019-03-08 05:27 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
@ 2019-03-08 12:13 ` Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 0 replies; 12+ messages in thread
From: Scott Ribe @ 2019-03-08 12:13 UTC (permalink / raw)
To: soumitra bhandary <soumitra.bhandary@hotmail.com>; +Cc: Shreeyansh Dba <shreeyansh2014@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>; pgsql-admin
User; you can't run it as root no matter how you're starting it. Set the user in your unit file.
> On Mar 7, 2019, at 10:27 PM, soumitra bhandary <soumitra.bhandary@hotmail.com> wrote:
>
> What could be issue if my postgres is not running as a service from root .
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS
2019-03-01 05:07 Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
2019-03-01 05:59 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-07 04:38 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
2019-03-07 07:24 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Shreeyansh Dba <shreeyansh2014@gmail.com>
@ 2019-03-07 07:40 ` soumitra bhandary <soumitra.bhandary@hotmail.com>
2019-03-07 09:39 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Shreeyansh Dba <shreeyansh2014@gmail.com>
1 sibling, 1 reply; 12+ messages in thread
From: soumitra bhandary @ 2019-03-07 07:40 UTC (permalink / raw)
To: Shreeyansh Dba <shreeyansh2014@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>; pgsql-admin
Yes during connection.
Sent from my iPhone
On 07-Mar-2019, at 12:54 PM, Shreeyansh Dba <shreeyansh2014@gmail.com<mailto:shreeyansh2014@gmail.com>> wrote:
What error did you face during connectivity?
Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com<http://www.shreeyansh.com;
On Thu, Mar 7, 2019 at 10:08 AM soumitra bhandary <soumitra.bhandary@hotmail.com<mailto:soumitra.bhandary@hotmail.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@gmail.com<mailto:shreeyansh2014@gmail.com>>
Sent: Friday, March 1, 2019 11:29 AM
To: soumitra bhandary
Cc: pgsql-admin@lists.postgresql.org<mailto:pgsql-admin@lists.postgresql.org>; pgsql-admin@postgresql.org<mailto: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
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS
2019-03-01 05:07 Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
2019-03-01 05:59 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-07 04:38 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
2019-03-07 07:24 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-07 07:40 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
@ 2019-03-07 09:39 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
0 siblings, 0 replies; 12+ messages in thread
From: Shreeyansh Dba @ 2019-03-07 09:39 UTC (permalink / raw)
To: soumitra bhandary <soumitra.bhandary@hotmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>; pgsql-admin
Change your port no. if already running which by default 5432 into the
postgresql.conf file and try to connect it again.
Thanks & Regards,
*Shreeyansh DBA Team*
www.shreeyansh.com
On Thu, Mar 7, 2019 at 1:10 PM soumitra bhandary <
soumitra.bhandary@hotmail.com> wrote:
> Yes during connection.
>
> Sent from my iPhone
>
> On 07-Mar-2019, at 12:54 PM, Shreeyansh Dba <shreeyansh2014@gmail.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.bhandary@hotmail.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@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
>>
>>
>> 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
>>
>>
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS
2019-03-01 05:07 Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
@ 2019-03-01 06:07 ` Ron <ronljohnsonjr@gmail.com>
2 siblings, 0 replies; 12+ messages in thread
From: Ron @ 2019-03-01 06:07 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
On 2/28/19 11:07 PM, soumitra bhandary 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.
How are you installing it? (Packages will automatically create Linux
account "postgres".)
> 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 ?
Why?
--
Angular momentum makes the world go 'round.
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS
2019-03-01 05:07 Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
@ 2019-03-01 08:39 ` Laurenz Albe <laurenz.albe@cybertec.at>
2 siblings, 0 replies; 12+ messages in thread
From: Laurenz Albe @ 2019-03-01 08:39 UTC (permalink / raw)
To: soumitra bhandary <soumitra.bhandary@hotmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>; pgsql-admin
soumitra bhandary wrote:
> 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 ?
If you use the RPM packages from the PostgreSQL download page, as I would recommend,
a user "postgres" will be created automatically.
You can of course remove the user again, but you will need a user different
from "root" to run PostgreSQL.
PostgreSQL will refuse to start under the "root" user for security reasons.
It is not commendable to run any software as "root" unless absolutely necessary.
Mind you, "postgres" is *not* the owner of the executables (this is not Oracle), but
the owner of the database files and processes.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
^ permalink raw reply [nested|flat] 12+ messages in thread
end of thread, other threads:[~2019-03-08 12:13 UTC | newest]
Thread overview: 12+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-03-01 05:07 Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
2019-03-01 05:59 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-07 04:38 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
2019-03-07 07:24 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-07 07:34 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-07 11:30 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
2019-03-08 05:27 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
2019-03-08 12:13 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Scott Ribe <scott_ribe@elevated-dev.com>
2019-03-07 07:40 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS soumitra bhandary <soumitra.bhandary@hotmail.com>
2019-03-07 09:39 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-03-01 06:07 ` Re: Installation of Postgres 10.0 and running application with HA without postgres user at OS Ron <ronljohnsonjr@gmail.com>
2019-03-01 08:39 ` Laurenz Albe <laurenz.albe@cybertec.at>
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