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

2008-11-04 Thread praveen
Hello , I am trying to install postgresql-8.1.5 and postgresql-8.2.5 in linux (Linux version 2.6.25-14.fc9.i686 (mockbuild@) (gcc version 4.3.0 20080428 (Red Hat 4.3.0-8) (GCC) ) #1 SMP Thu May 1 06:28:41 EDT 2008).but during compilation it is showing following error. make[3]: ***

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

2008-11-04 Thread praveen
Hello , I am trying to install postgresql-8.1.5 and postgresql-8.2.5 in linux (Linux version 2.6.25-14.fc9.i686 (mockbuild@) (gcc version 4.3.0 20080428 (Red Hat 4.3.0-8) (GCC) ) #1 SMP Thu May 1 06:28:41 EDT 2008).but during compilation it is showing following error. I configure with

Re: [ADMIN] rebellious postgres process

2008-11-04 Thread Laszlo Nagy
Tom Lane wrote: Huh, that's weird. We've fixed some bugs in the past that led the stats collector to consume excessive CPU --- but that was all pre-8.3. The server was rebooting intermittently, so we replaced the RAM (we got a kernel page fault). But it was a week ago. The server is now

Re: [ADMIN] rebellious postgres process

2008-11-04 Thread Tom Lane
Laszlo Nagy [EMAIL PROTECTED] writes: The process is still running: Could you attach to it with gdb and see what it's doing? Do you have a whole lot of tables in this database? One database has 140 tables, the other has 62. (There are two other database instances but they are rarely

[ADMIN] epqa; postgres performance optimizer support tool; opensource.

2008-11-04 Thread sathiya psql
Dear All, Recently i have released the next version of the epqa. which is a very useful tool for, gives input for optimizing psql queries, and fine tuning it. epqa is tool similar like, pqa. But designed and implemented to parse log files which is in GB's. Report is similar like that. More

Re: [ADMIN] rebellious postgres process

2008-11-04 Thread Scott Marlowe
On Tue, Nov 4, 2008 at 8:48 AM, Laszlo Nagy [EMAIL PROTECTED] wrote: Tom Lane wrote: Huh, that's weird. We've fixed some bugs in the past that led the stats collector to consume excessive CPU --- but that was all pre-8.3. The server was rebooting intermittently, so we replaced the RAM (we

Re: [ADMIN] rebellious postgres process

2008-11-04 Thread Laszlo Nagy
Tom Lane wrote: Laszlo Nagy [EMAIL PROTECTED] writes: The processi is using 100% CPU for 52 hours! Here it is: %ps axl | grep 677 70 677 666 757 107 0 22396 5460 select Rs?? 3144:50.88 postgres: stats collector process(postgres) Huh, that's weird. We've

Re: [ADMIN] rebellious postgres process

2008-11-04 Thread Scott Marlowe
On Tue, Nov 4, 2008 at 11:46 AM, Tom Lane [EMAIL PROTECTED] wrote: Scott Marlowe [EMAIL PROTECTED] writes: On Tue, Nov 4, 2008 at 8:48 AM, Laszlo Nagy [EMAIL PROTECTED] wrote: The server was rebooting intermittently, so we replaced the RAM (we got a kernel page fault). But it was a week ago.

Re: [ADMIN] rebellious postgres process

2008-11-04 Thread Tom Lane
Scott Marlowe [EMAIL PROTECTED] writes: On Tue, Nov 4, 2008 at 11:46 AM, Tom Lane [EMAIL PROTECTED] wrote: Still, it's quite unclear how bad data read from the stats file could have led to an infinite loop. The stats file format is pretty flat and AFAICS the worst effect of undetected

Re: [ADMIN] how i can restrict databaseusers ?

2008-11-04 Thread Joshua D. Drake
On Tue, 2008-05-20 at 17:57 +0400, pronix pronix wrote: hello how i can restrict dbusers ( user's db size, cpu time)? You can't within PostgreSQL. Joshua D. Drake -- -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription:

Re: [ADMIN] rebellious postgres process

2008-11-04 Thread Tom Lane
Scott Marlowe [EMAIL PROTECTED] writes: On Tue, Nov 4, 2008 at 8:48 AM, Laszlo Nagy [EMAIL PROTECTED] wrote: The server was rebooting intermittently, so we replaced the RAM (we got a kernel page fault). But it was a week ago. The server is now stable. But is it possible that somehow the file

Re: [ADMIN] [GENERAL] epqa; postgres performance optimizer support tool; opensource.

2008-11-04 Thread Sathish Duraiswamy
Sure , i 'll try with our database log Regards sathish On Tue, Nov 4, 2008 at 5:55 PM, sathiya psql [EMAIL PROTECTED] wrote: Dear All, Recently i have released the next version of the epqa. which is a very useful tool for, gives input for optimizing psql queries, and fine tuning it.

Re: [ADMIN] rebellious postgres process

2008-11-04 Thread Tom Lane
Laszlo Nagy [EMAIL PROTECTED] writes: The processi is using 100% CPU for 52 hours! Here it is: %ps axl | grep 677 70 677 666 757 107 0 22396 5460 select Rs?? 3144:50.88 postgres: stats collector process(postgres) Huh, that's weird. We've fixed some bugs in the past that

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

2008-11-04 Thread praveen
Hello Tom, 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 /usr/lib/perl5/5.10.0 /usr/lib/perl5/site_perl/5.10.0/i386-linux-thread-multi