Re: Problem while using createdb for the first time

Поиск
Список
Период
Сортировка
От Serge Fonville
Тема Re: Problem while using createdb for the first time
Дата
Msg-id 680cbe0e0906300236x76a43310h71497697f5349509@mail.gmail.com
обсуждение исходный текст
Ответ на Problem while using createdb for the first time  (Ms swati chande <swativc@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: Serge Fonville
Дата:
Сообщение: Fwd: Problem while using createdb for the first time
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Setting up spatial index