cannot access directory /pg_tblspc/*

Поиск
Список
Период
Сортировка
От Charlie
Тема cannot access directory /pg_tblspc/*
Дата
Msg-id op.ta8572z9ak9zf1@lepa
обсуждение исходный текст
Ответы Re: cannot access directory /pg_tblspc/*  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: cannot access directory /pg_tblspc/*  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-novice
Hi everybody,
I've got a problem starting a database under fedora core 5.
I've created a database 'test' in a custom tablespace /bdd/data (/bdd is
root of a partition -ext3-). i.e.:
#df
/dev/hdb1             14877060   4913288   9195868  35% /
/dev/hdb2             31738420    212100  29888092   1% /bdd
/dev/hdb5             30407804    176288  28661968   1% /bdd_backup

The problem is when I want to access my database 'test' once the system is
up, it says it cannot access directory /pg_tblspc/<xxx> where <xxx> is a
number.
This file links to /bdd/data (drwx------  3 postgres postgres  4096 jun 16
19:17 data )

Other databases can be accessed without any problem, this only happens to
'test', which has a different tablespace.


This error can be solved by MANUALLY restarting the service 'postgresql'
('service postgresql restart').

I'd like to have it automatically launched at boot time, but I can't
figure why this error happens.

I'd really appreciate any help. Thank you.

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

Предыдущее
От: david@fetter.org (David Fetter)
Дата:
Сообщение: Re: Can PostgreSQL 8.x Return Multiple "Result Sets" ?
Следующее
От: raulpdlr@gmail.com
Дата:
Сообщение: FATAL: IDENT authentication failed for user "soAndso", quick fix