Re: error log, tablespace, wal files

On Thu, Nov 10, 2011 at 12:36 AM, Uwe Schroeder <uwe(at)oss4u(dot)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.