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

2016-10-23 Thread Asif Naeem
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 > LD_LIBRARY_PATH=/work/postgresql/inst/lib:/opt/proj-4.7.0/inst/lib:/opt/gdal

[GENERAL] Errors while installing PostGIS by an unusual method

2016-10-23 Thread Ankit Sablok
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 directo

Re: [GENERAL] Replication rolling back to normal.

2016-10-23 Thread Michael Paquier
On Mon, Oct 24, 2016 at 2:20 PM, Dasitha Karunajeewa wrote: > Hi Michael, > > Thanks a lot for the information. I am totally new to Postgres clustering. I > have follow up the below-attached article. > https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-on-postg

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

2016-10-23 Thread Michael Paquier
On Sun, Oct 23, 2016 at 12:45 PM, CS DBA wrote: > would a dump/restore correct these issues? Not directly, but it would give a logical representation of your data, or a good start image that you could deploy on a server that has less problems. You seem to be facing advanced issues with your hardw

Re: [GENERAL] SERIALIZABLE and INSERTs with multiple VALUES

2016-10-23 Thread Tom Lane
I've pushed a simplified (no refactoring) version of the fix proposed by Thomas and Peter, so that we have some kind of fix in place for tomorrow's releases. I think further improvement along the lines suggested by Kevin can wait till later. I noticed that the ON CONFLICT DO NOTHING and ON CONFLI

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

2016-10-23 Thread Adrian Klaver
On 10/23/2016 04:05 PM, Andre Mikulec wrote: I corrected 'PERL=' to include the executable. I tried again. Where did you get the Postgres source you are trying to build? -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To m

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

2016-10-23 Thread Andre Mikulec
I corrected 'PERL=' to include the executable. I tried again. ./configure PERL=/c/EnterpriseDB/LanguagePack/9.5/x64/Perl-5.20/bin/perl5.20.3.exe --with-perl --with-includes=/c/EnterpriseDB/LanguagePack/9.5/x64/Perl-5.20/lib/CORE:/c/Users/AnonymousUser/Documents/zlib-1.2.8-win32-x86_64/include

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-10-23 Thread Andreas Joseph Krogh
På søndag 23. oktober 2016 kl. 20:44:34, skrev Guillaume Lelarge < guilla...@lelarge.info >: [snip] Remember that, if it gets commited, it'll be for next release (aka 10), and not 9.6 and earlier.   The patch working for 9.6 is fine for me, but getting this in mas

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-10-23 Thread Guillaume Lelarge
2016-10-23 20:44 GMT+02:00 Guillaume Lelarge : > 2016-10-23 20:37 GMT+02:00 Andreas Joseph Krogh : > >> På søndag 23. oktober 2016 kl. 19:15:17, skrev Andreas Joseph Krogh < >> andr...@visena.com>: >> >> På søndag 23. oktober 2016 kl. 17:06:57, skrev Guillaume Lelarge < >> guilla...@lelarge.info>:

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-10-23 Thread Guillaume Lelarge
2016-10-23 20:37 GMT+02:00 Andreas Joseph Krogh : > På søndag 23. oktober 2016 kl. 19:15:17, skrev Andreas Joseph Krogh < > andr...@visena.com>: > > På søndag 23. oktober 2016 kl. 17:06:57, skrev Guillaume Lelarge < > guilla...@lelarge.info>: > > 2016-03-08 21:06 GMT+01:00 Andreas Joseph Krogh : >

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-10-23 Thread Andreas Joseph Krogh
På søndag 23. oktober 2016 kl. 19:15:17, skrev Andreas Joseph Krogh < andr...@visena.com >: På søndag 23. oktober 2016 kl. 17:06:57, skrev Guillaume Lelarge < guilla...@lelarge.info >: 2016-03-08 21:06 GMT+01:00 Andreas Joseph Krogh mailto:a

Re: [GENERAL] make PostgreSQL with TCLSH: No rule to make target

2016-10-23 Thread Andre Mikulec
Tom, Along with TCHSH that should reference the tclsh executable and should be TCLSH=/c/Tcl.8.5.18.0/bin/tclsh85.exe, the problem ended up being that the EnterpriseDB LanguagePack file C:\EnterpriseDB\LanguagePack\9.5\x64\Tcl-8.5\lib\tclConfig.sh has the has the hard-coded written line ... TC

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-10-23 Thread Andreas Joseph Krogh
På søndag 23. oktober 2016 kl. 17:06:57, skrev Guillaume Lelarge < guilla...@lelarge.info >: 2016-03-08 21:06 GMT+01:00 Andreas Joseph Krogh mailto:andr...@visena.com>>: På tirsdag 08. mars 2016 kl. 21:03:01, skrev David G. Johnston mailto:david.g.johns...@gmail.com>

[GENERAL] postgres_fdw : disable extended queries

2016-10-23 Thread Nicolas Paris
Hello, 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 postres_fdw, it looks like it

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-10-23 Thread Guillaume Lelarge
2016-03-08 21:06 GMT+01:00 Andreas Joseph Krogh : > På tirsdag 08. mars 2016 kl. 21:03:01, skrev David G. Johnston < > david.g.johns...@gmail.com>: > > On Tue, Mar 8, 2016 at 9:45 AM, Andreas Joseph Krogh > wrote: > >> På tirsdag 08. mars 2016 kl. 17:38:04, skrev Joshua D. Drake < >> j...@command