Hello,
I've been using the Chef database cookbook and found it
frustrating because it doesn't allow you to use peer
authentication. The client process generally runs as root and
connects to PostgreSQL using the Ruby pg gem.
I have patched it to shell out to psql instead. This has the
added
FWIW the SQL is
DROP AGGREGATE IF EXISTS array_cat_aggregate(anyarray);
CREATE AGGREGATE array_cat_aggregate(anyarray) (
SFUNC = array_cat,
STYPE = anyarray,
INITCOND = '{}'
);
Followed by the other statement given in my previous email. But, I think you've
thoroughly
On Wed, 25 Jun 2014 10:09:18 -0400
Andrew Sullivan a...@crankycanuck.ca wrote:
On Wed, Jun 25, 2014 at 02:43:25PM +0100, James Le Cuirot wrote:
The cookbook currently uses PQexec so multiple SQL commands are
wrapped in a transaction unless an explicit transaction
instruction appears. I
On Wed, Jun 25, 2014 at 03:16:19PM +0100, James Le Cuirot wrote:
Same problem as stdin, the transactional behaviour is different. There
is the --single-transaction option but as the man page says...
If the script itself uses BEGIN, COMMIT, or ROLLBACK, this option will
not have the desired
On Wed, 25 Jun 2014 10:24:53 -0400
Andrew Sullivan a...@crankycanuck.ca wrote:
On Wed, Jun 25, 2014 at 03:16:19PM +0100, James Le Cuirot wrote:
Same problem as stdin, the transactional behaviour is different.
There is the --single-transaction option but as the man page says...
If the
On Wed, Jun 25, 2014 at 03:37:11PM +0100, James Le Cuirot wrote:
Sorry, you're missing the point. I'm trying not to alter the existing
behaviour of the Chef database cookbook
Ah, got it. Sorry, I'm clueless. No, I don't think I have a
suggestion, then.
A
--
Andrew Sullivan
Perhaps you can explain what is the functionality you want to achieve, as
I, for one, don't understand. Do you want transactions? Or not?
Also - I have no idea what peer authentication has to do with Pg gem -
care to elaborate? The gem is for client, and authentication happens in
server, so ... ?
On Wed, 25 Jun 2014 16:42:53 +0200
hubert depesz lubaczewski dep...@gmail.com wrote:
On Wed, Jun 25, 2014 at 4:37 PM, James Le Cuirot
ch...@aura-online.co.uk wrote:
On Wed, 25 Jun 2014 10:24:53 -0400
Andrew Sullivan a...@crankycanuck.ca wrote:
On Wed, Jun 25, 2014 at 03:16:19PM
On Wed, Jun 25, 2014 at 5:18 PM, James Le Cuirot ch...@aura-online.co.uk
wrote:
Also - I have no idea what peer authentication has to do with Pg
gem - care to elaborate? The gem is for client, and authentication
happens in server, so ... ?
Right but peer authentication is all to do with
Re: James Le Cuirot 2014-06-25 20140625144325.49d1124d@red.yakaraplc.local
Hello,
I've been using the Chef database cookbook and found it
frustrating because it doesn't allow you to use peer
authentication. The client process generally runs as root and
connects to PostgreSQL using the Ruby
James Le Cuirot ch...@aura-online.co.uk writes:
Hello,
I've been using the Chef database cookbook and found it
frustrating because it doesn't allow you to use peer
authentication. The client process generally runs as root and
connects to PostgreSQL using the Ruby pg gem.
I have patched it
James Le Cuirot ch...@aura-online.co.uk writes:
hubert depesz lubaczewski dep...@gmail.com wrote:
Perhaps you can explain what is the functionality you want to
achieve, as I, for one, don't understand. Do you want transactions?
Or not?
I want an implicit transaction around the whole script
Hello,
We are facing issues of some DB inconsistencies, while promoting the
slave to master.
[1] We have master-slave with Hot Standby Setup (log shipping).
[2] We also have a daemon process which copies the latest partial WAL
log file (which postgres is currently writing to, under
On Wed, Jun 25, 2014 at 8:43 AM, James Le Cuirot
ch...@aura-online.co.uk wrote:
Hello,
I've been using the Chef database cookbook and found it
frustrating because it doesn't allow you to use peer
authentication. The client process generally runs as root and
connects to PostgreSQL using the
On 06/25/2014 06:29 AM, Karthik Iyer wrote:
[2] We also have a daemon process which copies the latest partial WAL
log file (which postgres is currently writing to, under pg_xlog/) every
3 secs to a different location.
No. No, no, no, no no. No.
Also, no. Partial WAL files are not valid for
On Thu, Jun 19, 2014 at 7:50 AM, RĂ©mi Cura remi.c...@gmail.com wrote:
Hey List,
I use plpython with postgis and 2 python modules (numpy and shapely).
Sadly importing such module in the plpython function is very slow (several
hundreds of milliseconds).
Is that mostly shapely (which I don't
Hi. I've got lots of tables with start and end dates in them, and I'm
trying to learn how to work with them as date ranges (which seem
fantastic!). I've noticed that the daterange() function seems to create
ranges with an inclusive lower bound, and an exclusive upper bound. For
example:
SELECT
On 06/25/2014 05:53 PM, Ken Tanzer wrote:
Hi. I've got lots of tables with start and end dates in them, and I'm
trying to learn how to work with them as date ranges (which seem
fantastic!). I've noticed that the daterange() function seems to create
ranges with an inclusive lower bound, and an
On Wed, Jun 25, 2014 at 6:12 PM, Adrian Klaver adrian.kla...@aklaver.com
wrote:
On 06/25/2014 05:53 PM, Ken Tanzer wrote:
Hi. I've got lots of tables with start and end dates in them, and I'm
trying to learn how to work with them as date ranges (which seem
fantastic!). I've noticed that
Ken Tanzer wrote
Hi. I've got lots of tables with start and end dates in them, and I'm
trying to learn how to work with them as date ranges (which seem
fantastic!). I've noticed that the daterange() function seems to create
ranges with an inclusive lower bound, and an exclusive upper bound.
20 matches
Mail list logo