Thread: pg_createcluster failing on Trusty

pg_createcluster failing on Trusty

From
Kieren Scott
Date:
Hi

I'm trying to run pg_createcluster on Ubuntu Trusty 14.04 LTS, but initdb is failing. I've installed the below packages and then run the "pg_createcluster 9.3 main" command as root.

$ dpkg --get-selections | grep -v deinstall|grep postg
postgresql                                      install
postgresql-9.3                                  install
postgresql-client                               install
postgresql-client-9.3                           install
postgresql-client-common                        install
postgresql-common                               install
postgresql-contrib                              install
postgresql-contrib-9.3                          install

root@xxxxxx:# pg_createcluster 9.3 main
Creating new cluster 9.3/main ...
  config /etc/postgresql/9.3/main
  data   /var/lib/postgresql/9.3/main
  locale C
Error: initdb failed

$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description:    Ubuntu 14.04.1 LTS
Release:        14.04
Codename:       trusty


Has anyone else hit this problem or know what might be causing this?

Many thanks.

Re: pg_createcluster failing on Trusty

From
Kieren Scott
Date:
Hi all

I've tried reinstalling the packages but am still continuing to hit the "initdb failed" even when the packages are installed. If anyone has any ideas as to what might be causing this (or what to try next) it would be much appreciated, as im keen to get started with pg 9.3 for a migration project.

Many thanks.

root@xxxxx:/var/lib# apt-get install postgresql-9.3 postgresql-contrib-9.3
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
  postgresql-client-9.3 postgresql-client-common postgresql-common
Suggested packages:
  oidentd ident-server locales-all postgresql-doc-9.3 libdbd-pg-perl
The following NEW packages will be installed:
  postgresql-9.3 postgresql-client-9.3 postgresql-client-common
  postgresql-common postgresql-contrib-9.3
0 upgraded, 5 newly installed, 0 to remove and 0 not upgraded.
Need to get 0 B/3980 kB of archives.
After this operation, 16.9 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Preconfiguring packages ...
Selecting previously unselected package postgresql-client-common.
(Reading database ... 32267 files and directories currently installed.)
Preparing to unpack .../postgresql-client-common_154_all.deb ...
Unpacking postgresql-client-common (154) ...
Selecting previously unselected package postgresql-client-9.3.
Preparing to unpack .../postgresql-client-9.3_9.3.5-0ubuntu0.14.04.1_amd64.deb ...
Unpacking postgresql-client-9.3 (9.3.5-0ubuntu0.14.04.1) ...
Selecting previously unselected package postgresql-common.
Preparing to unpack .../postgresql-common_154_all.deb ...
Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common'
Unpacking postgresql-common (154) ...
Selecting previously unselected package postgresql-9.3.
Preparing to unpack .../postgresql-9.3_9.3.5-0ubuntu0.14.04.1_amd64.deb ...
Unpacking postgresql-9.3 (9.3.5-0ubuntu0.14.04.1) ...
Selecting previously unselected package postgresql-contrib-9.3.
Preparing to unpack .../postgresql-contrib-9.3_9.3.5-0ubuntu0.14.04.1_amd64.deb ...
Unpacking postgresql-contrib-9.3 (9.3.5-0ubuntu0.14.04.1) ...
Processing triggers for man-db (2.6.7.1-1) ...
Processing triggers for ureadahead (0.100.0-16) ...
Setting up postgresql-client-common (154) ...
Setting up postgresql-client-9.3 (9.3.5-0ubuntu0.14.04.1) ...
update-alternatives: using /usr/share/postgresql/9.3/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode
Setting up postgresql-common (154) ...

Creating config file /etc/logrotate.d/postgresql-common with new version
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
Removing obsolete dictionary files:
 * No PostgreSQL clusters exist; see "man pg_createcluster"
Processing triggers for ureadahead (0.100.0-16) ...
Setting up postgresql-9.3 (9.3.5-0ubuntu0.14.04.1) ...
Creating new cluster 9.3/main ...
  config /etc/postgresql/9.3/main
  data   /var/lib/postgresql/9.3/main
  locale C
Error: initdb failed
Error: could not create default cluster. Please create it manually with

  pg_createcluster 9.3 main --start

or a similar command (see 'man pg_createcluster').
update-alternatives: using /usr/share/postgresql/9.3/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode
 * No PostgreSQL clusters exist; see "man pg_createcluster"
Setting up postgresql-contrib-9.3 (9.3.5-0ubuntu0.14.04.1) ...



From: kierenscott@hotmail.com
To: pgsql-admin@postgresql.org
Subject: [ADMIN] pg_createcluster failing on Trusty
Date: Fri, 6 Feb 2015 14:08:11 +0000

Hi

I'm trying to run pg_createcluster on Ubuntu Trusty 14.04 LTS, but initdb is failing. I've installed the below packages and then run the "pg_createcluster 9.3 main" command as root.

$ dpkg --get-selections | grep -v deinstall|grep postg
postgresql                                      install
postgresql-9.3                                  install
postgresql-client                               install
postgresql-client-9.3                           install
postgresql-client-common                        install
postgresql-common                               install
postgresql-contrib                              install
postgresql-contrib-9.3                          install

root@xxxxxx:# pg_createcluster 9.3 main
Creating new cluster 9.3/main ...
  config /etc/postgresql/9.3/main
  data   /var/lib/postgresql/9.3/main
  locale C
Error: initdb failed

$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description:    Ubuntu 14.04.1 LTS
Release:        14.04
Codename:       trusty


Has anyone else hit this problem or know what might be causing this?

Many thanks.

Re: pg_createcluster failing on Trusty

From
Luis Antonio Dias de Sá Junior
Date:
Hi,

Any log in file logs? 
Try use -d /path/to/data, maybe permssion problem...

2015-02-09 7:11 GMT-02:00 Kieren Scott <kierenscott@hotmail.com>:
Hi all

I've tried reinstalling the packages but am still continuing to hit the "initdb failed" even when the packages are installed. If anyone has any ideas as to what might be causing this (or what to try next) it would be much appreciated, as im keen to get started with pg 9.3 for a migration project.

Many thanks.

root@xxxxx:/var/lib# apt-get install postgresql-9.3 postgresql-contrib-9.3
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
  postgresql-client-9.3 postgresql-client-common postgresql-common
Suggested packages:
  oidentd ident-server locales-all postgresql-doc-9.3 libdbd-pg-perl
The following NEW packages will be installed:
  postgresql-9.3 postgresql-client-9.3 postgresql-client-common
  postgresql-common postgresql-contrib-9.3
0 upgraded, 5 newly installed, 0 to remove and 0 not upgraded.
Need to get 0 B/3980 kB of archives.
After this operation, 16.9 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Preconfiguring packages ...
Selecting previously unselected package postgresql-client-common.
(Reading database ... 32267 files and directories currently installed.)
Preparing to unpack .../postgresql-client-common_154_all.deb ...
Unpacking postgresql-client-common (154) ...
Selecting previously unselected package postgresql-client-9.3.
Preparing to unpack .../postgresql-client-9.3_9.3.5-0ubuntu0.14.04.1_amd64.deb ...
Unpacking postgresql-client-9.3 (9.3.5-0ubuntu0.14.04.1) ...
Selecting previously unselected package postgresql-common.
Preparing to unpack .../postgresql-common_154_all.deb ...
Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common'
Unpacking postgresql-common (154) ...
Selecting previously unselected package postgresql-9.3.
Preparing to unpack .../postgresql-9.3_9.3.5-0ubuntu0.14.04.1_amd64.deb ...
Unpacking postgresql-9.3 (9.3.5-0ubuntu0.14.04.1) ...
Selecting previously unselected package postgresql-contrib-9.3.
Preparing to unpack .../postgresql-contrib-9.3_9.3.5-0ubuntu0.14.04.1_amd64.deb ...
Unpacking postgresql-contrib-9.3 (9.3.5-0ubuntu0.14.04.1) ...
Processing triggers for man-db (2.6.7.1-1) ...
Processing triggers for ureadahead (0.100.0-16) ...
Setting up postgresql-client-common (154) ...
Setting up postgresql-client-9.3 (9.3.5-0ubuntu0.14.04.1) ...
update-alternatives: using /usr/share/postgresql/9.3/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode
Setting up postgresql-common (154) ...

Creating config file /etc/logrotate.d/postgresql-common with new version
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
Removing obsolete dictionary files:
 * No PostgreSQL clusters exist; see "man pg_createcluster"
Processing triggers for ureadahead (0.100.0-16) ...
Setting up postgresql-9.3 (9.3.5-0ubuntu0.14.04.1) ...
Creating new cluster 9.3/main ...
  config /etc/postgresql/9.3/main
  data   /var/lib/postgresql/9.3/main
  locale C
Error: initdb failed
Error: could not create default cluster. Please create it manually with

  pg_createcluster 9.3 main --start

or a similar command (see 'man pg_createcluster').
update-alternatives: using /usr/share/postgresql/9.3/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode
 * No PostgreSQL clusters exist; see "man pg_createcluster"
Setting up postgresql-contrib-9.3 (9.3.5-0ubuntu0.14.04.1) ...



From: kierenscott@hotmail.com
To: pgsql-admin@postgresql.org
Subject: [ADMIN] pg_createcluster failing on Trusty
Date: Fri, 6 Feb 2015 14:08:11 +0000


Hi

I'm trying to run pg_createcluster on Ubuntu Trusty 14.04 LTS, but initdb is failing. I've installed the below packages and then run the "pg_createcluster 9.3 main" command as root.

$ dpkg --get-selections | grep -v deinstall|grep postg
postgresql                                      install
postgresql-9.3                                  install
postgresql-client                               install
postgresql-client-9.3                           install
postgresql-client-common                        install
postgresql-common                               install
postgresql-contrib                              install
postgresql-contrib-9.3                          install

root@xxxxxx:# pg_createcluster 9.3 main
Creating new cluster 9.3/main ...
  config /etc/postgresql/9.3/main
  data   /var/lib/postgresql/9.3/main
  locale C
Error: initdb failed

$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description:    Ubuntu 14.04.1 LTS
Release:        14.04
Codename:       trusty


Has anyone else hit this problem or know what might be causing this?

Many thanks.




--
Luis Antonio Dias de Sá Junior

Re: pg_createcluster failing on Trusty

From
Kieren Scott
Date:
Thanks for your reply. There are no logs that I can see created at this point. I've tried specifying the data directory and also checked all sorts of permissions, but I still get the initdb error. If I run initdb manually as the postgres user, it runs ok. But when I run pg_createcluster (run as root) if says initdb failed.


Date: Mon, 9 Feb 2015 08:59:34 -0200
Subject: Re: [ADMIN] pg_createcluster failing on Trusty
From: luisjunior.sa@gmail.com
To: kierenscott@hotmail.com
CC: pgsql-admin@postgresql.org

Hi,

Any log in file logs? 
Try use -d /path/to/data, maybe permssion problem...

2015-02-09 7:11 GMT-02:00 Kieren Scott <kierenscott@hotmail.com>:
Hi all

I've tried reinstalling the packages but am still continuing to hit the "initdb failed" even when the packages are installed. If anyone has any ideas as to what might be causing this (or what to try next) it would be much appreciated, as im keen to get started with pg 9.3 for a migration project.

Many thanks.

root@xxxxx:/var/lib# apt-get install postgresql-9.3 postgresql-contrib-9.3
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
  postgresql-client-9.3 postgresql-client-common postgresql-common
Suggested packages:
  oidentd ident-server locales-all postgresql-doc-9.3 libdbd-pg-perl
The following NEW packages will be installed:
  postgresql-9.3 postgresql-client-9.3 postgresql-client-common
  postgresql-common postgresql-contrib-9.3
0 upgraded, 5 newly installed, 0 to remove and 0 not upgraded.
Need to get 0 B/3980 kB of archives.
After this operation, 16.9 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Preconfiguring packages ...
Selecting previously unselected package postgresql-client-common.
(Reading database ... 32267 files and directories currently installed.)
Preparing to unpack .../postgresql-client-common_154_all.deb ...
Unpacking postgresql-client-common (154) ...
Selecting previously unselected package postgresql-client-9.3.
Preparing to unpack .../postgresql-client-9.3_9.3.5-0ubuntu0.14.04.1_amd64.deb ...
Unpacking postgresql-client-9.3 (9.3.5-0ubuntu0.14.04.1) ...
Selecting previously unselected package postgresql-common.
Preparing to unpack .../postgresql-common_154_all.deb ...
Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common'
Unpacking postgresql-common (154) ...
Selecting previously unselected package postgresql-9.3.
Preparing to unpack .../postgresql-9.3_9.3.5-0ubuntu0.14.04.1_amd64.deb ...
Unpacking postgresql-9.3 (9.3.5-0ubuntu0.14.04.1) ...
Selecting previously unselected package postgresql-contrib-9.3.
Preparing to unpack .../postgresql-contrib-9.3_9.3.5-0ubuntu0.14.04.1_amd64.deb ...
Unpacking postgresql-contrib-9.3 (9.3.5-0ubuntu0.14.04.1) ...
Processing triggers for man-db (2.6.7.1-1) ...
Processing triggers for ureadahead (0.100.0-16) ...
Setting up postgresql-client-common (154) ...
Setting up postgresql-client-9.3 (9.3.5-0ubuntu0.14.04.1) ...
update-alternatives: using /usr/share/postgresql/9.3/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode
Setting up postgresql-common (154) ...

Creating config file /etc/logrotate.d/postgresql-common with new version
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
Removing obsolete dictionary files:
 * No PostgreSQL clusters exist; see "man pg_createcluster"
Processing triggers for ureadahead (0.100.0-16) ...
Setting up postgresql-9.3 (9.3.5-0ubuntu0.14.04.1) ...
Creating new cluster 9.3/main ...
  config /etc/postgresql/9.3/main
  data   /var/lib/postgresql/9.3/main
  locale C
Error: initdb failed
Error: could not create default cluster. Please create it manually with

  pg_createcluster 9.3 main --start

or a similar command (see 'man pg_createcluster').
update-alternatives: using /usr/share/postgresql/9.3/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode
 * No PostgreSQL clusters exist; see "man pg_createcluster"
Setting up postgresql-contrib-9.3 (9.3.5-0ubuntu0.14.04.1) ...



From: kierenscott@hotmail.com
To: pgsql-admin@postgresql.org
Subject: [ADMIN] pg_createcluster failing on Trusty
Date: Fri, 6 Feb 2015 14:08:11 +0000


Hi

I'm trying to run pg_createcluster on Ubuntu Trusty 14.04 LTS, but initdb is failing. I've installed the below packages and then run the "pg_createcluster 9.3 main" command as root.

$ dpkg --get-selections | grep -v deinstall|grep postg
postgresql                                      install
postgresql-9.3                                  install
postgresql-client                               install
postgresql-client-9.3                           install
postgresql-client-common                        install
postgresql-common                               install
postgresql-contrib                              install
postgresql-contrib-9.3                          install

root@xxxxxx:# pg_createcluster 9.3 main
Creating new cluster 9.3/main ...
  config /etc/postgresql/9.3/main
  data   /var/lib/postgresql/9.3/main
  locale C
Error: initdb failed

$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description:    Ubuntu 14.04.1 LTS
Release:        14.04
Codename:       trusty


Has anyone else hit this problem or know what might be causing this?

Many thanks.




--
Luis Antonio Dias de Sá Junior

Re: pg_createcluster failing on Trusty

From
Matheus de Oliveira
Date:

On Mon, Feb 9, 2015 at 2:53 PM, Kieren Scott <kierenscott@hotmail.com> wrote:
If I run initdb manually as the postgres user, it runs ok. But when I run pg_createcluster (run as root) if says initdb failed.

Have you tried running pg_createcluster as postgres user?

Regards,
--
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres

Re: pg_createcluster failing on Trusty

From
Luis Antonio Dias de Sá Junior
Date:

Other possibility: the repositoty is postgres official?

Em 09/02/2015 14:59, "Matheus de Oliveira" <matioli.matheus@gmail.com> escreveu:

On Mon, Feb 9, 2015 at 2:53 PM, Kieren Scott <kierenscott@hotmail.com> wrote:
If I run initdb manually as the postgres user, it runs ok. But when I run pg_createcluster (run as root) if says initdb failed.

Have you tried running pg_createcluster as postgres user?

Regards,
--
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres

Re: pg_createcluster failing on Trusty

From
Elías David
Date:
Last time I remember having issues to initdb on Ubuntu was due to LC_ALL locale not being set (there was a bug reported at that time, can't find it now), don't know if you're something like this, but you could try:

LC_ALL=C pg_createcluster 9.3 main --start

On Mon Feb 09 2015 at 12:24:09 PM Kieren Scott <kierenscott@hotmail.com> wrote:
Thanks for your reply. There are no logs that I can see created at this point. I've tried specifying the data directory and also checked all sorts of permissions, but I still get the initdb error. If I run initdb manually as the postgres user, it runs ok. But when I run pg_createcluster (run as root) if says initdb failed.

Date: Mon, 9 Feb 2015 08:59:34 -0200
Subject: Re: [ADMIN] pg_createcluster failing on Trusty
From: luisjunior.sa@gmail.com
To: kierenscott@hotmail.com
CC: pgsql-admin@postgresql.org


Hi,

Any log in file logs? 
Try use -d /path/to/data, maybe permssion problem...

2015-02-09 7:11 GMT-02:00 Kieren Scott <kierenscott@hotmail.com>:
Hi all

I've tried reinstalling the packages but am still continuing to hit the "initdb failed" even when the packages are installed. If anyone has any ideas as to what might be causing this (or what to try next) it would be much appreciated, as im keen to get started with pg 9.3 for a migration project.

Many thanks.

root@xxxxx:/var/lib# apt-get install postgresql-9.3 postgresql-contrib-9.3
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
  postgresql-client-9.3 postgresql-client-common postgresql-common
Suggested packages:
  oidentd ident-server locales-all postgresql-doc-9.3 libdbd-pg-perl
The following NEW packages will be installed:
  postgresql-9.3 postgresql-client-9.3 postgresql-client-common
  postgresql-common postgresql-contrib-9.3
0 upgraded, 5 newly installed, 0 to remove and 0 not upgraded.
Need to get 0 B/3980 kB of archives.
After this operation, 16.9 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Preconfiguring packages ...
Selecting previously unselected package postgresql-client-common.
(Reading database ... 32267 files and directories currently installed.)
Preparing to unpack .../postgresql-client-common_154_all.deb ...
Unpacking postgresql-client-common (154) ...
Selecting previously unselected package postgresql-client-9.3.
Preparing to unpack .../postgresql-client-9.3_9.3.5-0ubuntu0.14.04.1_amd64.deb ...
Unpacking postgresql-client-9.3 (9.3.5-0ubuntu0.14.04.1) ...
Selecting previously unselected package postgresql-common.
Preparing to unpack .../postgresql-common_154_all.deb ...
Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common'
Unpacking postgresql-common (154) ...
Selecting previously unselected package postgresql-9.3.
Preparing to unpack .../postgresql-9.3_9.3.5-0ubuntu0.14.04.1_amd64.deb ...
Unpacking postgresql-9.3 (9.3.5-0ubuntu0.14.04.1) ...
Selecting previously unselected package postgresql-contrib-9.3.
Preparing to unpack .../postgresql-contrib-9.3_9.3.5-0ubuntu0.14.04.1_amd64.deb ...
Unpacking postgresql-contrib-9.3 (9.3.5-0ubuntu0.14.04.1) ...
Processing triggers for man-db (2.6.7.1-1) ...
Processing triggers for ureadahead (0.100.0-16) ...
Setting up postgresql-client-common (154) ...
Setting up postgresql-client-9.3 (9.3.5-0ubuntu0.14.04.1) ...
update-alternatives: using /usr/share/postgresql/9.3/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode
Setting up postgresql-common (154) ...

Creating config file /etc/logrotate.d/postgresql-common with new version
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
Removing obsolete dictionary files:
 * No PostgreSQL clusters exist; see "man pg_createcluster"
Processing triggers for ureadahead (0.100.0-16) ...
Setting up postgresql-9.3 (9.3.5-0ubuntu0.14.04.1) ...
Creating new cluster 9.3/main ...
  config /etc/postgresql/9.3/main
  data   /var/lib/postgresql/9.3/main
  locale C
Error: initdb failed
Error: could not create default cluster. Please create it manually with

  pg_createcluster 9.3 main --start

or a similar command (see 'man pg_createcluster').
update-alternatives: using /usr/share/postgresql/9.3/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode
 * No PostgreSQL clusters exist; see "man pg_createcluster"
Setting up postgresql-contrib-9.3 (9.3.5-0ubuntu0.14.04.1) ...



From: kierenscott@hotmail.com
To: pgsql-admin@postgresql.org
Subject: [ADMIN] pg_createcluster failing on Trusty
Date: Fri, 6 Feb 2015 14:08:11 +0000


Hi

I'm trying to run pg_createcluster on Ubuntu Trusty 14.04 LTS, but initdb is failing. I've installed the below packages and then run the "pg_createcluster 9.3 main" command as root.

$ dpkg --get-selections | grep -v deinstall|grep postg
postgresql                                      install
postgresql-9.3                                  install
postgresql-client                               install
postgresql-client-9.3                           install
postgresql-client-common                        install
postgresql-common                               install
postgresql-contrib                              install
postgresql-contrib-9.3                          install

root@xxxxxx:# pg_createcluster 9.3 main
Creating new cluster 9.3/main ...
  config /etc/postgresql/9.3/main
  data   /var/lib/postgresql/9.3/main
  locale C
Error: initdb failed

$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description:    Ubuntu 14.04.1 LTS
Release:        14.04
Codename:       trusty


Has anyone else hit this problem or know what might be causing this?

Many thanks.




--
Luis Antonio Dias de Sá Junior