Re: [ADMIN] PHP cann't access to postgres databse

2009-06-25 Thread donghe
Yes, I did configured these two files, so, PHP can talk with postgres, but Apache-owned PHP can not. > On Thu, Jun 25, 2009 at 6:54 PM, wrote: >> Hi gurus! >> >> my PHP scripts don't call upon the postgres database from within HTML >> files served to web browsers by Apache, but PHP scritps itself

Re: [ADMIN] PHP cann't access to postgres databse

2009-06-25 Thread Scott Marlowe
On Thu, Jun 25, 2009 at 6:54 PM, wrote: > Hi gurus! > > my PHP scripts don't call upon the postgres database from within HTML > files served to web browsers by Apache, but PHP scritps itself can access > to database. I guess some configuration between PHP and Apache is wrong. > Do anybody have any

[ADMIN] PHP cann't access to postgres databse

2009-06-25 Thread donghe
Hi gurus! my PHP scripts don't call upon the postgres database from within HTML files served to web browsers by Apache, but PHP scritps itself can access to database. I guess some configuration between PHP and Apache is wrong. Do anybody have any idea? Thanks! Dong He -- Sent via pgsql-admi

Re: [ADMIN] vacuum tx id wraparound issues

2009-06-25 Thread Kevin Kempter
On Thursday 25 June 2009 10:08:16 Greg Stark wrote: > On Thu, Jun 25, 2009 at 4:39 PM, Kevin > > Kempter wrote: > > we're inserting an average of 70-100 rows per second into these tables. > > Hm. And every row is a separate transaction? That's still only a few > hundred rows per second. About 25 mi

Re: [ADMIN] vacuum tx id wraparound issues

2009-06-25 Thread Greg Stark
On Thu, Jun 25, 2009 at 4:39 PM, Kevin Kempter wrote: > > we're inserting an average of 70-100 rows per second into these tables. Hm. And every row is a separate transaction? That's still only a few hundred rows per second. About 25 million per day. You should have about 4 days before it hits auto

[ADMIN] Fwd: vacuum tx id wraparound issues

2009-06-25 Thread Greg Stark
Sorry, meant to reply on-list. Unfortunately gmail has made it awkward to stay on-list despite many people complaining about the change. -- Forwarded message -- From: Greg Stark Date: Thu, Jun 25, 2009 at 4:28 PM Subject: Re: vacuum tx id wraparound issues To: Kevin Kempter On

[ADMIN] Optimal Flexible Architecture or Optimal Configuration Layout for Postgres

2009-06-25 Thread Mark Lehmann
I have been looking for a best practices layout for Postgres. The Centos and Debian distros configure the files for Postgres in different places. Neither of them seem to put the files in ideal locations for multiple instance administration on the same or different machines. Has someone already c

Re: [ADMIN] vacuum tx id wraparound issues

2009-06-25 Thread Kevin Kempter
On Thursday 25 June 2009 08:25:53 Tom Lane wrote: > Kevin Kempter writes: > > I'm seeing a number of vacuum's in one of our db's that has a notation > > (to prevent wraparound). > > This is a normal condition. There isn't anything you can do that will > make that stop permanently --- it's just ro

Re: [ADMIN] vacuum tx id wraparound issues

2009-06-25 Thread Tom Lane
Kevin Kempter writes: > I'm seeing a number of vacuum's in one of our db's that has a notation (to > prevent wraparound). This is a normal condition. There isn't anything you can do that will make that stop permanently --- it's just routine housekeeping. regards, tom la

[ADMIN] vacuum tx id wraparound issues

2009-06-25 Thread Kevin Kempter
Hi all; I'm seeing a number of vacuum's in one of our db's that has a notation (to prevent wraparound). I've tried a number of things to fix it. last nite during the off hours we ran a "vacuumdb -a" The vacuumdb did vacuum every db in the cluster but I'm still seeing the vacuums to prevent w

[ADMIN] himanshu purohit wants you to be a Green Idol.

2009-06-25 Thread Green Idol
Hey, I've just joined the Green Idol campaign and told Prime Minister Manmohan Singh that he has no time to lose. If he's serious about fighting climate change – as he should be – then he MUST have a Renewable Energy Law in place by 2010. That's next year! I know he's not going to do it just