Re: BUG #14955: postgresql10-server-10.1-3PGDG.rhel6 initdb isssue

Hi,

Thanks for the report. Pushed 10.1-4 RPMs to RHEL 6 repo, which fixes this
issue. Apologies for the inconvenience.

Regards, Devrim

On Fri, 2017-12-08 at 12:58 +0000, peter(dot)barzakov(at)gmail(dot)com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 14955
> Logged by: Petar Barzakov
> Email address: peter(dot)barzakov(at)gmail(dot)com
> PostgreSQL version: 10.1
> Operating system: COS6
> Description:
>
> How to reproduce:
> rpm -qa |grep postgres
> ls -alh /var/lib/pgsql*
> yum -q -y install postgresql10 postgresql10-contrib postgresql10-devel
> postgresql10-libs postgresql10-server; echo $?
> rpm -qa |grep postgres
> ls -alh /var/lib/pgsql*
> rpm -qf /var/lib/pgsql/10/data/
> ls -alh /var/lib/pgsql/10/*/
> /etc/init.d/postgresql-10 initdb
> ls -alh /var/lib/pgsql/10/*/
> ls -alh /var/lib/pgsql/10/
> cat /var/lib/pgsql/10/pgstartup.log
> rm -rf /var/lib/pgsql/10/data
> ls -alh /var/lib/pgsql/10/*/
> ls -alh /var/lib/pgsql/10/
>
>
>
> Issue:
> [root(at)localhost ~]# rpm -qa |grep postgres
> [root(at)localhost ~]# ls -alh /var/lib/pgsql*
> ls: cannot access /var/lib/pgsql*: No such file or directory
> [root(at)localhost ~]# yum -q -y install postgresql10 postgresql10-contrib
> postgresql10-devel postgresql10-libs postgresql10-server; echo $?
> 0
> [root(at)localhost ~]# rpm -qa |grep postgres
> postgresql10-10.1-3PGDG.rhel6.x86_64
> postgresql10-server-10.1-3PGDG.rhel6.x86_64
> postgresql10-libs-10.1-3PGDG.rhel6.x86_64
> postgresql10-devel-10.1-3PGDG.rhel6.x86_64
> postgresql10-contrib-10.1-3PGDG.rhel6.x86_64
> [root(at)localhost ~]# ls -alh /var/lib/pgsql*
> total 16K
> drwx------ 3 postgres postgres 4.0K Dec 8 07:53 .
> drwxr-xr-x 13 root root 4.0K Dec 8 07:53 ..
> drwx------ 4 postgres postgres 4.0K Dec 8 07:53 10
> -rwx------ 1 postgres postgres 266 Dec 8 07:53 .bash_profile
> [root(at)localhost ~]# rpm -qf /var/lib/pgsql/10/data/
> postgresql10-server-10.1-3PGDG.rhel6.x86_64
> [root(at)localhost ~]# ls -alh /var/lib/pgsql/10/*/
> /var/lib/pgsql/10/backups/:
> total 8.0K
> drwx------ 2 postgres postgres 4.0K Dec 7 14:37 .
> drwx------ 4 postgres postgres 4.0K Dec 8 07:53 ..
>
> /var/lib/pgsql/10/data/:
> total 8.0K
> drwx------ 2 postgres postgres 4.0K Dec 7 14:37 .
> drwx------ 4 postgres postgres 4.0K Dec 8 07:53 ..
> [root(at)localhost ~]# /etc/init.d/postgresql-10 initdb
> Initializing database: [FAILED]
> [root(at)localhost ~]# ls -alh /var/lib/pgsql/10/*/
> /var/lib/pgsql/10/backups/:
> total 8.0K
> drwx------ 2 postgres postgres 4.0K Dec 7 14:37 .
> drwx------ 4 postgres postgres 4.0K Dec 8 07:53 ..
>
> /var/lib/pgsql/10/data/:
> total 12K
> drwx------ 3 postgres postgres 4.0K Dec 8 07:53 .
> drwx------ 4 postgres postgres 4.0K Dec 8 07:53 ..
> drwx------ 2 postgres postgres 4.0K Dec 8 07:53 log
> [root(at)localhost ~]# ls -alh /var/lib/pgsql/10/
> total 16K
> drwx------ 4 postgres postgres 4.0K Dec 8 07:53 .
> drwx------ 3 postgres postgres 4.0K Dec 8 07:53 ..
> drwx------ 2 postgres postgres 4.0K Dec 7 14:37 backups
> drwx------ 3 postgres postgres 4.0K Dec 8 07:53 data
> -rw------- 1 postgres postgres 0 Dec 8 07:53 pgstartup.log
> [root(at)localhost ~]# cat /var/lib/pgsql/10/pgstartup.log
> The files belonging to this database system will be owned by user
> "postgres".
> This user must also own the server process.
>
> The database cluster will be initialized with locale "en_US.UTF-8".
> The default database encoding has accordingly been set to "UTF8".
> The default text search configuration will be set to "english".
>
> Data page checksums are disabled.
>
> initdb: directory "/var/lib/pgsql/10/data" exists but is not empty
> If you want to create a new database system, either remove or empty
> the directory "/var/lib/pgsql/10/data" or run initdb
> with an argument other than "/var/lib/pgsql/10/data".
> [root(at)localhost ~]# rm -rf /var/lib/pgsql/10/data
> [root(at)localhost ~]# ls -alh /var/lib/pgsql/10/*/
> total 8.0K
> drwx------ 2 postgres postgres 4.0K Dec 7 14:37 .
> drwx------ 3 postgres postgres 4.0K Dec 8 07:53 ..
> [root(at)localhost ~]# ls -alh /var/lib/pgsql/10/
> total 16K
> drwx------ 3 postgres postgres 4.0K Dec 8 07:53 .
> drwx------ 3 postgres postgres 4.0K Dec 8 07:53 ..
> drwx------ 2 postgres postgres 4.0K Dec 7 14:37 backups
> -rw------- 1 postgres postgres 599 Dec 8 07:53 pgstartup.log
>
> [root(at)localhost ~]# rm -rf /var/lib/pgsql/10/
> [root(at)localhost ~]# /etc/init.d/postgresql-10 initdb
> Initializing database: [FAILED]
> [root(at)localhost ~]# cat /var/lib/pgsql/10/pgstartup.log
> The files belonging to this database system will be owned by user
> "postgres".
> This user must also own the server process.
>
> The database cluster will be initialized with locale "en_US.UTF-8".
> The default database encoding has accordingly been set to "UTF8".
> The default text search configuration will be set to "english".
>
> Data page checksums are disabled.
>
> initdb: directory "/var/lib/pgsql/10/data" exists but is not empty
> If you want to create a new database system, either remove or empty
> the directory "/var/lib/pgsql/10/data" or run initdb
> with an argument other than "/var/lib/pgsql/10/data".
> [root(at)localhost ~]#
>
>
> What is the issue:
> ---
> etc-postgresql10-server-10.1-2PGDG.rhel6.x86_64.rpm/rc.d/init.d/postgresql-10
> 2017-11-30
> 06:05:20.000000000 -0500
> +++
> etc-postgresql10-server-10.1-3PGDG.rhel6.x86_64.rpm/rc.d/init.d/postgresql-10
> 2017-12-07
> 14:37:26.000000000 -0500
> @@ -250,7 +250,7 @@
> initdbcmd="$PGENGINE/initdb --pgdata='$PGDATA' --
> auth='ident'
> $LOCALESTRING"
> initdbcmd+=" $PGSETUP_INITDB_OPTIONS"
>
> - $SU -l postgres -c "$initdbcmd" >> "\$PGLOG\" 2>&1
> &"
> + $SU -l postgres -c "$initdbcmd >> \"$PGLOG\" 2>&1 &"
>
> # Create directory for postmaster log
> mkdir "$PGDATA/log"
> @@ -340,7 +340,7 @@
> su -l postgres -c "$PGENGINE/pg_upgrade \
> -b /usr/pgsql-$PGPREVMAJORVERSION/bin/ -B $PGENGINE/ \
> -d $OLDPGDATA -D $NEWPGDATA \
> - -p $OLDPGPORT -P $NEWPGPORT" >> "$PGUPLOG" 2>&1 &
> + -p $OLDPGPORT -P $NEWPGPORT >> \"$PGUPLOG\" 2>&1 &"
> else
> echo "Cluster check failed. Please see the output above."
> exit 1
> [root(at)localhost ~]#
>
>
>

--
Devrim Gündüz
EnterpriseDB: https://www.enterprisedb.com
PostgreSQL Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR