Re: BUG #14955: postgresql10-server-10.1-3PGDG.rhel6 initdb isssue - Mailing list pgsql-bugs

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.barzakov@gmail.com wrote:
> The following bug has been logged on the website:
>
> Bug reference:      14955
> Logged by:          Petar Barzakov
> Email address:      peter.barzakov@gmail.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@localhost ~]# rpm -qa |grep postgres
>       [root@localhost ~]# ls -alh /var/lib/pgsql*
>       ls: cannot access /var/lib/pgsql*: No such file or directory
>       [root@localhost ~]# yum -q -y install postgresql10 postgresql10-contrib
> postgresql10-devel postgresql10-libs postgresql10-server; echo $?
>       0
>       [root@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@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@localhost ~]# rpm -qf /var/lib/pgsql/10/data/
>       postgresql10-server-10.1-3PGDG.rhel6.x86_64
>       [root@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@localhost ~]# /etc/init.d/postgresql-10 initdb
>       Initializing database:                                     [FAILED]
>       [root@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@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@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@localhost ~]# rm -rf /var/lib/pgsql/10/data
>       [root@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@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@localhost ~]# rm -rf /var/lib/pgsql/10/
>       [root@localhost ~]# /etc/init.d/postgresql-10 initdb
>       Initializing database:                                     [FAILED]
>       [root@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@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@localhost ~]#
>
>
>

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