Re: pg_createcluster failing on Trusty

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(at)hotmail(dot)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(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.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(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 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(at)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
>