Re: beta3 winxp initdb problems - Mailing list pgsql-general

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: bartkoedith@internetkosice.sk
> [mailto:bartkoedith@internetkosice.sk]
> Sent: Thursday, October 14, 2004 9:34 AM
> To: pgsql-general@postgresql.org
> 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
>