BDR PG9.4 Replica Identity Full

Hi BDR PostgreSQL experts, I am recently trying out the logical decoding with Replica Identity Full using postgresql-bdr94-server. However, i seems to run in to a bug reporting in this thread https://github.com/2ndQuadrant/bdr/issues/104. I tested stock version of PG 9.4 and it works just fine.

Re: Replication questions - read-only and temporary read/write slaves

On Fri, Jan 5, 2018 at 3:58 AM, Tiffany Thang wrote: > Thanks for your input. What I meant to say was rolling back all the changes. > I was hoping for a way to temporary open the read-only standby in r/w for > testing purpose and then rollback all the changes made during

Re: Bulk Insert/Update Scenario

Hi Mana, A starting point would be reading about the batch upsert functionality: https://www.postgresql.org/docs/current/static/sql-insert.html You would do something like: INSERT INTO table ON CONFLICT update... This operation would be atomic. You can also look into deferrable constraints such

Bulk Insert/Update Scenario

I am setting up the data processing pipeline and the end result gets stored in Postgres. Have not been a heavy DB user in general and had question regarding how best to handle bulk insert/updates scenario with Postgres. Here is my use case: * I get file with thousands of entries (lines)

Re: Production Database requirement

Salam Mohammed, Am DATE hackte Azimuddin Mohammed in die Tasten: > Hello All, > Can anyone please let me know > > 1. What is the hardware and software requirement for postgressql to be > installed in production. We are planning to use postgres for hadoop > backend, to store user access info,

Re: Replication questions - read-only and temporary read/write slaves

Michael, Thanks for your input. What I meant to say was rolling back all the changes. I was hoping for a way to temporary open the read-only standby in r/w for testing purpose and then rollback all the changes made during the test without having to re-create the standby from scratch. Thanks.

Re: Production Database requirement

2018-01-04 18:47 GMT+01:00 Azimuddin Mohammed : > Hello All, > Can anyone please let me know > > 1. What is the hardware and software requirement for postgressql to be > installed in production. We are planning to use postgres for hadoop backend, > to store user access info,

Re: Production Database requirement

2018-01-04 14:47 GMT-03:00 Azimuddin Mohammed : > Hello All, > Can anyone please let me know > > 1. What is the hardware and software requirement for postgressql to be > installed in production. We are planning to use postgres for hadoop > backend, to store user access info,

Re: Pg Upgrade failing as it is not able to start and stop server properly

On Thu, Jan 4, 2018 at 01:49:17PM +0530, kiran gadamsetty wrote: > While upgrading the PostgreSQL database from 9.1.4 to 9.6.4 version on > windows 2012 server, Pg_upgrade is failing as postgre service start and > stop are failing because of time outs. I got the information as using

Re: Pg Upgrade failing as it is not able to start and stop server properly

Hi All, Any help on this issue? Regards, Kiran G On Thu, Dec 21, 2017 at 3:03 PM, kiran gadamsetty < kirankumar.gadamse...@gmail.com> wrote: > Hi, > > While upgrading the PostgreSQL database from 9.1.4 to 9.6.4 version on > windows 2012 server, Pg_upgrade is failing as postgre service start