Re: initdb failure with Postgres 8.4.4

On 12/10/2010 09:55 AM, Robert Haas wrote:
> On Fri, Dec 10, 2010 at 9:00 AM, BRUSSER Michael
> <Michael(dot)BRUSSER(at)3ds(dot)com> wrote:
>> 1) The pathnames referenced in the log do not have any dots, I just truncated them -
>> they are absolute pathnames to where the timezone files are locates in the source or build tree
>> I'll post the entire log if it is still needed after this ...
> Well, why are you configuring the prefix to be inside your build tree?
> This is an odd thing to do. The prefix should be set to where you
> expect to install the files, not where you're building them.
>
> CONFIGURE = '--prefix=/home/<build-path>/build/Linux/qe_x86_64'
> '--without-readline' '--without-zlib'
>
> Still:
>
>> Not claiming any knowledge in this area - would it be reasonable to expect that if -L option works for other input files it should
>> also work for timezones?
> ...this seems reasonable.

OK, this has nothing at all to do with the absence of the build path. It
has to do with using a non-standard sharedir.I have reproduced it thus:

[andrew(at)aurelia blurflinst]$ mv share/ foo
[andrew(at)aurelia blurflinst]$ bin/initdb -L `pwd`/foo/postgresql data3
The files belonging to this database system will be owned by user
"andrew".
This user must also own the server process.

The database cluster will be initialized with locale en_US.utf8.
The default database encoding has accordingly been set to UTF8.
The default text search configuration will be set to "english".

creating directory data3 ... ok
creating subdirectories ... ok
selecting default max_connections ... 10
selecting default shared_buffers ... 400kB
creating configuration files ... ok
creating template1 database in data3/base/1 ... WARNING: could not
open directory
"/home/andrew/pgl/blurflinst/share/postgresql/timezonesets": No such
file or directory
HINT: This may indicate an incomplete PostgreSQL installation, or
that the file "/home/andrew/pgl/blurflinst/bin/postgres" has been
moved away from its proper location.
FATAL: invalid value for parameter "timezone_abbreviations": "Default"
child process exited with exit code 1
initdb: removing data directory "data3"
[andrew(at)aurelia blurflinst]$

I will dig a bit further.

cheers

andrew