Re: [BUGS] BUG #6706: pg_upgrade fails when plpgsql dropped/re-created

2012-07-06 Thread Maciek Sakrejda
>> Well, the part I understood was that your fix apparently does not >> guarantee to restore plpgsql to the state it was in, just to restore >> it to existence. But previous complaints about similar issues have >> fallen on deaf ears (see bug #5184). Perhaps Tom has had a change of >> heart, but

Re: [BUGS] BUG #6706: pg_upgrade fails when plpgsql dropped/re-created

2012-07-06 Thread Bruce Momjian
On Fri, Jul 06, 2012 at 07:32:10PM -0400, Robert Haas wrote: > On Thu, Jul 5, 2012 at 9:32 AM, Bruce Momjian wrote: > > On Thu, Jul 05, 2012 at 12:21:58AM -0400, Tom Lane wrote: > >> Bruce Momjian writes: > >> >>> address the points I made about reproducing the previous state in cases > >> >>> wh

Re: [BUGS] BUG #6706: pg_upgrade fails when plpgsql dropped/re-created

2012-07-06 Thread Robert Haas
On Thu, Jul 5, 2012 at 9:32 AM, Bruce Momjian wrote: > On Thu, Jul 05, 2012 at 12:21:58AM -0400, Tom Lane wrote: >> Bruce Momjian writes: >> >>> address the points I made about reproducing the previous state in cases >> >>> where the admin removed the language or changed its permissions. >> >> >>

Re: [BUGS] Problem with pg_upgrade

2012-07-06 Thread Payal Singh
Okay. I guess so. Thanks for your help. Regards, Payal On Fri, Jul 6, 2012 at 4:24 PM, Bruce Momjian wrote: > On Fri, Jul 06, 2012 at 04:21:06PM -0400, Payal Singh wrote: > > If something was wrong with the cluster, why did vacuumdb on new server > run > > successfully when I followed Craig's s

Re: [BUGS] Problem with pg_upgrade

2012-07-06 Thread Bruce Momjian
On Fri, Jul 06, 2012 at 04:21:06PM -0400, Payal Singh wrote: > If something was wrong with the cluster, why did vacuumdb on new server run > successfully when I followed Craig's suggestion of running vacuumdb on old > server first, before performing the upgrade, and then ran vacuumdb on new one? M

Re: [BUGS] Problem with pg_upgrade

2012-07-06 Thread Payal Singh
If something was wrong with the cluster, why did vacuumdb on new server run successfully when I followed Craig's suggestion of running vacuumdb on old server first, before performing the upgrade, and then ran vacuumdb on new one? On Fri, Jul 6, 2012 at 4:05 PM, Bruce Momjian wrote: > On Fri, Jul

Re: [BUGS] Problem with pg_upgrade

2012-07-06 Thread Bruce Momjian
On Fri, Jul 06, 2012 at 04:03:38PM -0400, Payal Singh wrote: > The omnipitr-backup-slave process takes online backups from the standby, and > this is done everyday. This process connects to the master and calls a > pg_start_backup and then looks for a restore point on the standby after that > WAL a

Re: [BUGS] Problem with pg_upgrade

2012-07-06 Thread Payal Singh
The omnipitr-backup-slave process takes online backups from the standby, and this is done everyday. This process connects to the master and calls a pg_start_backup and then looks for a restore point on the standby after that WAL address. So i don't think I need to shut down the server. Also, it is

Re: [BUGS] Problem with pg_upgrade

2012-07-06 Thread Bruce Momjian
On Fri, Jul 06, 2012 at 02:22:28PM -0400, Payal Singh wrote: > The first message in the log is probably because the backup is taken from a > standby. I am using omnipitr-backup-slave to make the backups and then > restoring one of those. OK, this is what I wanted to see. Is the server running whi

Re: [BUGS] Problem with pg_upgrade

2012-07-06 Thread Bruce Momjian
On Fri, Jul 06, 2012 at 01:20:21PM -0400, Payal Singh wrote: > Hi, > > I restored the backup on 9.1, made sure the database reached a consistent > state > and checkpointed. Then I performed the upgrade. Upgrade completed successfully > but on running vacuumdb it gave the exact same error. The con

Re: [BUGS] BUG #6716: memory of Autovacuum leak?

2012-07-06 Thread Alvaro Herrera
Excerpts from runner.mei's message of miƩ jul 04 10:03:42 -0400 2012: > The following bug has been logged on the website: > > Bug reference: 6716 > Logged by: runner.mei > Email address: runner@gmail.com > PostgreSQL version: 9.1.3 > Operating system: win2003 > Descriptio

Re: [BUGS] BUG #6721: installation of PostgreSQL prevented WebServer Start

2012-07-06 Thread Dave Page
On Fri, Jul 6, 2012 at 11:14 AM, Peter Arnold wrote: > Hi Dave, > > my distribution comes from > > http://www.enterprisedb.com/products-services-training/pgdownload#osx. > > meanwhile we installed Postgres 8.4.12 > and changed the link from /usr/lib/libpq.5.dylib to /usr/lib/libpq.5.3.dylib > an

Re: [BUGS] BUG #6721: installation of PostgreSQL prevented WebServer Start

2012-07-06 Thread Peter Arnold
Hi Dave, my distribution comes from http://www.enterprisedb.com/products-services-training/pgdownload#osx. meanwhile we installed Postgres 8.4.12 and changed the link from /usr/lib/libpq.5.dylib to /usr/lib/libpq.5.3.dylib and both, postgeSQL and Webserver are working. Is it a good Idea to

Re: [BUGS] BUG #6721: installation of PostgreSQL prevented WebServer Start

2012-07-06 Thread Dave Page
On Fri, Jul 6, 2012 at 9:38 AM, Dave Page wrote: > On Fri, Jul 6, 2012 at 9:29 AM, wrote: >> The following bug has been logged on the website: >> >> Bug reference: 6721 >> Logged by: Peter Arnold >> Email address: peter.arn...@jd-ag.com >> PostgreSQL version: 9.0.8 >> Operatin

Re: [BUGS] BUG #6721: installation of PostgreSQL prevented WebServer Start

2012-07-06 Thread Dave Page
On Fri, Jul 6, 2012 at 9:29 AM, wrote: > The following bug has been logged on the website: > > Bug reference: 6721 > Logged by: Peter Arnold > Email address: peter.arn...@jd-ag.com > PostgreSQL version: 9.0.8 > Operating system: MAC OSX > Description: > > Hi, > > after i inst

[BUGS] BUG #6721: installation of PostgreSQL prevented WebServer Start

2012-07-06 Thread peter . arnold
The following bug has been logged on the website: Bug reference: 6721 Logged by: Peter Arnold Email address: peter.arn...@jd-ag.com PostgreSQL version: 9.0.8 Operating system: MAC OSX Description: Hi, after i install PostgreSQL 9.0.8 on my MAC with OSX 10.7.4 the WEB

Re: [BUGS] BUG #6720: Its often disconnecting

2012-07-06 Thread Guillaume Lelarge
On Fri, 2012-07-06 at 08:12 +0800, Craig Ringer wrote: > On 07/06/2012 03:57 AM, balaj...@gmail.com wrote: > > The following bug has been logged on the website: > > > > Bug reference: 6720 > > Logged by: balaji > > Email address: balaj...@gmail.com > > PostgreSQL version: Unsuppo