cannot access directory /pg_tblspc/*

From: Charlie <perezchar(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: cannot access directory /pg_tblspc/*
Date: 2006-06-16 19:10:44
Message-ID: op.ta8572z9ak9zf1@lepa
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bruce Momjian 2006-06-16 20:00:58 Re: libpq Describe Extension [WAS: Bytea and perl]
Previous Message Verena Ruff 2006-06-16 16:36:49 Re: Converting stored procedure from mySQL