Re: 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(dot)sa(at)gmail(dot)com
To: kierenscott(at)hotmail(dot)com
CC: pgsql-admin(at)postgresql(dot)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(at)hotmail(dot)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(at)xxxxx:/var/lib# apt-get install postgresql-9.3 postgresql-contrib-9.3Reading package lists... DoneBuilding dependency treeReading state information... DoneThe following extra packages will be installed: postgresql-client-9.3 postgresql-client-common postgresql-commonSuggested packages: oidentd ident-server locales-all postgresql-doc-9.3 libdbd-pg-perlThe following NEW packages will be installed: postgresql-9.3 postgresql-client-9.3 postgresql-client-common postgresql-common postgresql-contrib-9.30 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] yPreconfiguring 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 modeSetting up postgresql-common (154) ...
Creating config file /etc/logrotate.d/postgresql-common with new versionBuilding 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 CError: initdb failedError: 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(at)hotmail(dot)com
To: pgsql-admin(at)postgresql(dot)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 postgpostgresql installpostgresql-9.3 installpostgresql-client installpostgresql-client-9.3 installpostgresql-client-common installpostgresql-common installpostgresql-contrib installpostgresql-contrib-9.3 install
root(at)xxxxxx:# pg_createcluster 9.3 mainCreating new cluster 9.3/main ... config /etc/postgresql/9.3/main data /var/lib/postgresql/9.3/main locale CError: initdb failed
$ lsb_release -aNo LSB modules are available.Distributor ID: UbuntuDescription: Ubuntu 14.04.1 LTSRelease: 14.04Codename: trusty

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

--
Luis Antonio Dias de Sá Junior