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@xxxxxxxxxxx> 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: pg_createcluster failing on Trusty
From: luisjunior.sa@xxxxxxxxx
To: kierenscott@xxxxxxxxxxx
CC: pgsql-admin@xxxxxxxxxxxxxxHi,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@xxxxxxxxxxx>:Hi allI'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.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-commonpostgresql-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/maindata /var/lib/postgresql/9.3/mainlocale CError: initdb failedError: could not create default cluster. Please create it manually withpg_createcluster 9.3 main --startor 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@xxxxxxxxxxx
To: pgsql-admin@xxxxxxxxxxxxxx
Subject: [ADMIN] pg_createcluster failing on Trusty
Date: Fri, 6 Feb 2015 14:08:11 +0000
HiI'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 installroot@xxxxxx:# pg_createcluster 9.3 mainCreating new cluster 9.3/main ...config /etc/postgresql/9.3/maindata /var/lib/postgresql/9.3/mainlocale CError: initdb failed$ lsb_release -aNo LSB modules are available.Distributor ID: UbuntuDescription: Ubuntu 14.04.1 LTSRelease: 14.04Codename: trustyHas anyone else hit this problem or know what might be causing this?Many thanks.--Luis Antonio Dias de Sá Junior
