initdb

=?utf-8?q?PG_Doc_comments_form?= <noreply@postgresql.org> writes:

So I was trying to create a new db with initdb. I tried to run this with
the postgres user after installing the server rpm and it failed with runuser
may not be run as non-root users. So then for fun I tried to run init db
as the root user which should have failed but instead it just reported
initializing database ... OK

hmm, worksforme:

$ sudo initdb -D someplace
initdb: cannot be run as root
Please log in (using, e.g., "su") as the (unprivileged) user that will
own the server process.

Were you actually running initdb directly, or some script that perhaps
sudo'd internally?

regards, tom lane

Hi Tom,

I was running initdb command when calling the postgresql96-setup command.
Trying to run this as the user postgres failed.

/usr/pgsql-9.6/bin/postgresql96-setup initdb

The database was created under /var/lib/pgsql/9.6/data

thanks
Scott.

On Mon, Jan 15, 2018 at 4:56 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote: