BUG #15108: Initialization problem postgresql-10-setup initdb

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: alertas(dot)dba(at)click-it(dot)es
Subject: BUG #15108: Initialization problem postgresql-10-setup initdb
Date: 2018-03-13 12:12:16
Message-ID: 152094313655.1225.9005657715834235284@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 15108
Logged by: Alertas DBA
Email address: alertas(dot)dba(at)click-it(dot)es
PostgreSQL version: 10.3
Operating system: Centos 7.4.1708
Description:

The problem is reported when executing database initialization command,
postgresql-10-setup initdb.
In the official documentation
(https://www.postgresql.org/docs/10/static/app-initdb.html) indicates that
it must be executed with the user postgres, but the command only works if I
execute it as root.

This command does not seem to interpret the parameter step indicated in the
documentation, these are the problem:

(run as root) yum install -y
https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-centos10-10-2.noarch.rpm
(run as root) yum install -y postgresql10 postgresql10-server
(run as root) cd /
(run as root) mkdir data
(run as root) chown -R postgres.postgres data
(run as postgres) /usr/pgsql-10/bin/postgresql-10-setup initdb
-bash-4.2$ /usr/pgsql-10/bin/postgresql-10-setup initdb -D /data -A trust -U
postgres
systemctl: invalid option -- 'D'
failed to find PGDATA setting in -D.service

-bash-4.2$ /usr/pgsql-10/bin/postgresql-10-setup initdb -D /data/ -A trust
-U postgres
systemctl: invalid option -- 'D'
failed to find PGDATA setting in -D.service

-bash-4.2$ /usr/pgsql-10/bin/postgresql-10-setup initdb --pgadata=/data/ -A
trust -U postgres
systemctl: unrecognized option '--pgadata=/data/.service'
failed to find PGDATA setting in --pgadata=/data/.service

Should the environment variable PGDATA in
/usr/lib/systemd/system/postgresql-10.service be overwrited after the
database is initialized?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Sergei Kornilov 2018-03-13 12:31:53 Re: BUG #15108: Initialization problem postgresql-10-setup initdb
Previous Message Michael Paquier 2018-03-13 06:22:14 Re: BUG #15096: Unable to CREATE TABLE LIKE with bigint identity column