[GENERAL] Need help on postgres related to insertion of a tuple.

2015-07-16 Thread M Tarkeshwar Rao
Hi all, We have a table name auditTrailLogEntry where we were not able to able to insert in auditTrailLogEntry table. we have reindex the table and insertion issue has been resolved . we executed following command: Audit tail insertion issue. INSERT INTO auditTrailLogEntry (event, inNodeID,

Re: [GENERAL] unexpected data beyond EOF in block 260 of relation pg_tblspc

2015-07-16 Thread Mitu Verma
Hi Adrian, Following info is available to us - Platfrom : Linux. uname : uname -a Linux BGWPOL22-07 2.6.32-358.el6.x86_64 #1 SMP Fri Feb 22 00:31:26 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux Postgres version - 9.1.4 Regards Mitu -Original Message- From: Adrian Klaver

Re: [GENERAL] Need help on postgres related to insertion of a tuple.

2015-07-16 Thread Michael Paquier
On Thu, Jul 16, 2015 at 5:18 PM, M Tarkeshwar Rao m.tarkeshwar@ericsson.com wrote: a. How can we prevent This has been seen to occur with buggy kernels; consider updating your system alarm ? b. how can resolve This has been seen to occur with buggy kernels; consider updating your system

Re: [GENERAL] utf8 encoding problem with plperlu

2015-07-16 Thread Ronald Peterson
Still trying to figure this out, still confused, but like most frustrating programming problems, I think I may be looking in the wrong place for the source of this error. Perhaps. On Wed, Jul 15, 2015 at 11:25 PM, Tom Lane t...@sss.pgh.pa.us wrote: Ronald Peterson r...@hub.yellowbank.com

Re: [GENERAL] Need help on postgres related to insertion of a tuple.

2015-07-16 Thread Adrian Klaver
On 07/16/2015 01:18 AM, M Tarkeshwar Rao wrote: Hi all, We have a table name auditTrailLogEntry where we were not able to able to insert in auditTrailLogEntry table. we have reindex the table and insertion issue has been resolved . we executed following command: *_Audit tail insertion

Re: [GENERAL] could not create shared memory segment: Invalid argument

2015-07-16 Thread Andy Colson
On Tue, Jul 14, 2015 at 8:59 AM, Andy Colson a...@squeakycode.net mailto:a...@squeakycode.net wrote: On 7/13/2015 7:08 PM, Ryan King - NOAA Affiliate wrote: Apologies ahead of time for not knowing which group to send to, but I wanted to see if anyone has encountered

Re: [GENERAL] How to test SSL cert from CA?

2015-07-16 Thread Francisco Reyes
On 07/11/2015 07:32 PM, James Cloos wrote: FR == Francisco Reyes li...@natserv.net writes: Did you include the intermediate cert(s) in the bundle which the server presents to the client? Yes. And did you confirm that the client trusts the issuer's root? Some require explicit configurastion

Re: [GENERAL] Removing and readding bdr nodes

2015-07-16 Thread Craig Ringer
On 17 May 2015 at 04:14, Mathew Moon mathew.m...@vipaar.com wrote: Hi, Wanted to bump this (Is that ok in this list?). Like I mentioned, I see now that the error I am seeing in the log possibly indicates that the node I am reinitializing is creating a slot that points to its own old sysid.