Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Greg StarkDate: 2009-06-30 09:58:51
Subject: Re: Setting up spatial index
Previous:From: Serge FonvilleDate: 2009-06-30 09:04:12
Subject: Fwd: Problem while using createdb for the first time

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group