error log, tablespace, wal files

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux