From: | Serge Fonville <serge(dot)fonville(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Problem while using createdb for the first time |
Date: | 2009-06-30 09:36:00 |
Message-ID: | 680cbe0e0906300236x76a43310h71497697f5349509@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
> initdb: removing contents of data directory "e:/postgresql/data"
indicates your data directory isn't created.
based on the output this is caused by
> creating template1 database in e:/postgresql/data/base/1 ... 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.
If you resolve these first, the following steps should go more smoothly.
Probably it is a good idea to specify a user when running initdb, this
does not need to be a user that exists on the system, although things
do tend to become easier when it is. That will then become the
superuser.
Afterwards, it is advisable to add a host record to he pg_hba.conf
(which should be located in the data directory)
As an alternative you can set PGDATA environment variable to tell
postgres.exe where to find the data
That way you do not have to specify it to initdb, pg_ctl, postgres or
any other PostgreSQL executable
Also change the setting of listen_address under windows. After that,
you can change the configuration in pg_hba.conf to match a TCP/IP
setup
HTH
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Stark | 2009-06-30 09:58:51 | Re: Setting up spatial index |
Previous Message | Serge Fonville | 2009-06-30 09:04:12 | Fwd: Problem while using createdb for the first time |