From: | peter(dot)barzakov(at)gmail(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Cc: | peter(dot)barzakov(at)gmail(dot)com |
Subject: | BUG #14955: postgresql10-server-10.1-3PGDG.rhel6 initdb isssue |
Date: | 2017-12-08 12:58:55 |
Message-ID: | 20171208125855.21691.22528@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: 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 ~]#
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2017-12-08 14:44:48 | Re: BUG #14952: COPY fails to fill in IDENTITY column default value |
Previous Message | Alexander Korotkov | 2017-12-08 11:50:20 | Re: Fwd: [BUGS] pg_trgm word_similarity inconsistencies or bug |