Re: error log, tablespace, wal files - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: error log, tablespace, wal files
Date
Msg-id CAOR=d=1v-wBMe41NBO5z9qMgKZw_XweMLE4WjaQO3b_qc683nQ@mail.gmail.com
Whole thread Raw
In response to Re: error log, tablespace, wal files  (Uwe Schroeder <uwe@oss4u.com>)
List pgsql-admin
On Thu, Nov 10, 2011 at 12:36 AM, Uwe Schroeder <uwe@oss4u.com> wrote:
>
>
>> Hello,
>>
>>      1) what is tablespace in postgres?
>>
>>      2) one more issue is that, I try to rename or delete some file in
>> /opt/PostgresPlus/9.0/data/base/16428/ directory.  when I restart postgres
>> server, it start normally.  but I thing this is wrong.  I rename or delete
>> file into above directory, that means my database(having 16428 oid) is
>> corrupted.  So How can my postgres server is started normally?? I want to
>> see the log file for that database corruption. Can I see it?? and where???
>> and please explain me that what's going on in above case??????

Any idea what was in that?  Have you tried truncating the table that
was behind it?  Assuming it was a table.

pgsql-admin by date:

Previous
From: Uwe Schroeder
Date:
Subject: Re: error log, tablespace, wal files
Next
From: Thorsten Strufe
Date:
Subject: lost tablespace