Re: [GENERAL] Database connection Pooling using JNDI

2014-02-17 Thread Andrew Hastie
Hi Sumit, I think you need to refer to the documentation for the JDBC driver and not the actual PostgresSQL database server documentation. See here: http://jdbc.postgresql.org/documentation/92/jndi.html#ds-jndi Hope this helps. Andrew On 17/02/14 09:27, Sumit Sureka wrote: Hi, I am planni

Re: [GENERAL] zLinux Load Testing Experience

2013-05-02 Thread Andrew Hastie
On 01/05/13 19:21, Merlin Moncure wrote: On Wed, May 1, 2013 at 11:34 AM, Andrew Hastie wrote: On 01/05/13 15:34, Merlin Moncure wrote: On Wed, May 1, 2013 at 8:01 AM, Andrew Hastie wrote: On 30/04/13 20:46, Merlin Moncure wrote: On Tue, Apr 30, 2013 at 12:26 PM, Jeff Janes wrote: On

Re: [GENERAL] zLinux Load Testing Experience

2013-05-01 Thread Andrew Hastie
On 01/05/13 15:34, Merlin Moncure wrote: On Wed, May 1, 2013 at 8:01 AM, Andrew Hastie wrote: On 30/04/13 20:46, Merlin Moncure wrote: On Tue, Apr 30, 2013 at 12:26 PM, Jeff Janes wrote: On Tue, Apr 30, 2013 at 8:28 AM, Andrew Hastie wrote: I'm currently working on a project porti

Re: [GENERAL] zLinux Load Testing Experience

2013-05-01 Thread Andrew Hastie
On 30/04/13 20:46, Merlin Moncure wrote: On Tue, Apr 30, 2013 at 12:26 PM, Jeff Janes wrote: On Tue, Apr 30, 2013 at 8:28 AM, Andrew Hastie wrote: I'm currently working on a project porting an application from RedHat Linux on Intel onto IBM zLinux. Our application requires PostgreS

[GENERAL] zLinux Load Testing Experience

2013-04-30 Thread Andrew Hastie
I'm currently working on a project porting an application from RedHat Linux on Intel onto IBM zLinux. Our application requires PostgreSQL at version 9.n, so the PostgreSQL binaries have been built using the standard build tools from source. Everything appears run correctly. However as part of p

Re: [GENERAL] Dedicated PostgreSQL System

2013-01-02 Thread Andrew Hastie
On 02/01/13 14:30, Carlos Mennens wrote: Hello All, I'm trying to understand what exact parameters or configurations are adjusted when a PostgreSQL database system is going to be used as a 'stand-alone' or 'dedicated' server versus a shared or embedded database system? I have a server that's onl

Re: [GENERAL] pg_upgrade: out of memory

2012-10-01 Thread Andrew Hastie
Tom/Matthew, I also tried the same macro with the xlc compiler with similar results in that pg_dump now works as expected :-) For info here's my build setup:- ./configure CC=xlc LIBS="-lssl -lcrypto -lz -lreadline -lcurses -lld -lmass -lm" CFLAGS="-qlanglvl=extc89 -D_LINUX_SOURCE_COMPAT"

Re: [GENERAL] pg_upgrade: out of memory

2012-10-01 Thread Andrew Hastie
Hi Tom/Matthew, Just to chime in on this thread - I'm currently validating Postgres on AIXv7.1 and confirm that I also see the same error. I can reproduce the error with 9.2.1 and 9.2.0 but unlike Matthew I'm using a built from source build using the IBM xcl compiler rather than gcc. I don't

Re: [GENERAL] PG Installer - Licensing Issues

2012-08-16 Thread Andrew Hastie
Thanks for your thoughts Craig, the issue with users having an existing PG installation is a definite concern. It sounds like you're recommending using the "ZIP Binaries", at least for MS Win installs, and configuring things manually rather than using the one-click installer. If so, are there

[GENERAL] PG Installer - Licensing Issues

2012-08-15 Thread Andrew Hastie
As I understand it, I am allowed to redistribute Postgres so long as I include the copyright notice plus paragraphs as detailed on http://www.postgresql.org/about/licence/. What I want to confirm is that the one-click installer (which I understand was supplied by EnterpriseDB) can also be redi

Re: [GENERAL] How to don't update sequence on rollback of a transaction

2012-08-02 Thread Andrew Hastie
Hi Frank, I believe this is by design. See the bottom of the documentation on sequences where it states ;- "*Important:* To avoid blocking concurrent transactions that obtain numbers from the same sequence, a |nextval| operation is never rolled back; that is, once a value has been fetched it

[GENERAL] Installing on IBM AIX 7.1

2012-07-31 Thread Andrew Hastie
Does anyone out there have any experience or feedback on building+installing PG on an AIX7.1 system? I need to do some testing on this platform in a few weeks time, so any hints or tips greatly appreciated. Thanks Andrew -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) T

Re: [GENERAL] PL/pgSQL - Help or advice please on using unbound cursors

2012-07-25 Thread Andrew Hastie
Yep, that fixed it. Many thanks for the pointer. From a performance point of view, I did look at using MOVE rather than FETCH before I call UPDATE as I don't actually need to read the data before applying the update. However in this situation, the ROW_COUNT is always zero and can't be used whi

[GENERAL] PL/pgSQL - Help or advice please on using unbound cursors

2012-07-23 Thread Andrew Hastie
Hi all, Apologies if the answer to my question is "obvious", but I'm fairly new to writing functions in PG. I think my problem is has a simple solution, but I'm damned if I can find it :-/ (Postgres v9.1.1 on Linux 64-bit) I'm trying to write a function which will :- 1. Take 3 input params;