Re: [ADMIN] Wal archives building up in slave pg_xlog dir

2011-03-28 Thread Kevin Grittner
[rearranged; please don't top-post] Simon Luijk wrote: > On Wednesday, 23 March 2011 at 22:16, Simon Luijk wrote: >> I have a master slave setup that is on the most part working >> smoothly. The logs are getting shipped to the slave, the slave is >> requesting them and then applying them. >> >>

Re: [ADMIN] Fwd: PITR Recovery settings

2011-03-28 Thread Kevin Grittner
Selva manickaraja wrote: > We have successfully implemented a Backup and Recovery process in > our organization and currently testing it out. We took a previous > day backup and tried to restore it to a point in time. > > The database is able to start applying the recovery settings. But > it r

Re: [ADMIN] Triggers on system catalog

2011-03-28 Thread Guillaume Lelarge
Le 28/03/2011 15:44, Shridhar Polas a écrit : > [...] > Is there a way to create triggers on system catalog tables like > pg_class, pg_attribute etc...? > No. -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make c

[ADMIN] Triggers on system catalog

2011-03-28 Thread Shridhar Polas
Hi, Is there a way to create triggers on system catalog tables like pg_class, pg_attribute etc...? Thanks, Shridhar

[ADMIN] sepgsql installation troubles in Postgresql 9.1 alpha4

2011-03-28 Thread H S
Dear Sirs, I have just read your manual about implementing module sepgsql on Postgresql. But I do not have any idea that where and how I sould insert the below commands, that you've mentioned in manual. >In terminal? > When I type initdb, normally it requires at least an option to be foll