error log, tablespace, wal files

Поиск
Список
Период
Сортировка
От Karuna Karpe
Тема error log, tablespace, wal files
Дата
Msg-id CAC-Lqbpzumfr4zW4+4eca90z5-kEmEaR_cJ0e-s7a=a_E=n0WA@mail.gmail.com
обсуждение исходный текст
Ответы Re: error log, tablespace, wal files  (Uwe Schroeder <uwe@oss4u.com>)
Re: error log, tablespace, wal files  (Craig Ringer <ringerc@ringerc.id.au>)
Список 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 по дате отправления:

Предыдущее
От: "Ruslan A. Bondar"
Дата:
Сообщение: Re: How to deal with corrupted database?
Следующее
От: Uwe Schroeder
Дата:
Сообщение: Re: error log, tablespace, wal files