Re: [GENERAL] pgbouncer setup in the architecture

2014-08-24 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 I'd like to use pgbouncer as connection pooler in our productive environment, which consists of six master db server plus 6 slaves and many webserver and services. For example, I'd like to use it as a central point from where I can redirect

Re: [GENERAL] ERROR: Problem running post install step

2014-08-24 Thread Adrian Klaver
On 08/23/2014 04:07 PM, Brodie S wrote: I'm using Unraid and SMB Are you aware of the Mavericks issues with SMB?: http://hints.macworld.com/article.php?story=20131122083837447 http://www.macwindows.com/mavericks-filesharing.html -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via

Re: [GENERAL] ERROR: Problem running post install step

2014-08-24 Thread Brodie S
This issue may have been resolved. I have yet to encounter any of those issues with SMB. For what it's worth, I just tried connecting to the share with AFP and running the installer. Same result On Sun, Aug 24, 2014 at 10:12 AM, Adrian Klaver adrian.kla...@aklaver.com wrote: On 08/23/2014

Re: [GENERAL] ERROR: Problem running post install step

2014-08-24 Thread Adrian Klaver
On 08/24/2014 09:18 AM, Brodie S wrote: This issue may have been resolved. I have yet to encounter any of those issues with SMB. For what it's worth, I just tried connecting to the share with AFP and running the installer. Same result For what its worth, the tips say to use CIFS to force the

Re: [GENERAL] How to insert either a value or the column default?

2014-08-24 Thread Adrian Klaver
On 08/23/2014 11:10 AM, W. Matthew Wilson wrote: I have a table that looks sort of like this: create table tasks ( task_id serial primary key, title text, status text not null default 'planned' ); In python, I have a function like this: def

[GENERAL] Failure to load plpgsql.so

2014-08-24 Thread Matthew Pounsett
I’m in the process of installing mediawiki, and ran into this error while it was setting up the database: • Query: CREATE FUNCTION page_deleted() RETURNS TRIGGER LANGUAGE plpgsql AS $mw$ BEGIN DELETE FROM recentchanges WHERE rc_namespace = OLD.page_namespace AND rc_title =

Re: [GENERAL] Failure to load plpgsql.so

2014-08-24 Thread Tom Lane
Matthew Pounsett m...@conundrum.com writes: I’m in the process of installing mediawiki, and ran into this error while it was setting up the database: • Query: CREATE FUNCTION page_deleted() RETURNS TRIGGER LANGUAGE plpgsql AS $mw$ BEGIN DELETE FROM recentchanges WHERE rc_namespace =

Re: [GENERAL] How to insert either a value or the column default?

2014-08-24 Thread Daniele Varrazzo
On Sat, Aug 23, 2014 at 7:10 PM, W. Matthew Wilson m...@tplus1.com wrote: I have a table that looks sort of like this: create table tasks ( task_id serial primary key, title text, status text not null default 'planned' ); In python, I have a function

Re: [GENERAL] How to insert either a value or the column default?

2014-08-24 Thread Adrian Klaver
On 08/24/2014 11:50 AM, Daniele Varrazzo wrote: On Sat, Aug 23, 2014 at 7:10 PM, W. Matthew Wilson m...@tplus1.com wrote: I have a table that looks sort of like this: create table tasks ( task_id serial primary key, title text, status text not null default

[GENERAL] how to query against nested hstore data type

2014-08-24 Thread Huang, Suya
Hi, It's my test DB, the version is PostgreSQL 9.4beta2. I'm testing with nested hstore feature. testdb=# \d+ test Table public.test Column | Type | Modifiers | Storage | Stats target | Description ++---+--+--+-

Re: [GENERAL] how to query against nested hstore data type

2014-08-24 Thread Peter Geoghegan
On Sun, Aug 24, 2014 at 7:05 PM, Huang, Suya suya.hu...@au.experian.com wrote: It’s my test DB, the version is PostgreSQL 9.4beta2. I’m testing with nested hstore feature. Really? Nested hstore only made it into that version as jsonb, which you're clearly not using here. -- Regards, Peter

Re: [GENERAL] how to query against nested hstore data type

2014-08-24 Thread Huang, Suya
-Original Message- From: Peter Geoghegan [mailto:peter.geoghega...@gmail.com] Sent: Monday, August 25, 2014 12:14 PM To: Huang, Suya Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] how to query against nested hstore data type On Sun, Aug 24, 2014 at 7:05 PM, Huang, Suya

Re: [GENERAL] how to query against nested hstore data type

2014-08-24 Thread Huang, Suya
-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Huang, Suya Sent: Monday, August 25, 2014 12:18 PM To: Peter Geoghegan Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] how to query against nested hstore data type