Re: [BUGS] BUG #7533: Client is not able to connect cascade standby incase basebackup is taken from hot standby

2012-09-25 Thread Amit Kapila
On Saturday, September 15, 2012 11:41 AM Fujii Masao wrote: > On Fri, Sep 14, 2012 at 12:21 PM, Amit Kapila > wrote: > > On Thursday, September 13, 2012 10:32 PM Fujii Masao wrote: > > On Thu, Sep 13, 2012 at 9:21 PM, Heikki Linnakangas > wrote: > >> On 12.09.2012 22:03, Fujii Masao wrote: > >>>

Re: [BUGS] BUG #6704: ALTER EXTENSION postgis SET SCHEMA leaves dangling relations

2012-09-25 Thread Dimitri Fontaine
Tom Lane writes: > I've been testing this patch with an extension having this definition > file: Side note: as soon as we have CREATE EXTENSION AS $$ script $$; we will be able to add those cases as regression tests. That's not the main usage of that feature, by far, but I can't resits the occasi

Re: [BUGS] BUG #7546: Backups on hot standby cancelled despite hot_standby_feedback=on

2012-09-25 Thread Stuart Bishop
Yesterday's dump failed with a new error. pg_stat_replication tells me replication has been connected for nearly a month, so no network issues. I've confirmed hot_standby_feedback is still set to 'on': ERROR: canceling statement due to conflict with recovery DETAIL: User query might have needed

Re: [BUGS] BUG #7533: Client is not able to connect cascade standby incase basebackup is taken from hot standby

2012-09-25 Thread Fujii Masao
On Tue, Sep 25, 2012 at 5:35 PM, Amit Kapila wrote: > If anybody doesn't have objection, then can we fix this in code. Basically > have the patch suggested by > Heikki with some modifications and Fujii's patch as fix of this defect and > if it's agreed upon, I can > combine both the fixes and prep

[BUGS] BUG #7567: Sequences not properly replicated

2012-09-25 Thread s . proels
The following bug has been logged on the website: Bug reference: 7567 Logged by: Stefan Pröls Email address: s.pro...@pharmatechnik.de PostgreSQL version: 9.1.3 Operating system: OpenSUSE 11.4 32-Bit Description: Scenario: 1 Master, 1 Hot-Standby Slave, asynchronous s

[BUGS] BUG #7566: Sequences not properly replicated

2012-09-25 Thread stefan . proels
The following bug has been logged on the website: Bug reference: 7566 Logged by: Stefan Pröls Email address: stefan.pro...@pharmatechnik.de PostgreSQL version: 9.1.3 Operating system: OpenSUSE 11.4 32-Bit Description: Scenario: 1 Master, 1 Hot-Standby Slave, asynchron

[BUGS] BUG #7565: not able to install

2012-09-25 Thread mcashokkumar
The following bug has been logged on the website: Bug reference: 7565 Logged by: ashokkumar Email address: mcashokku...@gmail.com PostgreSQL version: 9.0.3 Operating system: Windows server 2008 64bit Description: I tried to install postgres 64 bit 9.0.3 version in wi

Re: [BUGS] BUG #7567: Sequences not properly replicated

2012-09-25 Thread Tom Lane
s.pro...@pharmatechnik.de writes: > The following bug has been logged on the website: > Bug reference: 7567 > Logged by: Stefan Pröls > Email address: s.pro...@pharmatechnik.de > PostgreSQL version: 9.1.3 > Operating system: OpenSUSE 11.4 32-Bit > Description: > Scena

Re: [BUGS] BUG #6704: ALTER EXTENSION postgis SET SCHEMA leaves dangling relations

2012-09-25 Thread Dimitri Fontaine
Dimitri Fontaine writes: > Side note: as soon as we have CREATE EXTENSION AS $$ script $$; we will > be able to add those cases as regression tests. That's not the main > usage of that feature, by far, but I can't resits the occasion :) Oh, I did already mention it :) > I have some local failure

[BUGS] Postgres Partitions not working with hibernate 4.1.6.Final

2012-09-25 Thread Freddie Burgess
In hibernate 3.3.2.GA, We previously utilized this java program to address ingesting data into our PostgreSQL partitioned tables. package im.empl.core.service.ingest.postgres; import org.hibernate.Interceptor; import org.hibernate.jdbc.Batcher; import org.hibernate.jdbc.BatchingBatcherFactory; im

Re: [BUGS] Postgres Partitions not working with hibernate 4.1.6.Final

2012-09-25 Thread Jaime Casanova
On Tue, Sep 25, 2012 at 3:12 PM, Freddie Burgess wrote: > > Does anyone know why the previous .jdbc.batcher logic managed the postgres > partitioned inserts without any issues? > Are there any other alternative that will allow us to insert into a Postgres > partition table without making massive c

Re: [BUGS] Postgres Partitions not working with hibernate 4.1.6.Final

2012-09-25 Thread Freddie Burgess
Hi Jaime, We have our partitioning setup exactly like the instructions in ddl-partitioning.html and prior to the upgrade to Hibernate 4.1.6 ingest was working flawlessly as long as we set the hibernate.jdbc.factory_class=im.empl.core.service.ingest.postgres.PostgresPa rtitionBatcherFactory in Hibe