V
V
Vladimir2019-07-08 16:33:24
PostgreSQL
Vladimir, 2019-07-08 16:33:24

How to give the user the option to restart the postgresql service?

You need to put pg11 next to the pg10 dev base.
There are a number of users for whom su and sudo are prohibited.
you need to let them play with the pg11 database for their own pleasure. i.e. give superuser rights and also give the opportunity to restart the pg11 instance

Answer the question

In order to leave comments, you need to log in

2 answer(s)
M
Melkij, 2019-07-08
@idskill

Why do you need root to play with the base? Postgresql explicitly forbids running itself as root.
initdb where they tell themselves in the hamster and any user with access to the console can start the database from there through pg_ctl. Port only yourself to choose any free above the privileged range. And play for your own pleasure, no special rights are needed for this.

D
Dmitry Shitskov, 2019-07-08
@Zarom

I think it's best to allow sudo for one command

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question