cannot access directory /pg_tblspc/* - Mailing list pgsql-novice

From Charlie
Subject cannot access directory /pg_tblspc/*
Date
Msg-id op.ta8572z9ak9zf1@lepa
Whole thread Raw
Responses Re: cannot access directory /pg_tblspc/*
Re: cannot access directory /pg_tblspc/*
List 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 by date:

Previous
From: david@fetter.org (David Fetter)
Date:
Subject: Re: Can PostgreSQL 8.x Return Multiple "Result Sets" ?
Next
From: raulpdlr@gmail.com
Date:
Subject: FATAL: IDENT authentication failed for user "soAndso", quick fix