Re: [GENERAL] Compatibility module for Oracles dbms_sql

2014-11-27 Thread Adrian Klaver
On 11/27/2014 12:21 PM, Diego Miranda wrote: Hi everyone! I'm in need of assistance. Currently I'm working in a project that was started with an Oracle database, but later migrated to Postgres. It has various procedures that make use of the dbms_sql package. Is there any compatibiliity module in

[GENERAL] Compatibility module for Oracles dbms_sql

2014-11-27 Thread Diego Miranda
Hi everyone! I'm in need of assistance. Currently I'm working in a project that was started with an Oracle database, but later migrated to Postgres. It has various procedures that make use of the dbms_sql package. Is there any compatibiliity module in Postgres for this Oracle package? Thanks in ad

Re: [GENERAL] High Availability Cluster

2014-11-27 Thread Maila Fatticcioni
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/27/2014 12:34 PM, Andreas Kretschmer wrote: > Maila Fatticcioni wrote: > >> -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 >> >> Hello. I need to set up a high availability cluster with two >> servers. I have looked for the best configuration I

Re: [GENERAL] Avoiding deadlocks when performing bulk update and delete operations

2014-11-27 Thread rob stone
On Thu, 2014-11-27 at 06:49 -0500, Bill Moran wrote: > On Thu, 27 Nov 2014 15:07:49 +1100 > Sanjaya Vithanagama wrote: > > > On Wed, Nov 26, 2014 at 11:47 AM, Bill Moran > > wrote: > > > > > On Wed, 26 Nov 2014 10:41:56 +1100 > > > Sanjaya Vithanagama wrote: > > > > > > > > > * How frequent

Re: [GENERAL] Converting xml to table with optional elements

2014-11-27 Thread David G Johnston
Andrus Moor wrote > How to convert xml to table if some elements are optional in xml ? > > In XML > > /E-Document/Document/DocumentParties/BuyerParty/ContactData/ContactFirstName > element is optional. > > If this is present, code below works OK. > If ContactFirstName is not present , empty tabl

[GENERAL] Converting xml to table with optional elements

2014-11-27 Thread Andrus
How to convert xml to table if some elements are optional in xml ? In XML /E-Document/Document/DocumentParties/BuyerParty/ContactData/ContactFirstName element is optional. If this is present, code below works OK. If ContactFirstName is not present , empty table is returned. How to extract prod

Re: [GENERAL] How to avoid a GIN recheck condition

2014-11-27 Thread Alexis
Thanks for your detailed answer ! I miss understood the query plan. Indeed the slowing down comes from my order clause, which I didn't include in my previous email. Still loving PostgreSQL from the first day <3 -- View this message in context: http://postgresql.nabble.com/How-to-avoid-a-GIN-r

Re: [GENERAL] Avoiding deadlocks when performing bulk update and delete operations

2014-11-27 Thread Bill Moran
On Thu, 27 Nov 2014 15:07:49 +1100 Sanjaya Vithanagama wrote: > On Wed, Nov 26, 2014 at 11:47 AM, Bill Moran > wrote: > > > On Wed, 26 Nov 2014 10:41:56 +1100 > > Sanjaya Vithanagama wrote: > > > > > > > * How frequently do deadlocks occur? > > > > > > We are seeing deadlocks about 2-3 times p

Re: [GENERAL] High Availability Cluster

2014-11-27 Thread Andreas Kretschmer
Maila Fatticcioni wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hello. > I need to set up a high availability cluster with two servers. I have > looked for the best configuration I could use but I cannot find > anything I like. I cannot used the DRBD option and I have to use > >

[GENERAL] High Availability Cluster

2014-11-27 Thread Maila Fatticcioni
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello. I need to set up a high availability cluster with two servers. I have looked for the best configuration I could use but I cannot find anything I like. I cannot used the DRBD option and I have to use Ubuntu 14.04 as OS. In the past I have set up

[GENERAL] PostgreSQL and Ideara R1Soft - Backup

2014-11-27 Thread Andreas Kretschmer
Hello @all, has someone experience with idera R1Soft and PostgreSQL? How can i use it? I know, there are a Idera-Modul for MySQL to make consistent backups, but i can't found similar for PostgreSQL. Is it possible to make a pg_start_backup(), then create a snapshot and, after pg_stop_backup(), mo

Re: [GENERAL] is there a warm standby sync trigger?

2014-11-27 Thread Sameer Kumar
On Thu, Nov 27, 2014 at 6:50 AM, Patrick Krecker wrote: > I have never heard of pg_pause_recovery() or pg_resume_recovery(). > However, you can use pg_xlog_replay_pause() and > pg_xlog_replay_resume() to pause and resume recovery. As Sameer > mentioned, they require the system to be in hot standb