[GENERAL] GCC error while trying to install 9.4 via brew on MAC OS

2015-01-08 Thread Jimmy Jack
Here is the snippet of the error, I am really puzzled why I cannot install postgres. clang: error: unsupported option '-V -isystem/opt/boxen/homebrew/include' clang: error: unknown argument: '-qversion’ any thoughts? thanks a lot This file contains any messages produced by

Re: [GENERAL] GCC error while trying to install 9.4 via brew on MAC OS

2015-01-08 Thread Jimmy Jack
thank you so much! that solved my issue On Thu, Jan 8, 2015 at 6:23 PM, Tom Lane t...@sss.pgh.pa.us wrote: Jimmy Jack jimmyj...@gmail.com writes: here it is, I apologize in advance for very large email The problem is evidently here: configure:12997: checking test program configure:13007:

Re: [GENERAL] GCC error while trying to install 9.4 via brew on MAC OS

2015-01-08 Thread Jimmy Jack
I sent the message, it is pending review due its size… meanwhile there is the cache part thanks a lot! ## ## ## Cache variables. ## ## ## ac_cv_build=x86_64-apple-darwin14.1.0 ac_cv_c_bigendian=no ac_cv_c_compiler_gnu=yes

Re: [GENERAL] How to exclude building/installing contrib modules on Windows

2015-01-08 Thread Michael Paquier
On Fri, Jan 9, 2015 at 11:00 AM, deepak deepak...@gmail.com wrote: Thanks. I tried putting all the modules under the contrib directory to the exclude list. Although I could compile, 3 of 153 regression tests fail. I have attached the regression.diffs file. Even Postgres HEAD has just 151

Re: [GENERAL] GCC error while trying to install 9.4 via brew on MAC OS

2015-01-08 Thread Jimmy Jack
the log is really big, full of errors and ends with error 1 Undefined symbols for architecture x86_64:   _gethostbyname_r, referenced from:       _main in conftest-7b666a.o ld: symbol(s) not found for architecture x86_64 clang: error: linker command failed with exit code 1 (use -v

Re: [GENERAL] GCC error while trying to install 9.4 via brew on MAC OS

2015-01-08 Thread Tom Lane
Jimmy Jack jimmyj...@gmail.com writes: Here is the snippet of the error, I am really puzzled why I cannot install postgres. clang: error: unsupported option '-V -isystem/opt/boxen/homebrew/include' clang: error: unknown argument: '-qversion’ The fragment of config.log you provided looks

Re: [GENERAL] GCC error while trying to install 9.4 via brew on MAC OS

2015-01-08 Thread Tom Lane
Jimmy Jack jimmyj...@gmail.com writes: the log is really big, full of errors and ends with error 1 Undefined symbols for architecture x86_64:   _gethostbyname_r, referenced from: That's expected too, on OS X. There are *lots* of expected failures in a configure run. Please, if you're unable

Re: [GENERAL] Inconsistent bgworker behaviour

2015-01-08 Thread Craig Ringer
On 01/09/2015 12:53 AM, Beena Emerson wrote: Is there any way to check if the bgworker has unregistered and freed a slot? Not that I'm aware of. Anyone else have suggestions? This is related to some other discussion we've had about needing a way to enumerate bgworkers. The specific issue of

Re: [GENERAL] PostgreSQL service account on Windows 7: Use a virtual account

2015-01-08 Thread Craig Ringer
On 09/17/2014 05:35 AM, Michael Paquier wrote: On Thu, Sep 11, 2014 at 10:25 PM, Craig Ringer cr...@2ndquadrant.com wrote: The PostgreSQL installer now uses the NETWORKSERVICE account on Windows by default (as of 9.2), instead of creating a postgres account with username and password. Which is

Re: [GENERAL] How to exclude building/installing contrib modules on Windows

2015-01-08 Thread deepak
Thanks. I tried putting all the modules under the contrib directory to the exclude list. Although I could compile, 3 of 153 regression tests fail. I have attached the regression.diffs file. Maybe some contrib modules are absolutely needed? -- Deepak On Wed, Jan 7, 2015 at 6:19 PM, Michael

Re: [GENERAL] GCC error while trying to install 9.4 via brew on MAC OS

2015-01-08 Thread Tom Lane
Jimmy Jack jimmyj...@gmail.com writes: here it is, I apologize in advance for very large email The problem is evidently here: configure:12997: checking test program configure:13007: clang -o conftest -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels

[GENERAL] View 'instead of' update row with new object

2015-01-08 Thread Tom Dearman
I am partitioning a number of tables in our system and am using a view on the real master table with 'instead of’ triggers to insert and update rows. I have used a view because my application uses Hibernate which does not work well with triggers that return a null to indicate no further

Re: [GENERAL] BDR Error restarted

2015-01-08 Thread deans
Thanks Craig. How exactly do you restart the node? Using service postgresql-9.4 restart command to do the service restart. Please show the full log line, not just an excerpt, along with the lines around it. If possible run with log_error_verbosity=verbose and show the extra line(s) printed

Re: [GENERAL] How to monitor locks (max_pred_locks_per_transaction)?

2015-01-08 Thread Andrey Lizenko
Thanks for your detailed explanation, Kevin. I will check my system again keeping SIReadLock in mind. By the way, does max_locks_per_transaction limit all others modes of locks by the same way? On 7 January 2015 at 00:34, Kevin Grittner kgri...@ymail.com wrote: Andrey Lizenko

[GENERAL] partial text search

2015-01-08 Thread avpro avpro
Hi, my task is to search partial text in the fields mentioned in query. Basically I have to tables t1 and t2 and I need to search in t1 all the codes returned by a query from t2. In t1 the values could be identical as in t2 or could be partial. For example. T1: Description 190201 – is not

Re: [GENERAL] Inconsistent bgworker behaviour

2015-01-08 Thread Beena Emerson
Hello, Thank you for your reply. We could probably use a WaitForBackgroundWorkerTermination(...) to correspond to WaitForBackgroundWorkerStartup(...) . I think you'll probably want to GetBackgroundWorkerPid(...) and examine the returned BgwHandleStatus to see if it's BGWH_STOPPED . If not,