BUG #14955: postgresql10-server-10.1-3PGDG.rhel6 initdb isssue - Mailing list pgsql-bugs
| From | peter.barzakov@gmail.com |
|---|---|
| Subject | BUG #14955: postgresql10-server-10.1-3PGDG.rhel6 initdb isssue |
| Date | |
| Msg-id | 20171208125855.21691.22528@wrigleys.postgresql.org Whole thread Raw |
| Responses |
Re: BUG #14955: postgresql10-server-10.1-3PGDG.rhel6 initdb isssue
|
| List | pgsql-bugs |
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 ~]#
pgsql-bugs by date: