Re: Creating a database

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Creating a database
Дата
Msg-id 15853.979522059@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Creating a database  (Richard Francis Duggan <dugganr@student.cs.ucc.ie>)
Список pgsql-general
Richard Francis Duggan <dugganr@student.cs.ucc.ie> writes:
> I am trying to create a database and use the following command:
> 'createdb <database-name>'
> However I get the following error:
> ERROR:  CREATE DATABASE: could not initialize database directory
> createdb: database creation failed

Hm.  That's not an especially easy error to get ... to get that far,
you must have a running postmaster and a working template1 database.
Furthermore you don't have a permissions problem, because it already
was able to create the new subdirectory for the new database.  What's
failing is the 'cp' command to copy files into that subdirectory from
template1.  Most odd.

What platform are you on?  What's the name of the intended new database?
Also, just reaching at straws, what's the PGDATA setting you are using
(full pathname)?

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: The Hermit Hacker
Дата:
Сообщение: Re: Does PostgreSQL support Dynamic SQL?
Следующее
От: "Brett W. McCoy"
Дата:
Сообщение: Re: Can't compare decimal columns???