Thread: pg_createcluster failing on Trusty

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