Re: [HACKERS] Extending BASE_BACKUP in replication protocol: incremental backup and backup format

2014-01-14 Thread Magnus Hagander
on a full backup with incremental information would be nice as well. I would say those are requirements, not just next step and nice as well :) -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [HACKERS] Extending BASE_BACKUP in replication protocol: incremental backup and backup format

2014-01-14 Thread Magnus Hagander
On Tue, Jan 14, 2014 at 2:18 PM, Andres Freund and...@2ndquadrant.comwrote: On 2014-01-14 14:12:46 +0100, Magnus Hagander wrote: Either way - if we can do this in a safe way, it sounds like a good idea. It would be sort of like rsync, except relying on the fact that we can look at the LSN

Re: [HACKERS] Extending BASE_BACKUP in replication protocol: incremental backup and backup format

2014-01-14 Thread Magnus Hagander
all... You're decreasing network traffic and client storage, with the same I/O on the server side. Seems worthwhile. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [HACKERS] Extending BASE_BACKUP in replication protocol: incremental backup and backup format

2014-01-14 Thread Magnus Hagander
On Tue, Jan 14, 2014 at 2:41 PM, Andres Freund and...@2ndquadrant.comwrote: On 2014-01-14 14:40:46 +0100, Magnus Hagander wrote: On Tue, Jan 14, 2014 at 2:18 PM, Andres Freund and...@2ndquadrant.com wrote: On 2014-01-14 14:12:46 +0100, Magnus Hagander wrote: Either way - if we can do

Re: [HACKERS] Extending BASE_BACKUP in replication protocol: incremental backup and backup format

2014-01-14 Thread Magnus Hagander
On Jan 14, 2014 2:44 PM, Andres Freund and...@2ndquadrant.com wrote: On 2014-01-14 14:42:36 +0100, Magnus Hagander wrote: On Tue, Jan 14, 2014 at 2:41 PM, Andres Freund and...@2ndquadrant.com wrote: On 2014-01-14 14:40:46 +0100, Magnus Hagander wrote: On Tue, Jan 14, 2014 at 2:18 PM

Re: [HACKERS] [GENERAL] pg_upgrade tablespaces

2014-01-12 Thread Magnus Hagander
the symlinks. Which is why it was so easy to remove. If you were using it for something inside pg_upgrade I don't know, but the backend didn't. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [HACKERS] Deprecations in authentication

2014-01-12 Thread Magnus Hagander
On Sat, Jan 11, 2014 at 9:45 PM, Peter Eisentraut pete...@gmx.net wrote: On Thu, 2013-10-24 at 20:37 +0200, Magnus Hagander wrote: On Thu, Oct 24, 2013 at 8:35 PM, Peter Eisentraut pete...@gmx.net wrote: On 10/18/12, 7:20 AM, Magnus Hagander wrote: 1. krb5 authentication. We've had

Re: [HACKERS] Compiling extensions on Windows

2014-01-11 Thread Magnus Hagander
. I'm not sure I believe this. I don't see any PGDLLEXPORT symbols in any of the standard contrib modules; how is it that they work? They are built through our perl toolkit, which enables exporting of *all* symbols, regardless of flags in the code. -- Magnus Hagander Me: http

Re: [HACKERS] [PATCH] pg_basebackup: progress report max once per second

2014-01-11 Thread Magnus Hagander
On Fri, Jan 10, 2014 at 3:56 AM, Mika Eloranta m...@ohmu.fi wrote: On Thu, Jan 9, 2014, at 20:05, Magnus Hagander wrote: On Thu, Nov 14, 2013 at 10:27 AM, Mika Eloranta m...@ohmu.fi wrote: On 13 Nov 2013, at 20:51, Mika Eloranta m...@ohmu.fi wrote: Prevent excessive progress

Re: [HACKERS] Compiling extensions on Windows

2014-01-11 Thread Magnus Hagander
On Sat, Jan 11, 2014 at 7:05 PM, Tom Lane t...@sss.pgh.pa.us wrote: Magnus Hagander mag...@hagander.net writes: On Sat, Jan 11, 2014 at 5:00 PM, Tom Lane t...@sss.pgh.pa.us wrote: I'm not sure I believe this. I don't see any PGDLLEXPORT symbols in any of the standard contrib modules; how

Re: [HACKERS] [PATCH] Relocation of tablespaces in pg_basebackup

2014-01-10 Thread Magnus Hagander
to do the mapping to names. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [HACKERS] [PATCH] Relocation of tablespaces in pg_basebackup

2014-01-09 Thread Magnus Hagander
. but I think it's still more usefriendly than using the oid. This feature might be missing because of some other limitation I fail to see, if so let me know. Please be gentle, this is my first patch ;-) Nope, I think it's just been limited on time. -- Magnus Hagander Me: http

Re: [HACKERS] [PATCH] pg_basebackup: progress report max once per second

2014-01-09 Thread Magnus Hagander
) -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [HACKERS] [PATCH] Support for pg_stat_archiver view

2014-01-08 Thread Magnus Hagander
of separate function calls like the older stats views. Ok, good idea. Not sure I see why it needs to be an SRF. It only returns one row. Good point, it could/should be a general function returning a composite type. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill

Re: [HACKERS] Fixing pg_basebackup with tablespaces found in $PGDATA

2014-01-07 Thread Magnus Hagander
On Thu, Jan 2, 2014 at 2:06 PM, Dimitri Fontaine dimi...@2ndquadrant.frwrote: Magnus Hagander mag...@hagander.net writes: We can't get away with just comparing the relative part of the pathname. Because it will fail if there is another path with exactly the same length, containing

Re: [HACKERS] Assertion failure in base backup code path

2014-01-07 Thread Magnus Hagander
On Tue, Dec 24, 2013 at 1:24 PM, Andres Freund and...@2ndquadrant.comwrote: On 2013-12-23 18:28:51 +0100, Magnus Hagander wrote: On Dec 19, 2013 12:06 AM, Andres Freund and...@2ndquadrant.com wrote: Hi Magnus, It looks to me like the path to do_pg_start_backup() outside

Re: [HACKERS] Assertion failure in base backup code path

2014-01-07 Thread Magnus Hagander
On Tue, Jan 7, 2014 at 5:43 PM, Andres Freund and...@2ndquadrant.comwrote: On 2014-01-07 17:40:07 +0100, Magnus Hagander wrote: On Tue, Dec 24, 2013 at 1:24 PM, Andres Freund and...@2ndquadrant.com wrote: On 2013-12-23 18:28:51 +0100, Magnus Hagander wrote: On Dec 19, 2013 12:06 AM

Re: [HACKERS] [PATCH] Support for pg_stat_archiver view

2014-01-05 Thread Magnus Hagander
On Sat, Jan 4, 2014 at 2:01 PM, Gabriele Bartolini gabriele.bartol...@2ndquadrant.it wrote: Il 04/01/14 13:25, Magnus Hagander ha scritto: With those two, I think it would make much sense to have a view like this. Ok, I will prepare version 2 with those. Oh, and you need to change

Re: [HACKERS] [PATCH] Support for pg_stat_archiver view

2014-01-04 Thread Magnus Hagander
you for ;) I think it's definitely worthwhile with those things fixed (and a proper review, that was just a quick one-over) -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [HACKERS] Fixing pg_basebackup with tablespaces found in $PGDATA

2014-01-02 Thread Magnus Hagander
On Wed, Jan 1, 2014 at 11:53 PM, Dimitri Fontaine dimi...@2ndquadrant.frwrote: Hi, As much as I've seen people frown upon $subject, it still happens in the wild, and Magnus seems to agree that the current failure mode of our pg_basebackup tool when confronted to the situation is a bug. So

Re: [HACKERS] Assertion failure in base backup code path

2013-12-23 Thread Magnus Hagander
On Dec 19, 2013 12:06 AM, Andres Freund and...@2ndquadrant.com wrote: Hi Magnus, It looks to me like the path to do_pg_start_backup() outside of a transaction context comes from your initial commit of the base backup facility. The problem is that you're not allowed to do anything leading

Re: [HACKERS] SSL: better default ciphersuite

2013-12-12 Thread Magnus Hagander
it, but it means they at least have a chance. That said, #2 seems reasonable I think, but I wouldn't object to #1 either :) -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [HACKERS] pg_stat_statements: calls under-estimation propagation

2013-12-08 Thread Magnus Hagander
://buildfarm.postgresql.org/cgi-bin/show_stage_log.pl?nm=frogmouthdt=2013-12-08%2007%3A30%3A01stg=make-contrib that there are compiler warnings being generated in pgss. But from a quick look that looks like something pre-existing and not caused by the latest patch. -- Magnus Hagander Me: http://www.hagander.net

Re: [HACKERS] [bug fix] pg_ctl always uses the same event source

2013-12-08 Thread Magnus Hagander
to be logged is the one saying that it couldn't exec postgres to find out the value in the config file? AFAICT it's going to try to register an eventsource with whatever random garbage happens to be in the variable. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill

Re: [HACKERS] Time-Delayed Standbys

2013-12-05 Thread Magnus Hagander
a very useful feature for those people. But we could help people who run into it because of a simple config error.. Or maybe the suggested patch already does this, in which case ignore that part :) -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [HACKERS] Improvement of pg_stat_statement usage about buffer hit ratio

2013-12-04 Thread Magnus Hagander
it. (And of course also for Peters comment about that we need to figure out if something is actually missing for building this higher level tool that can provide this information and more) -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [HACKERS] pgsql: Fix a couple of bugs in MultiXactId freezing

2013-12-04 Thread Magnus Hagander
On Tue, Dec 3, 2013 at 7:20 PM, Tom Lane t...@sss.pgh.pa.us wrote: Magnus Hagander mag...@hagander.net writes: On Tue, Dec 3, 2013 at 7:11 PM, Tom Lane t...@sss.pgh.pa.us wrote: Maybe we should just bite the bullet and change the WAL format for heap_freeze (inventing an all-new record type

Re: [HACKERS] Why we are going to have to go DirectIO

2013-12-04 Thread Magnus Hagander
such participation out of community funds if said developer can't do it on his own. But it should definitely be a developer with interest and skills in that particular area as well of course :) So don't think I'm proposing myself, I definitely am not :) -- Magnus Hagander Me: http

Re: [HACKERS] pgsql: Fix a couple of bugs in MultiXactId freezing

2013-12-04 Thread Magnus Hagander
On Wed, Dec 4, 2013 at 8:43 PM, Tom Lane t...@sss.pgh.pa.us wrote: Magnus Hagander mag...@hagander.net writes: On Tue, Dec 3, 2013 at 7:20 PM, Tom Lane t...@sss.pgh.pa.us wrote: I assume what would happen is the slave would PANIC upon seeing a WAL record code it didn't recognize. I

Re: [HACKERS] pgsql: Fix a couple of bugs in MultiXactId freezing

2013-12-03 Thread Magnus Hagander
at all. I assume we'd then get rid of the old record type completely in 9.4, right? -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [HACKERS] pgsql: Fix a couple of bugs in MultiXactId freezing

2013-12-03 Thread Magnus Hagander
On Tue, Dec 3, 2013 at 7:20 PM, Tom Lane t...@sss.pgh.pa.us wrote: Magnus Hagander mag...@hagander.net writes: On Tue, Dec 3, 2013 at 7:11 PM, Tom Lane t...@sss.pgh.pa.us wrote: Maybe we should just bite the bullet and change the WAL format for heap_freeze (inventing an all-new record type

Re: [HACKERS] Why we are going to have to go DirectIO

2013-12-03 Thread Magnus Hagander
and/or cmd and/or pgus at some point try something like that? -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [HACKERS] docbook-xsl version for release builds

2013-11-29 Thread Magnus Hagander
On Fri, Nov 29, 2013 at 4:06 AM, Peter Eisentraut pete...@gmx.net wrote: On Mon, 2013-11-25 at 16:32 +0100, Magnus Hagander wrote: Thanks for the reminder - done (installed the DEB from sid, version 1.78.1). This will somehow show up in the snapshot builds, correct? So we (you? :P) can

Re: [HACKERS] docbook-xsl version for release builds

2013-11-25 Thread Magnus Hagander
On Mon, Nov 25, 2013 at 4:27 PM, Peter Eisentraut pete...@gmx.net wrote: On 10/3/13, 7:58 AM, Magnus Hagander wrote: Did we get around to doing this? Nope. Given my schedule between now and the release wrap, I won't have a chance to do it if I want any reasonable ability to roll

Re: [HACKERS] docbook-xsl version for release builds

2013-11-25 Thread Magnus Hagander
On Mon, Nov 25, 2013 at 4:40 PM, Tom Lane t...@sss.pgh.pa.us wrote: Magnus Hagander mag...@hagander.net writes: This will somehow show up in the snapshot builds, correct? So we (you? :P) can verify after the next snapshots that it's correct? I thought the devel docs at http

Re: [HACKERS] Autoconf 2.69 update

2013-11-20 Thread Magnus Hagander
and committers are going to have to deal with a local installation in many cases anyway. So we might be better off just documenting that in a more clear way. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [HACKERS] New option for pg_basebackup, to specify a different directory for pg_xlog

2013-11-19 Thread Magnus Hagander
haribabu.ko...@huawei.com wrote: on 15 November 2013 17:26 Magnus Hagander wrote: On Fri, Nov 15, 2013 at 12:10 PM, Haribabu kommi haribabu.ko...@huawei.com wrote: On 14 November 2013 23:59 Fujii Masao wrote: On Thu, Nov 14, 2013 at 9:08 PM, Haribabu kommi

Re: [HACKERS] New option for pg_basebackup, to specify a different directory for pg_xlog

2013-11-15 Thread Magnus Hagander
. But - separate issue. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [HACKERS] [GENERAL] Clang 3.3 Analyzer Results

2013-11-14 Thread Magnus Hagander
between the two? It's also in pg_dump/pg_backup_db.c, there's a version of it in pg_dumpall.c, etc. Which I think is a good argument for fixing them all by sharing the code somewhere? In fact, we already have some in script/common.c - but it's only used by the tools that are in script/. //Magnus

Re: [HACKERS] [PATCH 1/2] SSL: GUC option to prefer server cipher order

2013-11-14 Thread Magnus Hagander
as not having one... //Magnus -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [HACKERS] Links in README.git are broken

2013-11-12 Thread Magnus Hagander
the developer docs a while ago. In addition, why isn't INSTALL stored in git? Because it's built from SGML, to have the same contents as the html/pdf docs. We don't typically store derived files in git - only some exceptions like configure. -- Magnus Hagander Me: http://www.hagander.net/ Work

Re: [HACKERS] streaming header too small

2013-11-11 Thread Magnus Hagander
On Wed, Feb 20, 2013 at 5:02 PM, Heikki Linnakangas hlinnakan...@vmware.com wrote: On 20.02.2013 17:53, Selena Deckelmann wrote: On Wed, Feb 20, 2013 at 6:23 AM, Magnus Hagandermag...@hagander.netwrote: Selena, was this reasonably reproducible for you? Would it be possible to get a network

Re: [HACKERS] Changing pg_dump default file format

2013-11-07 Thread Magnus Hagander
the idea in general :) Maybe we could consider changing the default format if -f is specified to write it directly to a file. OTOH, hat might just make it confusing -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list

Re: [HACKERS] Changing pg_dump default file format

2013-11-07 Thread Magnus Hagander
pg_basebackup -x, and not full archive_command/full pitr setup. That's still a separate argument, of course. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] Changing pg_dump default file format

2013-11-07 Thread Magnus Hagander
On Thu, Nov 7, 2013 at 7:08 PM, Joshua D. Drake j...@commandprompt.com wrote: On 11/07/2013 10:00 AM, Josh Berkus wrote: On 11/07/2013 08:26 AM, Tom Lane wrote: Magnus Hagander mag...@hagander.net writes: On Thu, Nov 7, 2013 at 5:02 PM, Joshua D. Drake j...@commandprompt.com wrote: I

Re: [HACKERS] Deprecations in authentication

2013-10-24 Thread Magnus Hagander
On Thu, Oct 24, 2013 at 8:35 PM, Peter Eisentraut pete...@gmx.net wrote: On 10/18/12, 7:20 AM, Magnus Hagander wrote: 1. krb5 authentication. We've had gssapi since 8.3 (which means in all supported versions). krb5 has been deprecated, also since 8.3. Time to remove it? OS X Mavericks has

Re: [HACKERS] Patch for fail-back without fresh backup

2013-10-24 Thread Magnus Hagander
that until it's too late. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- 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] autovacuum_work_mem

2013-10-21 Thread Magnus Hagander
not like there's a different parameter to control a different kind of memory in autovac, is there? -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] autovacuum_work_mem

2013-10-20 Thread Magnus Hagander
], explaining the rationale in some detail [2]. At the time Magnus seemed to think this a good idea [3]. Attached simple patch adds a new GUC, autovacuum_work_mem, which when set to a value other than -1 (the default) is preferred by autovacuum over maintenance_work_mem. All other usage of VACUUM

Re: [HACKERS] Auto-tuning work_mem and maintenance_work_mem

2013-10-15 Thread Magnus Hagander
it was. But the argument about being friendly for new users should definitely have us change wal_level and max_wal_senders. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] Long paths for tablespace leads to uninterruptible hang in Windows

2013-10-15 Thread Magnus Hagander
to have it at my last job, and used it a number of times during the initial porting work. The people backing that one are generally pretty good) -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] Auto-tuning work_mem and maintenance_work_mem

2013-10-15 Thread Magnus Hagander
On Tue, Oct 15, 2013 at 7:26 PM, Andres Freund and...@2ndquadrant.com wrote: On 2013-10-15 10:19:06 -0700, Josh Berkus wrote: On 10/15/2013 05:52 AM, Magnus Hagander wrote: But the argument about being friendly for new users should definitely have us change wal_level and max_wal_senders

Re: [HACKERS] Auto-tuning work_mem and maintenance_work_mem

2013-10-15 Thread Magnus Hagander
On Tue, Oct 15, 2013 at 7:32 PM, Andres Freund and...@2ndquadrant.com wrote: On 2013-10-15 19:29:50 +0200, Magnus Hagander wrote: On Tue, Oct 15, 2013 at 7:26 PM, Andres Freund and...@2ndquadrant.com wrote: On 2013-10-15 10:19:06 -0700, Josh Berkus wrote: On 10/15/2013 05:52 AM, Magnus

Re: [HACKERS] Long paths for tablespace leads to uninterruptible hang in Windows

2013-10-14 Thread Magnus Hagander
for how... -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- 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] Auto-tuning work_mem and maintenance_work_mem

2013-10-12 Thread Magnus Hagander
we'd help 1000 times more users of we enabled a few wal writers by default and jumped the wal level. Mainly so they could run one off base backup. That's used by orders of magnitude more users than XA. /Magnus

Re: [HACKERS] Auto-tuning work_mem and maintenance_work_mem

2013-10-12 Thread Magnus Hagander
the reason to increase them, more io is. For people deploying on modern server hardware then yes it's often low, but for all those deploying in virtualized environments with io performance reminding you of the 1990ies, I'm not so sure it is... /Magnus

Re: [HACKERS] Auto-tuning work_mem and maintenance_work_mem

2013-10-11 Thread Magnus Hagander
a recompile every time something is touched. I think in the context of this problem, reimplementing that from python to C is the easiest part. Actually figuring out what the tool should *do* and how it should do it is the hard part. -- Magnus Hagander Me: http://www.hagander.net/ Work: http

Re: [HACKERS] Auto-tuning work_mem and maintenance_work_mem

2013-10-10 Thread Magnus Hagander
able to preview settings is a problem. I'd even say it would be a *big* problem. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Auto-tuning work_mem and maintenance_work_mem

2013-10-10 Thread Magnus Hagander
in to the database. I imagine that could be less convenient in some scripting environments. I think that would also make it much harder to automate for packagers. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] Auto-tuning work_mem and maintenance_work_mem

2013-10-09 Thread Magnus Hagander
can give a custom one to pg_restore can't you - just issue a SET command inthe session, it won't affect autovac or anybody else) -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] Auto-tuning work_mem and maintenance_work_mem

2013-10-09 Thread Magnus Hagander
dynamically resize the work_mem into a value that might cause his machine to die from swapping which would definitely violate the principle of least surprise.. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] Auto-tuning work_mem and maintenance_work_mem

2013-10-09 Thread Magnus Hagander
, in a lot of cases we are also the packagers, but the point being that this code is already 100% platform specific, making the problem easier) -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] old warning in docs

2013-10-08 Thread Magnus Hagander
for removing that (but only in master, not the back-branches). +1, and definitely not in back branches. /Magnus

Re: [HACKERS] docbook-xsl version for release builds

2013-10-03 Thread Magnus Hagander
On Tue, Oct 1, 2013 at 11:37 PM, Alvaro Herrera alvhe...@2ndquadrant.com wrote: Magnus Hagander wrote: On Thu, Aug 22, 2013 at 8:13 AM, Tom Lane t...@sss.pgh.pa.us wrote: Peter Eisentraut pete...@gmx.net writes: On Fri, 2013-07-12 at 12:30 +0200, Magnus Hagander wrote: Given that, I'm fine

Re: [HACKERS] hstore extension version screwup

2013-10-03 Thread Magnus Hagander
, or the configure script, (or something else a developer runs often) chmod the file. It's not bulletproof in any way, but it would give a decent hint in most cases. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers

[HACKERS] Prevent pg_basebackup -Fp -D -?

2013-10-02 Thread Magnus Hagander
seriously annoying behavior. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- 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] Prevent pg_basebackup -Fp -D -?

2013-10-02 Thread Magnus Hagander
On Oct 3, 2013 2:47 AM, Michael Paquier michael.paqu...@gmail.com wrote: On Wed, Oct 2, 2013 at 11:31 PM, Magnus Hagander mag...@hagander.net wrote: Right now, if you use pg_basebackup -Ft -D - you get a tarfile, written to stdout, for redirection. However, if you use

Re: [HACKERS] SSL renegotiation

2013-10-01 Thread Magnus Hagander
that error if, as Alvaro puts it, we end up breaking too many things. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [HACKERS] Successor of MD5 authentication, let's use SCRAM

2013-09-12 Thread Magnus Hagander
1000 LOC (bsd licensed). And that's generic - it might well be shorter if we do something ourselves. And if it's BSD licensed, we could import.. (And then extend to run on top of other cyrpto libraries, of course) -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill

Re: [HACKERS] Protocol forced to V2 in low-memory conditions?

2013-09-10 Thread Magnus Hagander
believe the jdbc driver at least has code for it, but I don't know if it's a requirement at this point. If it is, that might be a 10.0 release feature, in how it would break things :( -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql

Re: [HACKERS] Protocol forced to V2 in low-memory conditions?

2013-09-10 Thread Magnus Hagander
On Tue, Sep 10, 2013 at 3:53 PM, Tom Lane t...@sss.pgh.pa.us wrote: Andres Freund and...@2ndquadrant.com writes: On 2013-09-10 12:31:22 +0200, Magnus Hagander wrote: On Tue, Sep 10, 2013 at 5:29 AM, Tom Lane t...@sss.pgh.pa.us wrote: I've been thinking of late that it might be time to retire

Re: [HACKERS] proposal: Set effective_cache_size to greater of .conf value, shared_buffers

2013-09-05 Thread Magnus Hagander
the system and tunes it from there. I also don't think it should be called autotuning, when it's just a smarter default value. I like the feature, though, just not the packaging. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers

Re: [HACKERS] [9.4] Make full_page_writes only settable on server start?

2013-09-03 Thread Magnus Hagander
/Magnus

Re: [HACKERS] docbook-xsl version for release builds

2013-08-22 Thread Magnus Hagander
On Thu, Aug 22, 2013 at 8:13 AM, Tom Lane t...@sss.pgh.pa.us wrote: Peter Eisentraut pete...@gmx.net writes: On Fri, 2013-07-12 at 12:30 +0200, Magnus Hagander wrote: Given that, I'm fine with just bumping the version on borka to that version. Any objections? This was not done for 9.3rc1

Re: [HACKERS] LDAP: bugfix and deprecated OpenLDAP API

2013-08-16 Thread Magnus Hagander
On Tue, Jul 23, 2013 at 11:53 AM, Albe Laurenz laurenz.a...@wien.gv.at wrote: Magnus Hagander wrote: In that case, doesn't this patch break Windows? We no longer do the anonymous bind on Windows, since it's now in the #ifdef HAVE_LIBLDAP. Don't we need to keep the ldap_simple_bind() call

Re: [HACKERS] danger of stats_temp_directory = /dev/shm

2013-08-15 Thread Magnus Hagander
to prevent you from pointing at, say, ~postgres and thereby losing some files you'd rather not. +1 on that as well. It shouldn't be that hard to do. /Magnus

[HACKERS] psql missing tab completion for extensions

2013-08-15 Thread Magnus Hagander
psql is missing tab completion for \dx (or more usfully, for \dx+). Attached patch fixes this. Do we consider this a bugfix and backpatch (at least to 9.3? even though the problem goes back further), or head only? -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill

Re: [HACKERS] psql missing tab completion for extensions

2013-08-15 Thread Magnus Hagander
On Thu, Aug 15, 2013 at 5:26 PM, Stephen Frost sfr...@snowman.net wrote: * Tom Lane (t...@sss.pgh.pa.us) wrote: Magnus Hagander mag...@hagander.net writes: psql is missing tab completion for \dx (or more usfully, for \dx+). Attached patch fixes this. Do we consider this a bugfix

Re: [HACKERS] timeline signedness

2013-08-14 Thread Magnus Hagander
as signed 32-bit integers. It's obviously a corner case, but it would be prudent to be correct about this. It should be easy to fix in those grammar files. Here is a patch to fix this. Looks fine to me, and looks like the correct thing to do. -- Magnus Hagander Me: http://www.hagander.net/ Work

Re: [HACKERS] pg_basebackup vs. Windows and tablespaces

2013-08-12 Thread Magnus Hagander
way to do it than to put it in the actual recovery code? -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [HACKERS] pg_basebackup vs. Windows and tablespaces

2013-08-12 Thread Magnus Hagander
On Mon, Aug 12, 2013 at 8:14 PM, Andrew Dunstan and...@dunslane.net wrote: On 08/12/2013 01:40 PM, Magnus Hagander wrote: I also like the concept of #2, but I think we need to think about it a bit more. One of the things I like about barman backups is that on recovery you can map where

Re: [HACKERS] [PATCH] pg_sleep(interval)

2013-08-11 Thread Magnus Hagander
that period, it would not work for the cf app (but it would work for the wiki and some other sites). -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] [COMMITTERS] pgsql: Allow background workers to be started dynamically.

2013-07-19 Thread Magnus Hagander
background workers. Probably better not to get people to used to using them. +1. Much better to take that pain now, before we have made a production release. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql

Re: [HACKERS] docbook-xsl version for release builds

2013-07-12 Thread Magnus Hagander
On Thu, Jul 11, 2013 at 8:34 PM, Peter Eisentraut pete...@gmx.net wrote: On 7/11/13 5:55 AM, Magnus Hagander wrote: If it's safe to switch on the old ones as well, it sounds doable. If we need different toolchains, that's going to be a serious pain. Have you verified that it's fine

Re: [HACKERS] docbook-xsl version for release builds

2013-07-11 Thread Magnus Hagander
to be a serious pain. Have you verified that it's fine with the old ones as well, or are you jsut assuming? Second, when you say the latest debian package, you mean grab the one from sid? I didn't see anything in backports, but maybe I'm missing something? -- Magnus Hagander Me: http://www.hagander.net

Re: [HACKERS] robots.txt on git.postgresql.org

2013-07-11 Thread Magnus Hagander
On Thu, Jul 11, 2013 at 3:43 PM, Greg Stark st...@mit.edu wrote: On Wed, Jul 10, 2013 at 9:36 AM, Magnus Hagander mag...@hagander.net wrote: We already run this, that's what we did to make it survive at all. The problem is there are so many thousands of different URLs you can get

Re: [HACKERS] robots.txt on git.postgresql.org

2013-07-10 Thread Magnus Hagander
indexes them all by default. It's before we had this that the side regularly died. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] [PATCH] Add an ldapoption to disable chasing LDAP referrals

2013-07-09 Thread Magnus Hagander
in the next commitfest! -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [HACKERS] robots.txt on git.postgresql.org

2013-07-09 Thread Magnus Hagander
google or bing or baidu or those hit it. Giving horrible response times and timeouts for actual users. We might be able to do something better aobut that now taht we can do better rate limiting, but it's like playing whack-a-mole. The basic software is just fantastically slow. -- Magnus Hagander

Re: [HACKERS] robots.txt on git.postgresql.org

2013-07-09 Thread Magnus Hagander
, there aren't any for cgit, but maybe I'm searching for the wrong thing.. If they do all those things, and people do like those interfaces, then sure, we can do that. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql

Re: [HACKERS] copy pasted include guard in attoptcache.h

2013-07-07 Thread Magnus Hagander
. Applied, thanks! -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- 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] LDAP: bugfix and deprecated OpenLDAP API

2013-07-05 Thread Magnus Hagander
. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- 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] LDAP: bugfix and deprecated OpenLDAP API

2013-07-05 Thread Magnus Hagander
On Mon, Jul 1, 2013 at 4:16 PM, Albe Laurenz laurenz.a...@wien.gv.at wrote: Magnus Hagander wrote: On Tue, Feb 5, 2013 at 10:39 AM, Albe Laurenz laurenz.a...@wien.gv.at wrote: I found a small bug in the implementation of LDAP connection parameter lookup. [...] As coded now, the timeout

Re: [HACKERS] [GENERAL] autoanalyze criteria

2013-07-05 Thread Magnus Hagander
+ updated the regression test expected input. Applied, with the changs suggested by Laurenz Albe in his review. Thanks! -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS] Review: Display number of changed rows since last analyze

2013-07-05 Thread Magnus Hagander
On Mon, Jul 1, 2013 at 3:15 PM, Albe Laurenz laurenz.a...@wien.gv.at wrote: Magnus Hagander wrote: On Mon, Jun 17, 2013 at 1:49 PM, Albe Laurenz laurenz.a...@wien.gv.at wrote: I think that the column name is ok as it is, even if it is a bit long - I cannot come up with a more succinct idea

Re: [HACKERS] [COMMITTERS] pgsql: Add new GUC, max_worker_processes, limiting number of bgworkers.

2013-07-05 Thread Magnus Hagander
On Fri, Jul 5, 2013 at 6:28 AM, Kevin Hale Boyes kcbo...@gmail.com wrote: The change to config.sgml contains a small typo with the double r in the xreflabel. + varlistentry id=guc-max-worker-processes xreflabel=max_worrker_processes Fixed, thanks. -- Magnus Hagander Me: http

Re: [HACKERS] [PATCH] Add an ldapoption to disable chasing LDAP referrals

2013-07-04 Thread Magnus Hagander
: enable referral chasing That is exactly what I'm suggesting it should do, and I'm pretty sure that's what Peter suggested as well. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [HACKERS] [PATCH] Add an ldapoption to disable chasing LDAP referrals

2013-07-03 Thread Magnus Hagander
to specifically have a setting to rely on library defaults - just remove it from the line and you get that. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [HACKERS] Review: Display number of changed rows since last analyze

2013-07-01 Thread Magnus Hagander
stats counters are), I'm not sure that's a problem? It would be a name that sounds more similar to the rest of the table. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS] LDAP: bugfix and deprecated OpenLDAP API

2013-07-01 Thread Magnus Hagander
check against OpenSSL at some point, or a configure check? Are we just assuming that all versions that people ever use have the function deprecated? (That's probably not entirely unreasonable, just double checking) -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com

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