| 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: | Whole Thread | Raw Message | 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?
| 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 |