How to start postgres service as a different user(myown) instead postgres user

Question

I have installed postgres 9.5 in my linux(16.04) machine.I have started service using below command.

sudo service postgresql start

This will start postgres service as a postgres user. But I want to run postgres a different user(myown user).

How can I do .Please help !!.

Laurenz Albe · Accepted Answer · 2018-08-01 15:34:31Z

1

You have to recursively change the ownership of the database directory to the new user.

If the WAL directory or tablespaces are outside the data directory, you have to change their ownership too.

Then you will have to configure the startup script so that it starts PostgreSQL as the new user. Watch out: if you installed the startup script with an installation package, any changes to it will probably be lost after an update.

I recommend that you don't do all that and continue running PostgreSQL as postgres.

answered Aug 1, 2018 at 15:34

Laurenz Albe

257k22 gold badges313 silver badges389 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

Khumar Over a year ago

Thanks Laurenz. I have one more question where this postgres user creation will happen/in which file. If I can change user there itself then problem is solved right !!.

Laurenz Albe Over a year ago

That is done my the server installation package. I don't think you want to roll your own, right?

Khumar Over a year ago

I want to change the data_directory path in file /etc/postgresql/10/main/postgresql.conf.. data_directory= 'my/own/path'.only me/my-user can access that path,other user(postgres) can't access that path.I want to start service with my user so that I can access that mounted path.

Laurenz Albe Over a year ago

I don't understand.

Khumar Over a year ago

I am installing postgres in a docker container .By default there is one data_directory path mentioned in /etc/postgresql/10/main/postgresql.conf. I wanted to change that path and point to new path on the mounted volume. which is out side the container .Only I/with my user can access that volume no ther can access.So I wanted to start postgres with my user instead postgres.

|

Collectives™ on Stack Overflow

How to start postgres service as a different user(myown) instead postgres user

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related