Re: [GENERAL] configure PostgreSQL with PERL: Perl version 5.8 or later is required, but this is .

On 10/24/2016 01:49 PM, John R Pierce wrote: On 10/24/2016 1:19 PM, Andre Mikulec wrote: May strait answer is true. 1. I need to change the width of all of my tables because I have very wide data. There is a compile-time parameter for that. 2. I need to debug, compile and install a

Re: [GENERAL] configure PostgreSQL with PERL: Perl version 5.8 or later is required, but this is .

On 10/24/2016 01:19 PM, Andre Mikulec wrote: May strait answer is true. 1. I need to change the width of all of my tables because I have very wide data. There is a compile-time parameter for that. Beyond my knowledge, but I understand the custom compile now. 2. I need to debug, compile

Re: [GENERAL] configure PostgreSQL with PERL: Perl version 5.8 or later is required, but this is .

On 10/24/2016 1:19 PM, Andre Mikulec wrote: May strait answer is true. 1. I need to change the width of all of my tables because I have very wide data. There is a compile-time parameter for that. 2. I need to debug, compile and install a modified version of the PostgreSQL extension pl/r.

Re: [GENERAL] configure PostgreSQL with PERL: Perl version 5.8 or later is required, but this is .

May strait answer is true. 1. I need to change the width of all of my tables because I have very wide data. There is a compile-time parameter for that. 2. I need to debug, compile and install a modified version of the PostgreSQL extension pl/r. Andre Mikulec andre_miku...@hotmail.com

Re: [GENERAL] configure PostgreSQL with PERL: Perl version 5.8 or later is required, but this is .

On 10/24/2016 11:01 AM, Andre Mikulec wrote: Never mind. I figured it out. Soon I will write up a summary. What I am not understanding is why you are building from source and not using the pre-built packages that: BigSQL: https://www.bigsql.org/postgresql/installers.jsp or EDB:

Re: [GENERAL] Errors while installing PostGIS by an unusual method

Thanks for replying Tom and Asif, I think the issue was that libpq.so present in the /pgsql/lib directory did not have all its dependencies installed on the system namely openssl hence I execute the command sudo yum install openssl and that proceeded the configure script forward, but now I ran

Re: [GENERAL] configure PostgreSQL with PERL: Perl version 5.8 or later is required, but this is .

Never mind. I figured it out. Soon I will write up a summary. Andre Mikulec andre_miku...@hotmail.com From: Andre Mikulec Sent: Sunday, October 23, 2016 7:05 PM To: pgsql-general@postgresql.org Cc: Tom Lane Subject: Re: [GENERAL]

Re: [GENERAL] configure PostgreSQL with PERL: Perl version 5.8 or later is required, but this is .

Never mind. I figured it out. Soon, I will write up a summary. Andre Mikulec andre_miku...@hotmail.com From: Adrian Klaver Sent: Sunday, October 23, 2016 7:18 PM To: Andre Mikulec; pgsql-general@postgresql.org Cc: Tom Lane Subject:

Re: [GENERAL] checkpoint write errors ( getting worse )

Understood, thanks. This is a new server fired up for our client by Rackspace Not real impressed so far, for the first several days we had major performance issues even thought new new HW had more memory and more/faster CPU's and faster IO - turned out rackspace had turned on cpu throttling

Re: [GENERAL] Doubts about replication from many servers

Em 21-10-2016 13:48, Adrian Klaver escreveu: On 10/21/2016 08:09 AM, Edilmar LISTAS wrote: Hi, I have 4 PG servers where each one runs many databases. Now, I would like to create just one PG backup server to replicate all the databases from 4 PG servers, is it possible? Or Do I need to create

Re: [GENERAL] SERIALIZABLE and INSERTs with multiple VALUES

On Thu, Oct 13, 2016 at 5:26 PM, Thomas Munro wrote: > (1) postgres=# create table bank_account (id int primary key, cash int); > (1) CREATE TABLE > (1) postgres=# begin transaction isolation level serializable ; > (1) BEGIN > > (2) postgres=# begin

Re: [GENERAL] out-of-order XID insertion in KnownAssignedXids

On Mon, Oct 24, 2016 at 8:10 AM, wrote: > This was actually introduced some time back, and I am not completely certain > how it crept into our codebase. I think that at least part of the > explanation lies in the fact that we are experiencing a fair amount of > growth in

Re: [GENERAL] out-of-order XID insertion in KnownAssignedXids

Hi All, thank you all, I sincerely appreciate your feedback. I have done a fair amount of testing on the solution proposed by you all (not removing backup_label), and it seems to have completely addressed the issue. This was actually introduced some time back, and I am not completely certain

Re: [GENERAL] Errors while installing PostGIS by an unusual method

Ankit Sablok writes: > I am trying to install PostGIS on a RHEL_5 system and failing at it > miserably. The way I am trying to install it is as follows. I copy over all > the artifacts of postgresql server as in the bin, lib, share directories of > postgresql server in a

Re: [GENERAL] json-patch support?

Finally got around to doing this... The link below points to a complete implementation of JSONPatch in pure PostgreSQL. It is compatible with PostgreSQL >= 9.5 (Not tested using earlier versions) https://gist.github.com/InfoSec812/b830a9db4c9048552f8c51d7987cc4d0 Cheers! Deven On Fri, Mar 27,

Re: [GENERAL] postgres_fdw : disable extended queries

2016-10-24 10:36 GMT+02:00 Albe Laurenz : > Nicolas Paris wrote: > > I have a 9.6 pg instance, and I am trying to link a foreign postgresql > database that do not accept > > extended queries. (only simple queries https://www.postgresql.org/ >

Re: [GENERAL] postgres_fdw : disable extended queries

Nicolas Paris wrote: > I have a 9.6 pg instance, and I am trying to link a foreign postgresql > database that do not accept > extended queries. (only simple queries > https://www.postgresql.org/docs/current/static/protocol.html ) > > When I run a query against the foreign pg instance thought

Re: [GENERAL] Errors while installing PostGIS by an unusual method

Hi Ankit, Can you please share the generated config.log ? Following works for me i.e. > export > PATH=/work/postgresql/inst/bin:/opt/proj-4.7.0/inst/bin:/opt/gdal-1.9.1/inst/bin:/opt/geos-3.3.5/inst/bin:$PATH > export >

[GENERAL] Errors while installing PostGIS by an unusual method

I am trying to install PostGIS on a RHEL_5 system and failing at it miserably. The way I am trying to install it is as follows. I copy over all the artifacts of postgresql server as in the bin, lib, share directories of postgresql server in a directory called pgql and I place it in the root