[Pkg-postgresql-public] Bug#872660: postgresql-common: When creating a cluster from pg_createcluster, the cluster starting command displayed is incorrect
Carayol
jeanpierre.carayol at free.fr
Sat Aug 19 20:52:49 UTC 2017
Package: postgresql-common
Version: 184.pgdg+1
Severity: minor
Dear Maintainer,
*** Reporter, please consider answering these questions, where appropriate ***
* What led up to the situation?
* What exactly did you do (or not do) that was effective (or
ineffective)?
* What was the outcome of this action?
* What outcome did you expect instead?
Step to reproduce
- install postgresql 10
- create a new 10 postgresq cluster from pg_createcluster command
ex : pg_createcluster 10 jp -p 5444
The cluster is well created and the following information is displayed :
Success. You can now start the database server using:
/usr/lib/postgresql/10/bin/pg_ctl -D /var/lib/postgresql/10/jp -l logfile start
- connect under postgres Debian account and try to start the cluster with the previous command. It fails.
/usr/lib/postgresql/10/bin/pg_ctl -D /var/lib/postgresql/10/jp start
waiting for server to start....postgres:
could not access the server configuration file "/var/lib/postgresql/10/jp/postgresql.conf": No such file or directory
stopped waiting
pg_ctl: could not start server
The reason is when you use pg_createcluster to create the cluster, the postgresql.conf file is
under "/etc/postgresql/10/<CLUSTERNAME>"
not under "/var/lib/postgresql/10/jp/postgresql.conf" .
So, correct command for starting the cluster is /usr/lib/postgresql/10/bin/pg_ctl -D /etc/postgresql/10/<CLUSTERNAME> start
For me, the correct command for starting the cluster should be displayed when creating a cluster from pg_createcluster.
Thanks for your work.
*** End of the template - remove these template lines ***
-- System Information:
Debian Release: 9.1
APT prefers stable
APT policy: (500, 'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 4.9.0-3-amd64 (SMP w/1 CPU core)
Locale: LANG=fr_FR at euro, LC_CTYPE=fr_FR at euro (charmap=ISO-8859-15), LANGUAGE=fr_FR at euro (charmap=ISO-8859-15)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
Versions of packages postgresql-common depends on:
ii adduser 3.115
ii debconf [debconf-2.0] 1.5.61
ii init-system-helpers 1.48
ii lsb-base 9.20161125
ii postgresql-client-common 184.pgdg+1
ii procps 2:3.3.12-3
ii ssl-cert 1.0.39
ii ucf 3.0036
Versions of packages postgresql-common recommends:
ii logrotate 3.11.0-0.1
Versions of packages postgresql-common suggests:
pn libjson-perl <none>
-- debconf information excluded
More information about the Pkg-postgresql-public
mailing list