[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