Re: Problem while using createdb for the first time

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

Browse pgsql-novice by date

  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