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

From Karuna Karpe
Subject error log, tablespace, wal files
Date
Msg-id CAC-Lqbpzumfr4zW4+4eca90z5-kEmEaR_cJ0e-s7a=a_E=n0WA@mail.gmail.com
Whole thread Raw
Responses Re: error log, tablespace, wal files
Re: error log, tablespace, wal files
List pgsql-admin
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??????

     3) I want know about pg_xlog(wal) file creation. That means, size of wal files and how to create that files and time stamp between creation of two different wal files, that means when one file is created on 11:53AM, so how much time  after the second file is created?? can we set that time stamp???

Please any one explain me above points.

Regards,
Karuna karpe.

pgsql-admin by date:

Previous
From: "Ruslan A. Bondar"
Date:
Subject: Re: How to deal with corrupted database?
Next
From: Uwe Schroeder
Date:
Subject: Re: error log, tablespace, wal files