Re: [GENERAL] conn = PQconnectdb(conninfo);

2015-07-17 Thread Tom Lane
Peter Kroon writes: > Every now and then my program will abort. > IAnd this is because: conn = PQconnectdb(conninfo); > The error given: > *** Error in `./server_prog': malloc(): smallbin double linked list > corrupted: 0x092c10a0 *** This looks like malloc() complaining because something has cor

[GENERAL] conn = PQconnectdb(conninfo);

2015-07-17 Thread Peter Kroon
Hi, Every now and then my program will abort. IAnd this is because: conn = PQconnectdb(conninfo); The error given: *** Error in `./server_prog': malloc(): smallbin double linked list corrupted: 0x092c10a0 *** Any thoughts on why I'm getting this message? Regards, Peter

Re: [GENERAL] Backup fatal issue

2015-07-17 Thread Tom Lane
mephysto writes: > I have some problems in a postgres cluster when I try to execute a backup. > ... > FATAL: semctl(983046, 3, SETVAL, 0) failed: Invalid argument > ... > LOG: could not remove shared memory segment "/PostgreSQL.1804289383": No > such file or directory > LOG: semctl(786432, 0, I

Re: [GENERAL] Backup fatal issue

2015-07-17 Thread Melvin Davidson
If this is occurring with Barman, try doing a manual backup. IE: pg_dump your_database > /tmp/somefile.sql If that works, then the problem is with Barman or it's configuration. On Fri, Jul 17, 2015 at 10:07 AM, Mephysto wrote: > Hi Melvin, > I am using Pstgres 9.4.4 in a virtualized Debian Linu

Re: [GENERAL] Backup fatal issue

2015-07-17 Thread Mephysto
Hi Melvin, I am using Pstgres 9.4.4 in a virtualized Debian Linux 8.0. I do not know backup command because is launched by BARMAN 1.4.1. I have tried many times to execute the backup. I have restarted and reinstalled Postgres and I also rebooted OS many times. Thanks for your help. Meph On 17 Ju

[GENERAL] Promoting 1 of 2 slaves

2015-07-17 Thread Joseph Kregloh
Hello, I am getting ready to take my master server out of service today and promote the slave to take it's place. In my current setup I have one master server which ships WAL files to two separate slave servers. My plan is to promote one of those slaves. How do I get the slave that I promoted to

Re: [GENERAL] Getting error "IST FATAL: the database system is in recovery mode"

2015-07-17 Thread Adrian Klaver
On 07/17/2015 05:47 AM, Sachin Srivastava wrote: Dear Team, I am getting the below error in my database pg_log file and also I am unable to open the database. "IST FATAL: the database system is in recovery mode" I am using postgresql version 9.1 on Centos 6.6. Kindly suggest why this proble

Re: [GENERAL] Getting error "IST FATAL: the database system is in recovery mode"

2015-07-17 Thread Michael Paquier
On Fri, Jul 17, 2015 at 9:47 PM, Sachin Srivastava wrote: > I am getting the below error in my database pg_log file and also I am unable > to open the database. > "IST FATAL: the database system is in recovery mode" > I am using postgresql version 9.1 on Centos 6.6. Kindly suggest why this > prob

Re: [GENERAL] Backup fatal issue

2015-07-17 Thread Melvin Davidson
I think we need just a little bit more information. What is the O/S? What is the PostgreSQL version? What is the backup command? Does this always occur with the same command? Did you need to restarrt PostgreSQL after this started? On Fri, Jul 17, 2015 at 3:29 AM, mephysto wrote: > Hi there, >

Re: [GENERAL] Is BDR support distributed table on slave nodes with ACID and join support.

2015-07-17 Thread Amit Bondwal
Thanks you very much Craig for clearing these facts and sorry for mail sent only to you by mistake. -- Thanks & Regards, Amit Bondwal On Fri, Jul 17, 2015 at 6:19 PM, Craig Ringer wrote: > On 17 July 2015 at 19:37, Amit Bondwal wrote: > > Thank you very much all of you for quick response an

Re: [GENERAL] Is BDR support distributed table on slave nodes with ACID and join support.

2015-07-17 Thread Craig Ringer
On 17 July 2015 at 19:37, Amit Bondwal wrote: > Thank you very much all of you for quick response and clearing my mind. Please reply to the mailing list, not just to me directly. > One more question, can I run a databse of postgres 9.4 on postgres-XL > cluster? postgres-XL is based on PostgreSQ

[GENERAL] Getting error "IST FATAL: the database system is in recovery mode"

2015-07-17 Thread Sachin Srivastava
Dear Team, I am getting the below error in my database pg_log file and also I am unable to open the database. "IST FATAL: the database system is in recovery mode" I am using postgresql version 9.1 on Centos 6.6. Kindly suggest why this problem is coming. Regards, Sachin

Re: [GENERAL] Is BDR support distributed table on slave nodes with ACID and join support.

2015-07-17 Thread Craig Ringer
On 17 July 2015 at 15:02, Amit Bondwal wrote: > I looked at pg_shard, as per my understanding it is for nosql data, in our > case we are going to use postgresql RDBMS features without nosql, pg_shard > have lot on limitation as per our case. You'll find that _most_ products have a lot of limitat

Re: [GENERAL] Is BDR support distributed table on slave nodes with ACID and join support.

2015-07-17 Thread Craig Ringer
On 17 July 2015 at 17:33, Dorian Hoxha wrote: > 1,2,3: You can't shard with BDR. It's only for multimaster (at least for > now). Please read the docs. You can kind-of shard using table partitioning, but the application has to deal with shard integration because there's no cross-node querying. So

Re: [GENERAL] Is BDR support distributed table on slave nodes with ACID and join support.

2015-07-17 Thread Dorian Hoxha
1,2,3: You can't shard with BDR. It's only for multimaster (at least for now). Please read the docs. On Fri, Jul 17, 2015 at 9:02 AM, Amit Bondwal wrote: > Hello everyone, > > We ae working on a application in which we are using posgresql as a > database. We are sure that in future it will exten

[GENERAL] Backup fatal issue

2015-07-17 Thread mephysto
Hi there, I have some problems in a postgres cluster when I try to execute a backup. This is the log of entire operation: LOG: connection received: host=91.121.182.110 port=54957 LOG: connection authorized: user=postgres database=postgres LOG: statement: BEGIN LOG: statement: SET application_n

[GENERAL] Is BDR support distributed table on slave nodes with ACID and join support.

2015-07-17 Thread Amit Bondwal
Hello everyone, We ae working on a application in which we are using posgresql as a database. We are sure that in future it will extend to level that we have to scale it horizontally. We have some tables which are going to be more than 90% of database size. I looked at pg_shard, as per my underst