cannot get build (initdb) to work after trying for a week
I am getting truly desperate! I am trying to build any version of
Postgres on Windows from source. First experience with Postgres
source. I have struggled for days trying to solve a problem. Would be
willing to pay for the solution!!!
The following error occurred when issuing a vanilla initdb command on
my Windows system.
FATAL: could not select a suitable default timezone
DETAIL: It appears that your GMT time zone uses leap seconds.
PostgreSQL does not support leap seconds.
I built this from 8.1.8 source under msys/mingw. Also tried 8.2.2.
Everything builds fine but initdb always reports the above error and
quits.
I was able to run successfully from 8.1.5 binaries on the same
system. This would lead me to believe that it is a simple compiler
switch somewhere that would alleviate this problem.
I have tried variations of configure, including and not including
mingw includes and libs.
I also had to create a typedef int ssize_t in a couple of files to get
the compile finished. Maybe this is related. Other than that, have
not touched any code.
Given that an 8.1.5 binary dist worked for me, what flags were
provided to build that version? Simply configure, then make?
Eric wrote:
I am getting truly desperate! I am trying to build any version of
Postgres on Windows from source. First experience with Postgres
source. I have struggled for days trying to solve a problem. Would be
willing to pay for the solution!!!The following error occurred when issuing a vanilla initdb command on
my Windows system.FATAL: could not select a suitable default timezone
DETAIL: It appears that your GMT time zone uses leap seconds.
PostgreSQL does not support leap seconds.
Try specifying a timezone in postgresql.conf. For initdb, I'd try
specifying it in the TZ environment variable.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Eric wrote:
I am getting truly desperate! I am trying to build any version of
Postgres on Windows from source. First experience with Postgres
source. I have struggled for days trying to solve a problem. Would be
willing to pay for the solution!!!The following error occurred when issuing a vanilla initdb command on
my Windows system.FATAL: could not select a suitable default timezone
DETAIL: It appears that your GMT time zone uses leap seconds.
PostgreSQL does not support leap seconds.I built this from 8.1.8 source under msys/mingw. Also tried 8.2.2.
Everything builds fine but initdb always reports the above error and
quits.
This could happen if the timezone files aren't properly installed. This
should normally happen when you do "make install", but verify that they
are actually present (in share/timezone).
I also had to create a typedef int ssize_t in a couple of files to get
the compile finished. Maybe this is related. Other than that, have
not touched any code.
I don't think that's related, but it's a clear indicator that something
in your environment is broken. Because it should build without any such
changes.
//Magnus
Thanks for responding Magnus.
I did reinstall both msys and mingw, as well as blow away the source
and start over from scratch. Maybe there is a stray file or directory
that's not getting deleted on the clean. Also, does clean just clean
up the compile environment, or does it also clean up the install? I
did manually remove directories too but I suppose I could have missed
something.
Out of desperation, I decided to try everything on my wife's mac,
remembering that os x is unix. Didn't take long at all to download
all the dev tools I needed, get a clean compile and get things running
there.
Can't remember if it was in this forum, but a few people asked why I
was downloading source and not binary - I am experimenting with a
different indexing (multi-dimensional) method. I looked hard at GiST,
but it doesn't look like GiST supports multi-dimensional indexing
methods unless all the dimensions are in a single column. I need to
see each column in the index before making a decision about search
paths to take, branches to follow, etc. GiST appears to support one
column at a time - i.e. if my index is lastname, firstname, then take
a look at lastname, and if that's a tie, then look at firstname. But
it won't let you look at lastname and firstname at the same time, then
make decisions. Other than that, looks like an outstanding feature.
Finally, as a newcomer to PG, I'm in search of general development
resources. Any good places to go besides the PG documentation and the
pgsql newsgroups?
Regards, Eric
(list re-added)
you need a timezone directory, not just timezonesets. So your problem is
why that's not being installed when you do "make install". You need to
check the output from the "make install" command to see if there are any
errors or warnings related to that. (It's done when make install reaches
the src/timezone directory)
The PATH should have nothing to do with it.
//Magnus
Eric Fish wrote:
Show quoted text
Thanks. I just compared my Mac and PC installations. Mac installation
(which works correctly) and has a bunch of entries, including other
directories, under share/postgresql/timezone. The PC installation (which
doesn't work) has a directory share/timezonesets with similar, but far fewer
entries (all .txt files).Also tried prior to running initdb:
export TZ=PST
which didn't work either.
Was thinking that maybe it's my PATH on Windows that could be fouling things
up. I added the necessary bin dirs for pg and msys/mingw but have all types
of MS items in the path too (which would be difficult to clean out). But
I'm wondering if that's it.-----Original Message-----
From: Magnus Hagander [mailto:magnus@hagander.net]
Sent: Sunday, March 18, 2007 7:11 AM
To: Eric
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] cannot get build (initdb) to work after trying for a
weekEric wrote:
I am getting truly desperate! I am trying to build any version of
Postgres on Windows from source. First experience with Postgres
source. I have struggled for days trying to solve a problem. Would be
willing to pay for the solution!!!The following error occurred when issuing a vanilla initdb command on
my Windows system.FATAL: could not select a suitable default timezone
DETAIL: It appears that your GMT time zone uses leap seconds.
PostgreSQL does not support leap seconds.I built this from 8.1.8 source under msys/mingw. Also tried 8.2.2.
Everything builds fine but initdb always reports the above error and
quits.This could happen if the timezone files aren't properly installed. This
should normally happen when you do "make install", but verify that they
are actually present (in share/timezone).I also had to create a typedef int ssize_t in a couple of files to get
the compile finished. Maybe this is related. Other than that, have
not touched any code.I don't think that's related, but it's a clear indicator that something
in your environment is broken. Because it should build without any such
changes.//Magnus
Import Notes
Reply to msg id not found: 017601c76a4d$fe819640$6401a8c0@efishReference msg id not found: 017601c76a4d$fe819640$6401a8c0@efish | Resolved by subject fallback
To respond to Alvaro's post, I did try setting TZ=PST, no luck there.
As Magnus points out, the install doesn't appear complete because of
the missing timezone dir.
Eric wrote:
Thanks for responding Magnus.
I did reinstall both msys and mingw, as well as blow away the source
and start over from scratch. Maybe there is a stray file or directory
that's not getting deleted on the clean. Also, does clean just clean
up the compile environment, or does it also clean up the install? I
did manually remove directories too but I suppose I could have missed
something.
Clean cleans the build environment only,
Finally, as a newcomer to PG, I'm in search of general development
resources. Any good places to go besides the PG documentation and the
pgsql newsgroups?
http://archives.postgresql.org/pgsql-hackers
//Magnus