Re: [ADMIN] rebellious postgres process

2008-11-05 Thread Laszlo Nagy
The collector is pretty self-contained by design, so it's hard to see what else would affect it. I'm wondering a bit if the OP's hardware is still flaky :-(. In any case it would sure be interesting to see a few stack traces from the process. Maybe it is still flaky, because yesterday it re

Re: [ADMIN] Installation Error of postgresql-8.1.5 with perl.

2008-11-05 Thread praveen
Thanks a lot , Tom Lane. I installed below mentioned RPMs and now it is working - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "praveen" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; Sent: Wednesday, November 05, 2008 8:54 PM Subject: Re: [ADMIN] Installation Error of po

[ADMIN] time stamp and durations in postgres log file

2008-11-05 Thread Jessica Richard
in my Postgres log file, I see something like this: usename dbname, .., logtimestamp1... ... insert then the next line: username, dbname, ... logtimestamp2... duration: 0.2 ms My questions: 1. Is this 0.2 ms how much time the insert takes to finish? 2. does "logtimestamp2 - logtimestamp

Re: [ADMIN] Visualizer

2008-11-05 Thread Lennin Caro
--- On Wed, 11/5/08, Mohammad Ali Darvish Darab <[EMAIL PROTECTED]> wrote: > From: Mohammad Ali Darvish Darab <[EMAIL PROTECTED]> > Subject: [ADMIN] Visualizer > To: pgsql-admin@postgresql.org > Date: Wednesday, November 5, 2008, 9:55 AM > Hello everybody, > > I have got an already existing Po

Re: [ADMIN] Installation Error of postgresql-8.1.5 with perl.

2008-11-05 Thread Tom Lane
"praveen" <[EMAIL PROTECTED]> writes: > During configure I find the error in config.log file > checking for flags to link embedded Perl... Can't locate ExtUtils/Embed.pm > in @INC (@INC contains: /usr/lib/perl5/5.10.0/i386-linux-thread-multi Well, there's your problem ... FYI, our current Fedor

[ADMIN] Visualizer

2008-11-05 Thread Mohammad Ali Darvish Darab
Hello everybody, I have got an already existing Porstgres DB which is pretty large (including more than 650 table with considerable number of constraints etc). And now I am supposed to realize generally how it is constructed and works. I thought it would be good to have a grapahical visualization