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.