Speaking off-list with Zoltan, it appears this problem was *also* related to nod32 antivirus. Just a different error message than we've seen before. Seems nod32 is significantly worse than any other AV products for postgresql...
//Magnus > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 14, 2004 9:34 AM > To: [EMAIL PROTECTED] > Cc: Magnus Hagander > Subject: Re: [GENERAL] beta3 winxp initdb problems > > Magnus, et al., > > This is, what initdb -d says: > > <listing> > > D:\tmp\data>initdb -d > Running in debug mode. > VERSION=8.0.0beta3 > PGDATA=d:/tmp/data > share_path=c:/msys/1.0/share/postgresql > PGPATH=c:/msys/1.0/bin > POSTGRES_SUPERUSERNAME=postgresql > POSTGRES_BKI=c:/msys/1.0/share/postgresql/postgres.bki > POSTGRES_DESCR=c:/msys/1.0/share/postgresql/postgres.description > POSTGRESQL_CONF_SAMPLE=c:/msys/1.0/share/postgresql/postgresql > .conf.sample > PG_HBA_SAMPLE=c:/msys/1.0/share/postgresql/pg_hba.conf.sample > PG_IDENT_SAMPLE=c:/msys/1.0/share/postgresql/pg_ident.conf.sample > The files belonging to this database system will be owned by > user "postgresql". > This user must also own the server process. > > The database cluster will be initialized with locale > Slovak_Slovakia.1250. > > fixing permissions on existing directory d:/tmp/data ... ok > creating directory d:/tmp/data/global ... ok creating > directory d:/tmp/data/pg_xlog ... ok creating directory > d:/tmp/data/pg_xlog/archive_status ... ok creating directory > d:/tmp/data/pg_clog ... ok creating directory > d:/tmp/data/pg_subtrans ... ok creating directory > d:/tmp/data/base ... ok creating directory d:/tmp/data/base/1 > ... ok creating directory d:/tmp/data/pg_tblspc ... ok > selecting default max_connections ... 10 selecting default > shared_buffers ... 50 creating configuration files ... ok > creating template1 database in d:/tmp/data/base/1 ... DEBUG: > TZ "Europe/Belgrad e" matches Windows timezone "Central > Europe Daylight Time" > FATAL: could not select a suitable default timezone > DETAIL: It appears that your GMT time zone uses leap > seconds. PostgreSQL does n ot support leap seconds. > DEBUG: proc_exit(1) > DEBUG: shmem_exit(1) > DEBUG: exit(1) > child process was terminated by signal 1 > initdb: failed > initdb: removing contents of data directory "d:/tmp/data" > > D:\tmp\data> > </listing> > > So I said to myself, set the timezone to GMT. This, what I > got after switching off the automatic daylight saving time > notification: > > <listing> > D:\tmp\data>initdb -d > Running in debug mode. > VERSION=8.0.0beta3 > PGDATA=d:/tmp/data > share_path=c:/msys/1.0/share/postgresql > PGPATH=c:/msys/1.0/bin > POSTGRES_SUPERUSERNAME=postgresql > POSTGRES_BKI=c:/msys/1.0/share/postgresql/postgres.bki > POSTGRES_DESCR=c:/msys/1.0/share/postgresql/postgres.description > POSTGRESQL_CONF_SAMPLE=c:/msys/1.0/share/postgresql/postgresql > .conf.sample > PG_HBA_SAMPLE=c:/msys/1.0/share/postgresql/pg_hba.conf.sample > PG_IDENT_SAMPLE=c:/msys/1.0/share/postgresql/pg_ident.conf.sample > The files belonging to this database system will be owned by > user "postgresql". > This user must also own the server process. > > The database cluster will be initialized with locale > Slovak_Slovakia.1250. > > fixing permissions on existing directory d:/tmp/data ... ok > creating directory d:/tmp/data/global ... ok creating > directory d:/tmp/data/pg_xlog ... ok creating directory > d:/tmp/data/pg_xlog/archive_status ... ok creating directory > d:/tmp/data/pg_clog ... ok creating directory > d:/tmp/data/pg_subtrans ... ok creating directory > d:/tmp/data/base ... ok creating directory d:/tmp/data/base/1 > ... ok creating directory d:/tmp/data/pg_tblspc ... ok > selecting default max_connections ... 10 selecting default > shared_buffers ... 50 creating configuration files ... ok > creating template1 database in d:/tmp/data/base/1 ... DEBUG: > TZ "Europe/Dublin" > matches Windows timezone "GMT Standard Time" > FATAL: could not select a suitable default timezone > DETAIL: It appears that your GMT time zone uses leap > seconds. PostgreSQL does n ot support leap seconds. > DEBUG: proc_exit(1) > DEBUG: shmem_exit(1) > DEBUG: exit(1) > child process was terminated by signal 1 > initdb: failed > initdb: removing contents of data directory "d:/tmp/data" > > D:\tmp\data> > </listing> > > Any ideas? > > Zoltan > > > > > > Hello! > > > > Could you please run this with debugging enabled? You do this by > > passing "-d" to initdb. > > The interesting output is the stuff that comes between the "creating > > template1 database" message and the FATAL error. > > > > Did you restart the commandprompt you ran initdb in after > changing the > > timezone? > > > > //Magnus > > > > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
