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

On Thu, Nov 27, 2014 at 6:50 AM, Patrick Krecker patr...@judicata.com 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

[GENERAL] PostgreSQL and Ideara R1Soft - Backup

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(),

[GENERAL] High Availability Cluster

-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

Re: [GENERAL] High Availability Cluster

Maila Fatticcioni mfatticci...@mbigroup.it 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

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

On Thu, 27 Nov 2014 15:07:49 +1100 Sanjaya Vithanagama svithanag...@gmail.com wrote: On Wed, Nov 26, 2014 at 11:47 AM, Bill Moran wmo...@potentialtech.com wrote: On Wed, 26 Nov 2014 10:41:56 +1100 Sanjaya Vithanagama svithanag...@gmail.com wrote: * How frequently do deadlocks

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

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:

[GENERAL] Converting xml to table with optional elements

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

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

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 table is

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

On Thu, 2014-11-27 at 06:49 -0500, Bill Moran wrote: On Thu, 27 Nov 2014 15:07:49 +1100 Sanjaya Vithanagama svithanag...@gmail.com wrote: On Wed, Nov 26, 2014 at 11:47 AM, Bill Moran wmo...@potentialtech.com wrote: On Wed, 26 Nov 2014 10:41:56 +1100 Sanjaya Vithanagama

Re: [GENERAL] High Availability Cluster

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/27/2014 12:34 PM, Andreas Kretschmer wrote: Maila Fatticcioni mfatticci...@mbigroup.it 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

[GENERAL] Compatibility module for Oracles dbms_sql

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

Re: [GENERAL] Compatibility module for Oracles dbms_sql

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