Re: [HACKERS] SHOW TABLES

2010-07-15 Thread Joshua D. Drake
On Thu, 2010-07-15 at 18:02 +0200, Guillaume Lelarge wrote: I have to agree with Simon here. \d is ridiculous for the common user. SHOW TABLES, SHOW COLUMNS makes a lot of sense. Just has something like DESCRIBE TABLE foo makes a lot more sense than \d. And would you add the

Re: [HACKERS] SHOW TABLES

2010-07-15 Thread Joshua D. Drake
look like, rough as that process is. So starting a discussion thread is the wrong way to achieve that? How would you have me gain consensus if not this way? I think you guys are talking past each other. I believe Kevin was in fact stating that we needed to continue discussion. Joshua D. Drake

Re: [HACKERS] SHOW TABLES

2010-07-15 Thread Joshua D. Drake
On Thu, 2010-07-15 at 18:48 +, Greg Sabino Mullane wrote: P.S. What's with the uppercase mania in this thread? Can we please get back to saying select * from tables and show tables? :) The standard specifies that it it should be uppercase. :P JD -- PostgreSQL.org Major Contributor

Re: [HACKERS] SHOW TABLES

2010-07-15 Thread Joshua D. Drake
On Thu, 2010-07-15 at 13:16 -0300, Marc G. Fournier wrote: Isn't that what the information_schema catalog is for? I'd rather write: SHOW TABLES; then: SELECT table_name FROM information_schema.tables WHERE table_type = 'BASE TABLE' AND table_schema NOT IN

Re: [HACKERS] Branch created, let the experiment begin ...

2010-07-14 Thread Joshua D. Drake
On Fri, 2010-07-09 at 00:58 -0300, Marc G. Fournier wrote: As decided at this years hackers conference, we are branching REL9_0_STABLE *before* the release, instead of after. The hope is that we won't be taking away resources from finishing the release, but still allow ppl to continue to

[HACKERS] PgWest 2010 Call for Papers!

2010-07-14 Thread Joshua D. Drake
Following on the smashing success of PostgreSQL Conference East, PostgreSQL Conference West, The PostgreSQL Conference for Decision Makers, End Users and Developers, is being held at the St. Francis, Westin Hotel in San Francisco from November 2nd through 4th 2010. Please join us in making this

Re: [HACKERS] gSoC - ADD MERGE COMMAND - code patch submission

2010-07-12 Thread Joshua D. Drake
On Mon, 2010-07-12 at 23:28 +0300, Peter Eisentraut wrote: On mån, 2010-07-12 at 10:04 -0400, Greg Smith wrote: Wasting the time of everyone in the community by sharing code that doesn't mean any of the project guidelines is a very bad idea; please don't do that again. I think it's

Re: [HACKERS] FYI: Ubuntu 10.04 lucid strange segfault

2010-07-09 Thread Joshua D. Drake
for your different requirements. Sincerely, Joshua D. Drake -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] [COMMITTERS] pgsql: Add note that using PL/Python 2 and 3 in the same session will

2010-07-06 Thread Joshua D. Drake
to do something more pro-active to prevent such conflicts? +1 Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Development, Engineering -- Sent via pgsql-hackers mailing list (pgsql-hackers

[HACKERS] EOL for 7.4 and 8.0

2010-06-24 Thread Joshua D. Drake
Hello, We need to make sure and send out multiple announcements of this. At least 2 during the month of July. JD -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Development, Engineering -- Sent via

Re: [HACKERS] EOL for 7.4 and 8.0

2010-06-24 Thread Joshua D. Drake
On Thu, 2010-06-24 at 10:34 -0700, Josh Berkus wrote: On 06/24/2010 09:04 AM, Joshua D. Drake wrote: Hello, We need to make sure and send out multiple announcements of this. At least 2 during the month of July. Ach. I drafted an annoucement ... did I ever send it out? Not sure

Re: [HACKERS] beta3 the open items list

2010-06-20 Thread Joshua D. Drake
of the user. Perhaps this has already been solved and I don't know about it. Does the master-slave relationship have a built in ping mechanism that is outside of the TCP protocol? Sincerely, Joshua D. Drake regards, tom lane -- PostgreSQL.org Major Contributor Command

Re: [HACKERS] beta3 the open items list

2010-06-19 Thread Joshua D. Drake
that we have yet to decide; once it's decided, someone will need to do it... TCP involves unknowns, such as firewalls, vpn routers and ssh tunnels. I humbly suggest we *not* be pedantic and implement something practical and less prone to variables outside the control of Pg. Sincerely, Joshua D. Drake

Re: [HACKERS] extensible enum types

2010-06-19 Thread Joshua D. Drake
key is for :) Joshua D. Drake -- Regards, Peter Geoghegan -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Development, Engineering -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] extensible enum types

2010-06-18 Thread Joshua D. Drake
in the table via that specific enum: ALTER TABLE foo ALTER COLUMN bar VALUES (bar,baz,bing,foo) ALTER TABLE would know its an enum and would perform proper operations on the system table. Sincerely, Joshua D. Drake cheers andrew -- PostgreSQL.org Major Contributor Command Prompt, Inc: http

Re: [pgsql-www] ANNOUNCE list (was Re: [HACKERS] New PGXN Extension site)

2010-06-17 Thread Joshua D. Drake
zone. Agreed. Joshua D. Drake -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] New PGXN Extension site

2010-06-16 Thread Joshua D. Drake
just sounds and speels weird - PGAN was much easier ;) I actually like PGXN. PGXN is marketable. Yeah that may not be what -hackers are after but if I stand up in front of a Fortune 500 company and say, We have PGXN it sounds a heck of a lot better that PGAN. Joshua D. Drake Stefan

Re: [HACKERS] New PGXN Extension site

2010-06-16 Thread Joshua D. Drake
. If I stand up and say, PostgreSQL has PGXN, the PostgreSQL Extension Network Versus PostgreSQL has PGAN, P can that Can, I am Pee gannning. What? Anyway, a name is a name. We are PostgreSQL after all. Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http

Re: ANNOUNCE list (was Re: [HACKERS] New PGXN Extension site)

2010-06-16 Thread Joshua D. Drake
, and I am the only one watching... If it comes through during my business day, I moderate immediately (assuming I am reading email) Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development

Re: [HACKERS] streaming replication breaks horribly if master crashes

2010-06-16 Thread Joshua D. Drake
point of view, doesn't exist. In other words, the database on the slave would be silently corrupted. I don't know what to do about this, but I'm pretty sure we can't ship it as-is. The slave must be able to survive a master crash. Joshua D. Drake -- Robert Haas EnterpriseDB: http

Re: ANNOUNCE list (was Re: [HACKERS] New PGXN Extension site)

2010-06-16 Thread Joshua D. Drake
is being selective in releasing some, yet not others? Do we need some more moderators? Yes. Currently the only moderators for -announce are Marc and Greg S-M. And me, and devrim and a number of others. Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http

Re: ANNOUNCE list (was Re: [HACKERS] New PGXN Extension site)

2010-06-16 Thread Joshua D. Drake
moderate on the weekends. I was the one that approved the PGXN email for example. Joshua D. Drake -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com -- PostgreSQL.org

Re: ANNOUNCE list (was Re: [HACKERS] New PGXN Extension site)

2010-06-16 Thread Joshua D. Drake
On Thu, 2010-06-17 at 01:17 +0300, Devrim GUNDUZ wrote: I don't moderate -announce. Sorry. I thought you did. JD -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering -- Sent via

Re: ANNOUNCE list (was Re: [HACKERS] New PGXN Extension site)

2010-06-16 Thread Joshua D. Drake
delays here. :) I am just saying that I regularly moderate but there are rules around my moderation just like anyone else. I like Tatuso's idea. Sincerely, Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training

Re: [HACKERS] New PGXN Extension site

2010-06-15 Thread Joshua D. Drake
of PGX in PGXN :P). Sincerely, Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] New PGXN Extension site

2010-06-15 Thread Joshua D. Drake
for the project that states the following: Where the source code will be hosted (for the project itself) What license it will be released under Sincerely, Joshua D. Drake P.S. If you can monetize this, go for it. -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com

Re: [HACKERS] Synchronization levels in SR

2010-05-26 Thread Joshua D. Drake
On Wed, 2010-05-26 at 15:37 -0400, Robert Haas wrote: On Wed, May 26, 2010 at 3:13 PM, Simon Riggs si...@2ndquadrant.com wrote: I don't really understand this comment. I have said, and I believe, that a system without quorum commit is simpler than one with quorum commit. I'd debate the

Re: [HACKERS] Synchronization levels in SR

2010-05-25 Thread Joshua D. Drake
across the country. It is common, very common. Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] pg_upgrade code questions

2010-05-13 Thread Joshua D. Drake
in it. If the code would be useful for other projects then keep it. If it is only for a closed source product, dump it. Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development

Re: [HACKERS] List traffic

2010-05-13 Thread Joshua D. Drake
lists and all the other goodies any MUA will give you, I see no reason to have this all broken out anymore. Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering -- Sent

Re: [HACKERS] primary/secondary/master/slave/standby

2010-05-12 Thread Joshua D. Drake
. Ideas? How about origin/subscriber? More descriptive than primary/secondary, and less tied to a particular model of interaction. Yes but completely out of scope within the market. Master/Slave or Master/Standby is probably where it needs to be. Joshua D. Drake -- PostgreSQL.org Major

Re: [HACKERS] max_standby_delay considered harmful

2010-05-12 Thread Joshua D. Drake
of yahoos (no pun intended) who are better served beating up on that database that Oracle just bought, versus Oracle itself. Patience is a virtue for all when it comes to the this feature. Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com

Re: [HACKERS] Re: [ANNOUNCE] Bug-fix and new feature of pg_lesslog is released

2010-05-12 Thread Joshua D. Drake
for it... Not to mention, WAN based standby, timed standby etc... Joshua D. Drake -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support

Re: [HACKERS] max_standby_delay considered harmful

2010-05-12 Thread Joshua D. Drake
On Wed, 2010-05-12 at 22:34 +0100, Simon Riggs wrote: On Wed, 2010-05-12 at 14:43 -0400, Robert Haas wrote: I thought that it would be a good idea for Simon to look at it because, on the surface, it APPEARS to have something to do with Hot Standby, since that's what Stefan was testing

Re: [HACKERS] no universally correct setting for fsync

2010-05-10 Thread Joshua D. Drake
environmental factors. Joshua D. Drake -- greg -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] pg_migrator to /contrib in a later 9.0 beta

2010-05-05 Thread Joshua D. Drake
to change the name. Once its in contrib, we likely never will and this isn't really a migration tool. It is an upgrade tool. Joshua D. Drake -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company -- PostgreSQL.org Major Contributor Command Prompt, Inc

Re: [HACKERS] max_standby_delay considered harmful

2010-05-04 Thread Joshua D. Drake
, as well as adding another set of potential failure conditions which need to be monitored. +1 Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering -- Sent via pgsql

Re: [HACKERS] pg_migrator to /contrib in a later 9.0 beta

2010-05-03 Thread Joshua D. Drake
On Mon, 2010-05-03 at 16:12 -0400, Robert Haas wrote: On Sun, May 2, 2010 at 3:45 PM, Dimitri Fontaine dfonta...@hi-media.com wrote: Now you tell me how awful this idea really is :) I'm not sure I can count that high. :-) You don't have to... NaN Joshua D. Drake ...Robert

Re: [HACKERS] Re: [COMMITTERS] pgsql: Make CheckRequiredParameterValues() depend upon correct

2010-04-29 Thread Joshua D. Drake
to have some of this code turned on by default. But it is absolutely not in keeping with this project's mindset or historical practice to enable it by default now. regards, tom lane +1 Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http

Re: [HACKERS] s/recovery_connections/allow_standby_queries/, or something like that?

2010-04-29 Thread Joshua D. Drake
? enable_standby_queries (nitpicky but it seems more appropriate) Joshua D. Drake regards, tom lane -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering -- Sent via

Re: [HACKERS] Re: [COMMITTERS] pgsql: Make CheckRequiredParameterValues() depend upon correct

2010-04-29 Thread Joshua D. Drake
off for release. Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: pg_start_backup and pg_stop_backup Re: [HACKERS] Re: [COMMITTERS] pgsql: Make CheckRequiredParameterValues() depend upon correct

2010-04-28 Thread Joshua D. Drake
by except with filesystem-level snapshot capabilities? Like LVM, SANS or ZFS. Joshua D. Drake ...Robert -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering -- Sent via pgsql

Re: [HACKERS] BETA

2010-04-20 Thread Joshua D. Drake
On Tue, 2010-04-20 at 18:23 +0100, Dave Page wrote: On Tue, Apr 20, 2010 at 6:09 PM, Robert Haas robertmh...@gmail.com wrote: /me pushes luck And how about a set of back-branch releases while we're at it? Yes, please don't push your luck :-p /me gives Dave an Easy button. --

Re: [HACKERS] A maze of twisty mailing lists all the same

2010-04-08 Thread Joshua D. Drake
the archives. Joshua D. Drake -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training

Re: [GENERAL] [HACKERS] Postgres 9.1 - Release Theme

2010-04-01 Thread Joshua D. Drake
On Thu, 2010-04-01 at 10:54 -0600, Scott Marlowe wrote: On Thu, Apr 1, 2010 at 10:05 AM, David E. Wheeler da...@kineticode.com wrote: On Apr 1, 2010, at 3:01 AM, Magnus Hagander wrote: I prefer to dump all my data in a big text file and grep it for the information I need. As long

Re: [HACKERS] Getting to beta1

2010-03-18 Thread Joshua D. Drake
provide that list with nothing but a care bear discussion. Joshua D. Drake -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com -- PostgreSQL.org Major Contributor

Re: [HACKERS] Getting to beta1

2010-03-18 Thread Joshua D. Drake
On Thu, 2010-03-18 at 19:10 -0400, Robert Haas wrote: On Thu, Mar 18, 2010 at 4:28 PM, Marc G. Fournier scra...@hub.org wrote: On Thu, 18 Mar 2010, Joshua D. Drake wrote: On Thu, 2010-03-18 at 10:18 -0700, Josh Berkus wrote: It's already in the docs, so if they read it and understand

Re: [HACKERS] SQL compatibility reminder: MySQL vs PostgreSQL

2010-03-05 Thread Joshua D. Drake
feel like it's our problem to fix that. As far as I can tell, no promiment member of this community agrees with any of the changes you are proposing. Correct. Not to mention as far as I understand it, 99% of this is resolved in Drupal 7. Joshua D. Drake -- PostgreSQL.org Major Contributor

Re: [HACKERS] SQL compatibility reminder: MySQL vs PostgreSQL

2010-03-05 Thread Joshua D. Drake
. It is within our interest to work with them but in a proper way. As I have said, Drupal 7 addresses most of our concerns, so anything we want to complain about should be in the interest of making sure Drupal 7 works properly, not previous versions. Sincerely, Joshua D. Drake cheers andrew

Re: [HACKERS] Repetition of warning message while REVOKE

2010-03-04 Thread Joshua D. Drake
On Thu, 2010-03-04 at 11:23 -0500, Tom Lane wrote: I wrote: Piyush Newe piyush.n...@enterprisedb.com writes: create table tbl(col int); create user usr; grant select on tbl to usr; \c postgres usr; REVOKE SELECT on tbl from usr; WARNING: no privileges could be revoked for tbl

Re: [HACKERS] Safe security

2010-03-03 Thread Joshua D. Drake
On Wed, 2010-03-03 at 11:33 -0500, Andrew Dunstan wrote: Well, we could put in similar weasel words I guess. But after all, Safe's very purpose is to provide a restricted execution environment, no? We already do, in our license. Joshua D. Drake cheers andrew

Re: [HACKERS] pg_stop_backup does not complete

2010-03-02 Thread Joshua D. Drake
that I ever mentioned this and I think it is a terrible hack that we would mention it in the docs. From a professional perspective, I cringe at the idea of telling a customer to do this, not to mention it won't work on w32. Joshua D. Drake -- PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot

Re: [HACKERS] Re: Hot Standby query cancellation and Streaming Replication integration

2010-02-26 Thread Joshua D. Drake
the slave to run long-running queries is a special case? One of the number one things I can see this being used for is reporting Sincerely, Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom

Re: [HACKERS] Hot Standby query cancellation and Streaming Replication integration

2010-02-26 Thread Joshua D. Drake
with the idea of high-availability. I want my ability to run large batch queries without any performance or reliability impact on the primary server. +1 I can use any number of other technologies for high availability. Joshua D. Drake -- PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org

Re: [HACKERS] pg_stop_backup does not complete

2010-02-24 Thread Joshua D. Drake
with the production issues and do so with a smile. Sincerely, Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering Respect is earned, not gained through arbitrary

Re: [HACKERS] pg_stop_backup does not complete

2010-02-24 Thread Joshua D. Drake
On Wed, 2010-02-24 at 19:02 +, Simon Riggs wrote: On Wed, 2010-02-24 at 10:17 -0800, Joshua D. Drake wrote: You make the mistake of assuming that someone that can develop has no solution experience. That is exactly how I fund further development, so you are off base by a long way. I

Re: [HACKERS] pg_stop_backup does not complete

2010-02-24 Thread Joshua D. Drake
the top. I prefer Kevin's solution or some variant thereof: http://archives.postgresql.org/pgsql-hackers/2010-02/msg01853.php http://archives.postgresql.org/pgsql-hackers/2010-02/msg01907.php Sincerely, Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http

Re: [HACKERS] pg_stop_backup does not complete

2010-02-24 Thread Joshua D. Drake
in production by typing pg_stop_backup() except in a demo. Nobody will see this. This is not true. It is not uncommon for a pitr setup to get out of sync for any number of production reasons. It is one of the reasons that PITRTools supports executing a pg_stop_backup. Joshua D. Drake

Re: [HACKERS] pg_stop_backup does not complete

2010-02-23 Thread Joshua D. Drake
should do whatever it needs to do to shutdown; including issuing a pg_stop_backup. Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering Respect is earned, not gained

Re: [HACKERS] pg_stop_backup does not complete

2010-02-23 Thread Joshua D. Drake
-essential code there, all of which needs to be tested. I don't think adding in new corner cases to help people makes any sense until we have automated testing that allows us to rerun the regression tests to check all this stuff still works. This will bite us if we release like this. Joshua D. Drake

Re: [HACKERS] pg_stop_backup does not complete

2010-02-23 Thread Joshua D. Drake
than pg_fail_backup(), but... But...? Joshua D. Drake ...Robert -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering Respect is earned, not gained through arbitrary

Re: [HACKERS] Recent vendor SSL renegotiation patches break PostgreSQL

2010-02-22 Thread Joshua D. Drake
(like files changing underneath rsync). Joshua D. Drake -- PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- Sent via pgsql-hackers mailing list

Re: [HACKERS] Recent vendor SSL renegotiation patches break PostgreSQL

2010-02-22 Thread Joshua D. Drake
, but EDB is the provider of w32 binaries, not the community. Joshua D. Drake -- PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- Sent via pgsql

Re: [HACKERS] Recent vendor SSL renegotiation patches break PostgreSQL

2010-02-22 Thread Joshua D. Drake
On Mon, 2010-02-22 at 18:45 +0100, Magnus Hagander wrote: 2010/2/22 Joshua D. Drake j...@commandprompt.com: On Mon, 22 Feb 2010 18:00:33 +0100, Magnus Hagander mag...@hagander.net wrote: We also have to consider our Windows users, where *we* ship the OpenSSL library. Where

Re: [HACKERS] scheduler in core

2010-02-20 Thread Joshua D. Drake
solutions and operating system dependencies. Joshua D. Drake regards, tom lane -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering Respect is earned, not gained

Re: [HACKERS] OpenVMS?

2010-02-16 Thread Joshua D. Drake
. Joshua D. Drake -- Andrew Chernow eSilo, LLC every bit counts http://www.esilo.com/ -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering Respect is earned, not gained

Re: [HACKERS] Streaming Replication docs

2010-02-12 Thread Joshua D. Drake
recovery.conf pg_ident.conf ... hmmm, am I missing one? Seems that should go... under Reference Joshua D. Drake --Josh Berkus -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development

Re: [HACKERS] Bug on pg_lesslog

2010-02-11 Thread Joshua D. Drake
On Thu, 2010-02-11 at 23:39 +0900, Koichi Suzuki wrote: Dear Folks; A very serious bug was reported on pg_lesslog. So far, I found it's a bug in pg_compresslog. Please do not use pg_compresslog and pg_decompresslog until improved version is uploaded. I strongly advise to take base

Re: [HACKERS] plpython3

2010-02-01 Thread Joshua D. Drake
in this down the road, I think we could consider it for a future release. I spoke with James offline about this as well. My understanding (correct me James) is that he is working on an implementation that can be installed via PGXS. Joshua D. Drake ...Robert -- PostgreSQL.org Major

Re: [HACKERS] plpython3

2010-02-01 Thread Joshua D. Drake
direction. I am a +1 Joshua D. Drake -Nathan -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering Respect is earned, not gained through arbitrary and repetitive use or Mr

Re: [HACKERS] plpython3

2010-02-01 Thread Joshua D. Drake
are coding perl and thus you might as well just code perl? Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering Respect is earned, not gained through arbitrary

Re: [HACKERS] plpython3

2010-02-01 Thread Joshua D. Drake
look at this whole thread, you will see the James has a very different view of the implementation. One that at least appears to be more advanced and pythonic than our version. Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564

Re: [HACKERS] plpython3

2010-02-01 Thread Joshua D. Drake
a very different view of the implementation. One that at least appears to be more advanced and pythonic than our version. More pythonic in its internal processing or in its user interface? User interface and also internal processing (see the types discussion). Joshua D. Drake

Re: [HACKERS] Hot Standby: Relation-specific deferred conflict resolution

2010-01-29 Thread Joshua D. Drake
D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering Respect is earned, not gained through arbitrary and repetitive use or Mr. or Sir. -- Sent via pgsql-hackers mailing

Re: [HACKERS] Hot Standby: Relation-specific deferred conflict resolution

2010-01-29 Thread Joshua D. Drake
on the release blockers, pretty much stat... we revert it. Joshua D. Drake ...Robert -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering Respect is earned, not gained through

Re: [HACKERS] Hot Standby: Relation-specific deferred conflict resolution

2010-01-29 Thread Joshua D. Drake
. Further discussion seems pointless. Let's be clear. Robert is discussing release blockers. He is not suggesting that no work has been done. I believe the community considers release-blocks the priority. Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http

Re: [HACKERS] Hot Standby: Relation-specific deferred conflict resolution

2010-01-29 Thread Joshua D. Drake
On Fri, 2010-01-29 at 11:41 -0800, Josh Berkus wrote: All, Is there a working list of HS must-fix items somewhere which people agree on? Or are we still lacking consensus? VACUUM FULL, I believe is one. Joshua D. Drake --Josh Berkus -- PostgreSQL.org Major Contributor Command

Re: [HACKERS] PG 9.0 and standard_conforming_strings

2010-01-29 Thread Joshua D. Drake
) The time to change it is NOW, so that when we go into beta it becomes a serious in your face, we have to fix this if we want to be compatible with v9 of PostgreSQL. And get this... because of HS and SR, everybody is going to want to be compatible with v9. Sincerely, Joshua D. Drake

Re: [HACKERS] Streaming replication, and walsender during recovery

2010-01-28 Thread Joshua D. Drake
slaves.) I agree. WAL replay as a whole is a bottlekneck. As it stands now (I don't know about 8.5), replay is a large bottleneck on keeping the warm-standby up to date. Sincerely, Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com

Re: [HACKERS] [COMMITTERS] pgsql: Remove tabs in SGML.

2010-01-27 Thread Joshua D. Drake
if you are using tabs. Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering Respect is earned, not gained through arbitrary and repetitive use or Mr. or Sir. -- Sent

Re: [HACKERS] plpython3

2010-01-26 Thread Joshua D. Drake
do we get this reviewed? I asked my guys to do it, but my C guys are very Perl centric... Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering Respect is earned

Re: [HACKERS] Clustering Docs WAS: Mammoth in Core?

2010-01-25 Thread Joshua D. Drake
to be in core. Which is fairly independent of the clustering docs. My suggestion would be to start a new thread entirely. Joshua D. Drake --Josh -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development

Re: [HACKERS] plpython3 perf

2010-01-25 Thread Joshua D. Drake
On Wed, 2010-01-20 at 19:32 -0700, James William Pye wrote: Apologies ahead of time for the lack pretty graphs. =) I used two different builds/installations of PG to test as the PL names conflict. Both were compiled with the following CFLAGS(pg_config output): -O2 -Wall

Re: [HACKERS] Mammoth in Core?

2010-01-19 Thread Joshua D. Drake
ad 8.5 But again, as Tom says... none of this is relevant until 8.5 is released at which point, we can talk about all of this again. Hopefully 1.9 will be done by then. Done. Joshua D. Drake -- -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] Hot Standby and handling max_standby_delay

2010-01-16 Thread Joshua D. Drake
for core. Just a thought. Joshua D. Drake -- Simon Riggs www.2ndQuadrant.com -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering Respect is earned, not gained

Re: [HACKERS] Streaming replication, loose ends

2010-01-15 Thread Joshua D. Drake
it something like continuous archiving or streaming pitr Joshua D. Drake -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- PostgreSQL.org Major

Re: [HACKERS] Streaming replication, loose ends

2010-01-15 Thread Joshua D. Drake
On Fri, 2010-01-15 at 19:30 +0200, Heikki Linnakangas wrote: Robert Haas wrote: On Fri, Jan 15, 2010 at 12:17 PM, Joshua D. Drake j...@commandprompt.com wrote: Uh, do we really want to call this replication rather than archive log streaming or something. It seems replication

Re: [HACKERS] plpython3

2010-01-15 Thread Joshua D. Drake
On Fri, 2010-01-15 at 13:26 -0700, James William Pye wrote: On Jan 14, 2010, at 2:03 PM, Joshua D. Drake wrote: What I would (as a non hacker) would look for is: (1) Generalized benchmarks between plpython(core) and plpython3u I know a lot of these are subjective, but it is still good

[HACKERS] Mammoth in Core?

2010-01-15 Thread Joshua D. Drake
provide different facilities) then CMD is interested in making this community ready. If the community isn't interested, we are likely to start putting our efforts elsewhere (as opposed to Mammoth Replicator). Sincerely, Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc

Re: [HACKERS] plpython3

2010-01-14 Thread Joshua D. Drake
comparison where the core plpython falls down (if it does) against the plpython3u implementation I can't speak to your code quality, that is going to have to be someone else. Sincerely, Joshua D. Drake Thanks. -- PostgreSQL.org Major Contributor Command Prompt, Inc: http

Re: [HACKERS] plpython3

2010-01-13 Thread Joshua D. Drake
touch plPerl for advanced procedures again. Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering Respect is earned, not gained through arbitrary and repetitive use or Mr

Re: [HACKERS] plpython3

2010-01-13 Thread Joshua D. Drake
On Wed, 2010-01-13 at 19:53 +0200, Peter Eisentraut wrote: On ons, 2010-01-13 at 09:47 -0800, Joshua D. Drake wrote: I think it is important to remember that the current version of PL/python is pretty weak compared to its counter parts (Specifically PL/Perl). How so? O.k. you may have

[HACKERS] PgEast CFP (second call)

2010-01-13 Thread Joshua D. Drake
Sincerely, Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] plpython3

2010-01-13 Thread Joshua D. Drake
On Wed, 2010-01-13 at 13:06 -0700, James William Pye wrote: On Jan 13, 2010, at 11:08 AM, Joshua D. Drake wrote: My argument would be now, what is the benefit of the James Pye version over our version. James can you illustrate succinctly why we should be supporting a new version? Doing

Re: [HACKERS] plpython3

2010-01-13 Thread Joshua D. Drake
/Python versus the Pye patch from you. If nothing else it is a learning opportunity for all involved. Sincerely, Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering

Re: [HACKERS] mailing list archiver chewing patches

2010-01-12 Thread Joshua D. Drake
to decisions of the past. Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering Respect is earned, not gained through arbitrary and repetitive use or Mr. or Sir. -- Sent

Re: [HACKERS] mailing list archiver chewing patches

2010-01-12 Thread Joshua D. Drake
. (Hmm, re-reading what you said, maybe we are suggesting the same thing, but it's not clear. Anyway my point is that Dave's first two requirements are real. Only the third might not be.) We are saying the same thing. Sorry if I wasn't clear. Joshua D. Drake

Re: [HACKERS] damage control mode

2010-01-12 Thread Joshua D. Drake
the big outstanding patches) Joshua D. Drake ...Robert -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering Respect is earned, not gained through arbitrary and repetitive use or Mr

Re: [HACKERS] Streaming replication status

2010-01-12 Thread Joshua D. Drake
On Tue, 2010-01-12 at 16:34 -0500, Bruce Momjian wrote: Tom Lane wrote: Bruce Momjian br...@momjian.us writes: The final commit-fest is in 5 days --- this is not the time for design discussion and feature additions. +10 --- the one reason I can see for deciding to bounce SR is that

Re: [HACKERS] Streaming replication status

2010-01-12 Thread Joshua D. Drake
to dramatically drop the amount of process/log scraping required here to support a SR system. Bingo. Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering Respect is earned

<    4   5   6   7   8   9   10   11   12   13   >