[GENERAL] pgbouncer not finding pidfile

2014-07-28 Thread Tobias Fielitz
Hi, I am trying to start pgbouncer via upstart script. The upstart logs (/var/log/upstart/pgbouncer.log) tell me: /var/run/postgresql/pgbouncer.pid: No such file or directory [2] but when starting pgbouncer from the console with: > sudo service pgbouncer start it works fine and the pidfile i

[GENERAL] Monitoring PostgreSQL with BMC Patrol and Sentry Monitoring Studio

2014-07-28 Thread Sameer Kumar
Hi, I plan to use PostgreSQL on RHEL for one of our customers. They are already using BMC Patrol for monitoring various applications and databases (Oracle and SQL Server). They would like to continue using the same tool for Postgres too. It looks like Postgres is not supported out of box for BMC

Re: [GENERAL] Pairwise array sum aggregate function?

2014-07-28 Thread François Beausoleil
Le 2014-07-28 à 10:58, David G Johnston a écrit : > François Beausoleil wrote >> Hi all, >> >> NOTE: Also posted to StackOverflow: >> http://stackoverflow.com/questions/24997131/pairwise-array-sum-aggregate-function >> >> I have a table with arrays as one column, and I want to sum the array >>

Re: [GENERAL] Standby Server Bus 7 error

2014-07-28 Thread Fabio Milano
Thanks you! -Original Message- From: Merlin Moncure [mailto:mmonc...@gmail.com] Sent: Monday, July 28, 2014 9:54 AM To: Fabio Milano Cc: Kevin Grittner; Michael Paquier; pgsql-general@postgresql.org Subject: Re: [GENERAL] Standby Server Bus 7 error On Mon, Jul 28, 2014 at 11:50 AM, Fabio

Re: [GENERAL] Standby Server Bus 7 error

2014-07-28 Thread Merlin Moncure
On Mon, Jul 28, 2014 at 11:50 AM, Fabio Milano wrote: > Yes. > > The Standby/Slave server is a VPS. Virtuozzo. Virtuozzo is based on OpenVZ. So it's time to look for OpenVZ bus errors and what people did to get around them. In at least one case reducing shared buffers fixed the problem. merlin

Re: [GENERAL] strange result from query, bug ?

2014-07-28 Thread Dan S
Ahh yes, I understand now. Thanks ! Best Regards Dan S 2014-07-28 18:28 GMT+02:00 Tom Lane : > Dan S writes: > > I've run into a strange problem with a query. > > I wonder if it might be a bug or a misunderstanding from my side. > > > Steps to recreate the problem: > > > Generate the necessa

Re: [GENERAL] Standby Server Bus 7 error

2014-07-28 Thread Fabio Milano
Yes. The Standby/Slave server is a VPS. Virtuozzo. -Original Message- From: Merlin Moncure [mailto:mmonc...@gmail.com] Sent: Monday, July 28, 2014 9:47 AM To: Kevin Grittner Cc: Michael Paquier; Fabio Milano; pgsql-general@postgresql.org Subject: Re: [GENERAL] Standby Server Bus 7 error

Re: [GENERAL] Standby Server Bus 7 error

2014-07-28 Thread Merlin Moncure
On Thu, Jul 24, 2014 at 9:48 AM, Kevin Grittner wrote: > Michael Paquier wrote: > >> On Thu, Jul 24, 2014 at 12:53 PM, Fabio Milano > >>> 2014-07-23 14:47:56 EDT LOG: startup process (PID 730) terminated by >>> signal 7: Bus error >> This may find its root to a hardware problem... > > ..

Re: [GENERAL] strange result from query, bug ?

2014-07-28 Thread Tom Lane
Dan S writes: > I've run into a strange problem with a query. > I wonder if it might be a bug or a misunderstanding from my side. > Steps to recreate the problem: > Generate the necessary test data: > create table random_draw( id int not null , constraint random_draw_id_pk > primary key(id)); >

[GENERAL] strange result from query, bug ?

2014-07-28 Thread Dan S
Hi, I'm running "PostgreSQL 9.3.5 on i686-pc-linux-gnu, compiled by gcc-4.4.real (Debian 4.4.5-8) 4.4.5, 32-bit" I've run into a strange problem with a query. I wonder if it might be a bug or a misunderstanding from my side. Steps to recreate the problem: Generate the necessary test data: creat

Re: [GENERAL] Pairwise array sum aggregate function?

2014-07-28 Thread Joe Conway
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/28/2014 07:09 AM, François Beausoleil wrote: > Hi all, > > NOTE: Also posted to StackOverflow: > http://stackoverflow.com/questions/24997131/pairwise-array-sum-aggregate-function > > I have a table with arrays as one column, and I want to sum t

Re: [GENERAL] Pairwise array sum aggregate function?

2014-07-28 Thread David G Johnston
François Beausoleil wrote > Hi all, > > NOTE: Also posted to StackOverflow: > http://stackoverflow.com/questions/24997131/pairwise-array-sum-aggregate-function > > I have a table with arrays as one column, and I want to sum the array > elements together: > >> create table regres(a int[] not null

Re: [GENERAL] Checkpoint_segments optimal value

2014-07-28 Thread Kevin Grittner
Prabhjot Sheena wrote: > PostgreSQL 8.3.7 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 > 20060404 (Red Hat 3.4.6-9) Running anything on that version is insane.  Not only has the 8.3 major release been out of support since February of 2013, but you're missing about 4 years of fix

[GENERAL] Pairwise array sum aggregate function?

2014-07-28 Thread François Beausoleil
Hi all, NOTE: Also posted to StackOverflow: http://stackoverflow.com/questions/24997131/pairwise-array-sum-aggregate-function I have a table with arrays as one column, and I want to sum the array elements together: > create table regres(a int[] not null); > insert into regres values ('{1,2,3}'