Re: [GENERAL] Re: Using different GCC, CFLAGS, CCFLAGS and CPPFLAGS to compile Postgres and PostGIS?

postgres user writes: > Also can you explain if I built Postgres from source on one platform lets > say RHEL_6 and deployed its artifacts like its binaries, libs and share on > a CentOS In general I would not expect that to work. RHEL to CentOS is a special case

[GENERAL] Re: Using different GCC, CFLAGS, CCFLAGS and CPPFLAGS to compile Postgres and PostGIS?

Also can you explain if I built Postgres from source on one platform lets say RHEL_6 and deployed its artifacts like its binaries, libs and share on a CentOS and tried building extensions against Postgres on CentOS are there any dangers of doing that? On Wed, Feb 1, 2017 at 8:34 PM, postgres user

Re: [GENERAL] Using different GCC, CFLAGS, CCFLAGS and CPPFLAGS to compile Postgres and PostGIS?

postgres user writes: > What can go wrong or is it acceptable if I build Postgres from source with > let's say GCC 4.x.y and some specific CFLAGS, CPPFLAGS and CCFLAGS and when > I try to install an extension for Postgres such as PostGIS using a > different version of

Re: [GENERAL] Using different GCC, CFLAGS, CCFLAGS and CPPFLAGS to compile Postgres and PostGIS?

On 2/1/2017 8:34 PM, postgres user wrote: I am wondering about this question for a while with no definite answer to it, can someone explain me in detail to clear me out on the following question : What can go wrong or is it acceptable if I build Postgres from source with let's say GCC

[GENERAL] Using different GCC, CFLAGS, CCFLAGS and CPPFLAGS to compile Postgres and PostGIS?

Hi, I am wondering about this question for a while with no definite answer to it, can someone explain me in detail to clear me out on the following question : What can go wrong or is it acceptable if I build Postgres from source with let's say GCC 4.x.y and some specific CFLAGS, CPPFLAGS and

Re: [GENERAL] Testing an extension exhaustively?

> On Feb 1, 2017, at 4:03 PM, John R Pierce wrote: > > On 2/1/2017 3:39 PM, postgres user wrote: >> If I have the Postgresql server installed on my machine i.e I have all the >> bins, libs and share directories of the Postgresql and I have the libs and >> sql's installed

Re: [GENERAL] Testing an extension exhaustively?

On 2/1/2017 3:39 PM, postgres user wrote: If I have the Postgresql server installed on my machine i.e I have all the bins, libs and share directories of the Postgresql and I have the libs and sql's installed for one of the contrib extensions lets say "chkpass", how does one go about testing

[GENERAL] Testing an extension exhaustively?

Hi, If I have the Postgresql server installed on my machine i.e I have all the bins, libs and share directories of the Postgresql and I have the libs and sql's installed for one of the contrib extensions lets say "chkpass", how does one go about testing this extension exhaustively on the server?

Re: [GENERAL] Postgresql out-of-memory kill

On Feb 1, 2017, at 1:45 PM, Tom Lane wrote: > > Israel Brewster writes: >> So just a bit ago I ran into a bit of excitement when the kernel decided >> to kill one of my postmaster processes due to an out-of-memory issue, > > Fun :-( > >> So a single

Re: [GENERAL] Causeless CPU load waves in backend, on windows, 9.5.5 (EDB binary).

01.02.2017 1:02, I wrote: [...] Could you use process monitor or such to see what the process is doing while using a lot of CPU? I'm not sure how to do this, especially considering that the process in question is running as a service? Now, some more input: * 9.5.2 server running on linux

Re: [GENERAL] Postgresql out-of-memory kill

Israel Brewster writes: > So just a bit ago I ran into a bit of excitement when the kernel decided > to kill one of my postmaster processes due to an out-of-memory issue, Fun :-( > So a single postmaster process was using over 72GB of ram. No, the kernel was blaming it

[GENERAL] Postgresql out-of-memory kill

So just a bit ago I ran into a bit of excitement when the kernel decided to kill one of my postmaster processes due to an out-of-memory issue, which would have been fine, except that the problem was then compounded by Pacemaker attempting to restart postgresql, but only managing to get as far as

Re: [GENERAL] Data Modeling Tools - Version specific to Postgres

Greg Slawek schrieb am 01.02.2017 um 19:35: Can anyone recommend a data modeling tool (preferably Mac OSX compatible)? I would like to be sure it can export version specific SQL code (ie 9.1 vs 9.4) I have used Toad Data Modeler years ago on Windows, which was pretty good at sticking to the

Re: [GENERAL] Another windowed function with different values.

this issue was raised by timezone settings ... On Wed, Feb 1, 2017 at 10:15 AM, Edmundo Robles wrote: > i just changed the jdbc, but still get the wrong values... > > On Wed, Feb 1, 2017 at 9:47 AM, Edmundo Robles > wrote: > >> this issues could

[GENERAL] Data Modeling Tools - Version specific to Postgres

Can anyone recommend a data modeling tool (preferably Mac OSX compatible)? I would like to be sure it can export version specific SQL code (ie 9.1 vs 9.4) I have used Toad Data Modeler years ago on Windows, which was pretty good at sticking to the differences in each postgres version. I've seen

[GENERAL] Another windowed function with different values.

I have postgresql 9.4 and wrote a function get_ignition_time() to get the first time when a car was ignition on and the last time when ignition is off, those time stamps are used in another function get_fuel_consumption() to get the fuel consumption. The issue is when: 1. I run

Re: [GENERAL] Another windowed function with different values.

this issues could be raised by a incorrect jdbc? the jdbc used is postrgresql-9.2-1002.jdbc4.jar and i have a postgresql 9.4 On Wed, Feb 1, 2017 at 9:35 AM, Edmundo Robles wrote: > > I have postgresql 9.4 and wrote a function get_ignition_time() to get > the first

Re: [GENERAL] Another windowed function with different values.

i just changed the jdbc, but still get the wrong values... On Wed, Feb 1, 2017 at 9:47 AM, Edmundo Robles wrote: > this issues could be raised by a incorrect jdbc? the jdbc used is > postrgresql-9.2-1002.jdbc4.jar and i have a postgresql 9.4 > > On Wed, Feb 1, 2017

Re: [GENERAL] Can we not give tyrannical pedants control of #postgresql?

Greetings, * Merlin Moncure (mmonc...@gmail.com) wrote: > On Thu, Jan 19, 2017 at 5:23 PM, Julian Paul wrote: > > I hope that particular stereotypes aren't proven here, but it appears > > #postgresql encourages a particular tier and makes aware of it's rigid > > hierarchy. I

Re: [GENERAL] Can we not give tyrannical pedants control of #postgresql?

On Thu, Jan 19, 2017 at 5:23 PM, Julian Paul wrote: > I hope that particular stereotypes aren't proven here, but it appears > #postgresql encourages a particular tier and makes aware of it's rigid > hierarchy. I owe alot to #postgresql but not to these particular users, I've

Re: [GENERAL] insert - on conflict question

On Wed, Feb 1, 2017 at 4:15 PM, Johann Spies wrote: > How do I formulate the on conflict do update-section of this query? When > I try set title=q.title, q is unknown. When I try and change 'title' in > the select-part to something else and try title=ti I get the

[GENERAL] insert - on conflict question

How do I formulate the on conflict do update-section of this query? When I try set title=q.title, q is unknown. When I try and change 'title' in the select-part to something else and try title=ti I get the message that ti cannot be used in this part of the query. INSERT INTO wos_2017_1.article