psql error

Поиск
Список
Период
Сортировка
Искать

psql error

От:
"Gtrica" <gtricarico@intin.it>
Дата:
I'm new with postgress datbase..

I have started correctly postmaster, I created a database "primo" ...
Now when I try to start "psql primo" I receive the following error
"psql : FATAL 1: cannot create init file
.//base/primo/pg_internal.init.1179"

Regards


Re: psql error

От:
Andrey Romanchenko <RomanchenkoAV@belhard.com>
Дата:
Gtrica wrote:

> I'm new with postgress datbase..
> 
> I have started correctly postmaster, I created a database "primo" ...
> Now when I try to start "psql primo" I receive the following error
> "psql : FATAL 1: cannot create init file
> .//base/primo/pg_internal.init.1179"
> 
> Regards

What permissions on base/primo?
seems that postmaster cannot create file in directory above.
-- 

Best regards!
  Andrey Romanchenko  (RomanchenkoAV@belhard.com)

Re: psql error

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
"Gtrica"  writes:
> I'm new with postgress datbase..
> I have started correctly postmaster, I created a database "primo" ...
> Now when I try to start "psql primo" I receive the following error
> "psql : FATAL 1: cannot create init file
> .//base/primo/pg_internal.init.1179"

It looks to me like you tried to start the postmaster with a relative
PGDATA path (something like "postmaster -D .").  Try an absolute
path instead.

(IIRC, PG 7.1 and later will accept a relative path, but earlier versions
don't cope.  If you are indeed running something older than 7.1, it's
definitely a good idea to update.)

			regards, tom lane
FAQ