On Tue, 2009-01-20 at 14:21 -0500, Bhella Paramjeet-PFCW67 wrote:
> First we saw this problem on our postgres 8.2.7 database where we had
> the "stats_block_level" parameter turned on in postgresql.conf file.
> After I turned off stats_block_level parameter, our backups did not
> fail.
Seems lik
Forgot to mention one thing. Even though in the online backup script $?
did not return zero and I got the error "data dir copy failed" but the
PGDATA directory did get copied fine. The size of the PGDATA directory
and the copied PGDATA dir were same.
Here is the snippet of our online backup scrip
On Tue, 2009-01-20 at 14:21 -0500, Bhella Paramjeet-PFCW67 wrote:
> Hi,
>
> We are running into a problem where our online backups are failing
> randomly. We are using postgres 8.2.7 and we are seeing this problem in
> both Solaris and Linux platforms. Our online backup script copies the
> PGDATA
Hi,
We are running into a problem where our online backups are failing
randomly. We are using postgres 8.2.7 and we are seeing this problem in
both Solaris and Linux platforms. Our online backup script copies the
PGDATA dir with the command "cp -r -P".
First we saw this problem on our postgres 8
Cool, I have actually been trying out Zabbiz 1.6.x now since I like it
better than munin.
Thanks,
Marcelo
PostgreSQL DBA
Linux/Solaris System Administrator
On Jan 19, 2009, at 9:56 AM, Jaume Sabater wrote:
On Mon, Jan 19, 2009 at 4:38 PM, Marcelo Martins > wrote:
Do you guys have any sugge
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Johann Spies a écrit :
> On Mon, Jan 19, 2009 at 05:10:07PM +0100, Cédric Villemain wrote:
>> Note that you have some plugins :
>>
>> * http://bucardo.org/check_postgres/ (plugin for nagios and others)
>> * http://muninpgplugins.projects.postgresql.o
RRD tool can used for drawing graphs by fetching the statics from DB
servers and plotting graphs store it an image file and embedded it on the
HTML page to look it nice .
2009/1/20 Johann Spies
> On Mon, Jan 19, 2009 at 05:10:07PM +0100, Cédric Villemain wrote:
> > Note that you have some plug
On Mon, Jan 19, 2009 at 05:10:07PM +0100, Cédric Villemain wrote:
> Note that you have some plugins :
>
> * http://bucardo.org/check_postgres/ (plugin for nagios and others)
> * http://muninpgplugins.projects.postgresql.org/ (for munin)
>
Thanks for these links. I am trying out the muninpgplu
