I'm on my way installing postgres 15.2 under Suse Linux Enterprise 15.3 by source, following the instructions from www.postgresql.org:
I'm stuck at chapter "19.2. Creating Database Cluster" (https://www.postgresql.org/docs/current/postgres-user.html)
root# mkdir /usr/local/pgsql
root# chown postgres /usr/local/pgsql
root# su postgres
postgres$ initdb -D /usr/local/pgsql/data
The postgres User (I'm looking for operating system user account") does not exist yet.
My question: how can I add the new postgres- system operation user account (with right permissions for postgreSQL)?
Important to know for postgreSQL: "PostgreSQL user accounts are distinct from operating system user accounts" (vgl. https://www.postgresql.org/docs/current/tutorial-createdb.html)
referring to MAN-Page text by default "the home directory will be created and the initial default files and directories will be copied."
I don't need a home-directory
I don't want to create the Database Cluster with my personal user-account
referring rights, as far as I guess from pg-documentation, the new user only needs full rights on usr/local/pgsql (I'm not that sure about this point)
The page postgres-user.html mentions the required commands (useradd
or adduser
). Run useradd --help
to see available options. They are also all mentioned in the referenced man page.
Maybe you are just confused by the text following Depending on the command line options
. No home directory will be created unless -m
is specified.
I think you are all set by just running useradd postgres
.