Re: [HACKERS] Backup docs

2012-06-15 Thread Magnus Hagander
won't have very much log). No removed text, just moved around and added some. Unless there are objections to this one specifically, I'll go ahead and commit it soon. --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ backup_docs.patch Description: Binary data

Re: [HACKERS] libpq compression

2012-06-15 Thread Magnus Hagander
On Fri, Jun 15, 2012 at 5:52 PM, Florian Pflug f...@phlo.org wrote: On Jun15, 2012, at 07:50 , Magnus Hagander wrote: So I've got very little patience with the idea of let's put in some hooks and then great things will happen.  It would be far better all around if we supported exactly one

Re: [HACKERS] libpq compression

2012-06-15 Thread Magnus Hagander
On Fri, Jun 15, 2012 at 6:48 PM, Florian Pflug f...@phlo.org wrote: On Jun15, 2012, at 12:09 , Magnus Hagander wrote: On Fri, Jun 15, 2012 at 5:52 PM, Florian Pflug f...@phlo.org wrote: On Jun15, 2012, at 07:50 , Magnus Hagander wrote: Second, we also have things like the JDBC driver

Re: [HACKERS] [COMMITTERS] pgsql: New SQL functons pg_backup_in_progress() and pg_backup_start_tim

2012-06-15 Thread Magnus Hagander
On Fri, Jun 15, 2012 at 8:16 PM, Robert Haas robertmh...@gmail.com wrote: On Fri, Jun 15, 2012 at 1:52 AM, Magnus Hagander mag...@hagander.net wrote: On Fri, Jun 15, 2012 at 1:29 AM, Robert Haas rh...@postgresql.org wrote: New SQL functons pg_backup_in_progress() and pg_backup_start_time

Re: [HACKERS] libpq compression

2012-06-15 Thread Magnus Hagander
On Fri, Jun 15, 2012 at 10:56 PM, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: On 15.06.2012 17:39, Magnus Hagander wrote: On Fri, Jun 15, 2012 at 6:48 PM, Florian Pflugf...@phlo.org  wrote: The way I see it, if we use SSL-based compression then non-libpq clients there's

Re: [HACKERS] [COMMITTERS] pgsql: New SQL functons pg_backup_in_progress() and pg_backup_start_tim

2012-06-15 Thread Magnus Hagander
On Fri, Jun 15, 2012 at 11:08 PM, Thom Brown t...@linux.com wrote: On 15 June 2012 15:54, Magnus Hagander mag...@hagander.net wrote: On Fri, Jun 15, 2012 at 8:16 PM, Robert Haas robertmh...@gmail.com wrote: On Fri, Jun 15, 2012 at 1:52 AM, Magnus Hagander mag...@hagander.net wrote: On Fri

Re: [HACKERS] libpq compression

2012-06-15 Thread Magnus Hagander
On Fri, Jun 15, 2012 at 11:24 PM, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: On 15.06.2012 17:58, Magnus Hagander wrote: On Fri, Jun 15, 2012 at 10:56 PM, Heikki Linnakangas heikki.linnakan...@enterprisedb.com  wrote: On 15.06.2012 17:39, Magnus Hagander wrote: On Fri

Re: [HACKERS] Backup docs

2012-06-15 Thread Magnus Hagander
On Sat, Jun 16, 2012 at 4:39 AM, Dimitri Fontaine dimi...@2ndquadrant.fr wrote: Magnus Hagander mag...@hagander.net writes: -    The procedure for making a base backup is relatively simple: +    The easiest way to perform a base backup is to use the +    xref linkend=app-pgbasebackup tool

Re: [HACKERS] libpq compression

2012-06-15 Thread Magnus Hagander
On Sat, Jun 16, 2012 at 12:03 AM, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: On 15.06.2012 18:28, Magnus Hagander wrote: On Fri, Jun 15, 2012 at 11:24 PM, Heikki Linnakangas heikki.linnakan...@enterprisedb.com  wrote: On 15.06.2012 17:58, Magnus Hagander wrote: On Fri

Re: [HACKERS] libpq compression

2012-06-15 Thread Magnus Hagander
On Sat, Jun 16, 2012 at 4:04 AM, Euler Taveira eu...@timbira.com wrote: On 15-06-2012 11:39, Magnus Hagander wrote: As long as a free implementation exists, it can be ported to Java/.Net. Sure, it takes more work, but it *can be done*. Good point. IMHO, if there isn't a solution that cover

Re: [HACKERS] libpq compression

2012-06-15 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] [COMMITTERS] pgsql: New SQL functons pg_backup_in_progress() and pg_backup_start_tim

2012-06-15 Thread Magnus Hagander
On Fri, Jun 15, 2012 at 11:14 PM, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: On 15.06.2012 17:54, Magnus Hagander wrote: On Fri, Jun 15, 2012 at 8:16 PM, Robert Haasrobertmh...@gmail.com  wrote: On Fri, Jun 15, 2012 at 1:52 AM, Magnus Hagandermag...@hagander.net  wrote

Re: [HACKERS] Streaming-only Remastering

2012-06-15 Thread Magnus Hagander
soon. That's certainly good, but that doesn't actually solve the problem either. It updates the good workaround. --  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] libpq compression

2012-06-14 Thread Magnus Hagander
it? --  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] Minimising windows installer password confusion

2012-06-12 Thread Magnus Hagander
it is. I think that's better than renaming the old one, really. --  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] Minimising windows installer password confusion

2012-06-12 Thread Magnus Hagander
On Tue, Jun 12, 2012 at 2:48 PM, Dave Page dp...@pgadmin.org wrote: On Tue, Jun 12, 2012 at 1:35 PM, Kevin Grittner kevin.gritt...@wicourts.gov wrote: Magnus Hagander  wrote: Kevin Grittner  wrote: Are they running the installation as a system administrator? If so, rather than throwing up

Re: [HACKERS] 9.2 final

2012-06-12 Thread Magnus Hagander
has us in early september anyway. But if we believe we've taken care of all known open issues fairly soon, getting an RC out rather than a beta before people go on vacation would probably be a good thing... --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com

Re: [HACKERS] Possible error in psql or Postgres?

2012-06-12 Thread Magnus Hagander
it's comparing the constant to whatever your are logged in as. If you log in as root in the database, it will return all rows in the user table. So in short, yes, it's normal. --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers

Re: [HACKERS] pg_basebackup --xlog compatibility break

2012-06-11 Thread Magnus Hagander
On Sun, Jun 10, 2012 at 2:48 PM, Fujii Masao masao.fu...@gmail.com wrote: On Sun, Jun 10, 2012 at 8:43 PM, Magnus Hagander mag...@hagander.net wrote: On Mon, Jun 4, 2012 at 2:14 PM, Peter Eisentraut pete...@gmx.net wrote: On tis, 2012-05-29 at 22:31 +0200, Magnus Hagander wrote: Yeah, good

Re: [HACKERS] pg_receivexlog and feedback message

2012-06-11 Thread Magnus Hagander
On Sun, Jun 10, 2012 at 4:02 PM, Fujii Masao masao.fu...@gmail.com wrote: On Sun, Jun 10, 2012 at 7:55 PM, Magnus Hagander mag...@hagander.net wrote: How about this? +                               /* +                                * Set flushed position to the last byte in the previous

Re: [HACKERS] [ADMIN] pg_basebackup blocking all queries with horrible performance

2012-06-11 Thread Magnus Hagander
On Mon, Jun 11, 2012 at 5:37 PM, Fujii Masao masao.fu...@gmail.com wrote: On Mon, Jun 11, 2012 at 3:24 AM, Magnus Hagander mag...@hagander.net wrote: On Sun, Jun 10, 2012 at 6:08 PM, Fujii Masao masao.fu...@gmail.com wrote: On Sun, Jun 10, 2012 at 11:45 PM, Magnus Hagander mag...@hagander.net

Re: [HACKERS] pg_basebackup --xlog compatibility break

2012-06-11 Thread Magnus Hagander
On Mon, Jun 11, 2012 at 11:28 PM, Peter Eisentraut pete...@gmx.net wrote: On sön, 2012-06-10 at 13:43 +0200, Magnus Hagander wrote: On Mon, Jun 4, 2012 at 2:14 PM, Peter Eisentraut pete...@gmx.net wrote: On tis, 2012-05-29 at 22:31 +0200, Magnus Hagander wrote: Yeah, good arguments all

Re: [HACKERS] Visual Studio 2012 RC

2012-06-10 Thread Magnus Hagander
On Sun, Jun 10, 2012 at 3:16 AM, Brar Piening b...@gmx.de wrote: Magnus Hagander wrote: I don't have too much hope for them actually changing it - they seem hell-bent on forcing everybody into metro, and this seems to be yet another way to do that. But we can always hope... Looks like

Re: [HACKERS] incorrect handling of the timeout in pg_receivexlog

2012-06-10 Thread Magnus Hagander
On Wed, Jun 6, 2012 at 8:10 PM, Fujii Masao masao.fu...@gmail.com wrote: On Tue, Jun 5, 2012 at 11:42 PM, Magnus Hagander mag...@hagander.net wrote: Works for me. We still need a (reworked) patch, though, right? We just move where the move between seconds and milliseconds happens? Attached

Re: [HACKERS] pg_receivexlog and feedback message

2012-06-10 Thread Magnus Hagander
On Thu, Jun 7, 2012 at 12:40 PM, Magnus Hagander mag...@hagander.net wrote: On Thursday, June 7, 2012, Fujii Masao wrote: On Thu, Jun 7, 2012 at 6:25 PM, Magnus Hagander mag...@hagander.net wrote: On Thursday, June 7, 2012, Fujii Masao wrote: On Thu, Jun 7, 2012 at 5:05 AM, Magnus

Re: [HACKERS] New Postgres committer: Kevin Grittner

2012-06-10 Thread Magnus Hagander
team: Now might be a good time to take down the blurb on .org in which Kevin describes the mailing list support as amazing.  :-) Should we, though? We have quotes from e.g. Simon in the list as well - just because he's a commiter doesn't make it any less valid, does it? --  Magnus Hagander  Me

Re: [HACKERS] pg_basebackup --xlog compatibility break

2012-06-10 Thread Magnus Hagander
On Mon, Jun 4, 2012 at 2:14 PM, Peter Eisentraut pete...@gmx.net wrote: On tis, 2012-05-29 at 22:31 +0200, Magnus Hagander wrote: Yeah, good arguments all around, i agree too :-) Next question is - suggestions for naming of said paramter? --xlog-method=something?  And/or -Xsomething, which

Re: [HACKERS] [pgsql-www] Something weird happening in the buildfarm

2012-06-10 Thread Magnus Hagander
it came back up. --  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] Inconsistency in libpq connection parameters, and extension thereof

2012-06-08 Thread Magnus Hagander
On Fri, Jun 8, 2012 at 1:48 PM, Robert Haas robertmh...@gmail.com wrote: On Wed, Jun 6, 2012 at 6:04 PM, Daniel Farina dan...@heroku.com wrote: On Wed, Jun 6, 2012 at 1:13 PM, Robert Haas robertmh...@gmail.com wrote: On Wed, Jun 6, 2012 at 4:08 PM, Magnus Hagander mag...@hagander.net wrote

Re: [HACKERS] Time for pgindent run?

2012-06-07 Thread Magnus Hagander
), and it would give contributors a good chance to rebase before the first CF for 9.3. //Magnus -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [HACKERS] \conninfo and SSL

2012-06-07 Thread Magnus Hagander
, printSSLInfo already outputs translated stuff so this should be OK. Merging both messages into a single translatable unit would be pretty cumbersome, for no practical gain. Seems like a very low-impact change. Are people Ok with sneaking this into 9.2? //Magnus -- Magnus Hagander Me

Re: [HACKERS] pg_receivexlog and feedback message

2012-06-07 Thread Magnus Hagander
On Thursday, June 7, 2012, Fujii Masao wrote: On Thu, Jun 7, 2012 at 5:05 AM, Magnus Hagander mag...@hagander.netjavascript:; wrote: On Wed, Jun 6, 2012 at 8:26 PM, Fujii Masao masao.fu...@gmail.comjavascript:; wrote: On Tue, Jun 5, 2012 at 11:44 PM, Magnus Hagander mag

Re: [HACKERS] SP-GIST docs and examples

2012-06-07 Thread Magnus Hagander
be something more about these in the shared docs. +1, it should definitely get some more docs if possible. //Magnus -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/

Re: [HACKERS] pg_receivexlog and feedback message

2012-06-07 Thread Magnus Hagander
On Thursday, June 7, 2012, Fujii Masao wrote: On Thu, Jun 7, 2012 at 6:25 PM, Magnus Hagander mag...@hagander.net wrote: On Thursday, June 7, 2012, Fujii Masao wrote: On Thu, Jun 7, 2012 at 5:05 AM, Magnus Hagander mag...@hagander.net wrote: On Wed, Jun 6, 2012 at 8:26 PM, Fujii

Re: [HACKERS] XLog changes for 9.3

2012-06-07 Thread Magnus Hagander
or delayed. Yea, I would definitely welcome an early patch. Just as I'm sure everybody else would welcome *your* patches landing in the first commitfest and that you all guarantee to be around quickly follow through on all potential breakages *that* can cause. --  Magnus Hagander  Me: http

Re: [HACKERS] Inconsistency in libpq connection parameters, and extension thereof

2012-06-06 Thread Magnus Hagander
details that are not as sensitive, but still sensitive) over an unencrypted connection. If you wait for the error from the server, 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

Re: [HACKERS] pg_receivexlog and feedback message

2012-06-06 Thread Magnus Hagander
On Wed, Jun 6, 2012 at 8:26 PM, Fujii Masao masao.fu...@gmail.com wrote: On Tue, Jun 5, 2012 at 11:44 PM, Magnus Hagander mag...@hagander.net wrote: On Tue, Jun 5, 2012 at 4:42 PM, Fujii Masao masao.fu...@gmail.com wrote: On Tue, Jun 5, 2012 at 9:53 PM, Magnus Hagander mag...@hagander.net wrote

Re: [HACKERS] Inconsistency in libpq connection parameters, and extension thereof

2012-06-06 Thread Magnus Hagander
On Wed, Jun 6, 2012 at 6:58 PM, Daniel Farina dan...@heroku.com wrote: On Wed, Jun 6, 2012 at 1:09 AM, Magnus Hagander mag...@hagander.net wrote: On Wed, Jun 6, 2012 at 4:38 AM, Daniel Farina dan...@heroku.com wrote: On Tue, Jun 5, 2012 at 6:43 PM, Tom Lane t...@sss.pgh.pa.us wrote: Daniel

Re: [HACKERS] incorrect handling of the timeout in pg_receivexlog

2012-06-05 Thread Magnus Hagander
On Fri, May 25, 2012 at 7:56 PM, Fujii Masao masao.fu...@gmail.com wrote: On Thu, May 24, 2012 at 4:52 AM, Magnus Hagander mag...@hagander.net wrote: On Wed, May 23, 2012 at 8:11 PM, Fujii Masao masao.fu...@gmail.com wrote: On Tue, May 22, 2012 at 11:04 PM, Robert Haas robertmh...@gmail.com

Re: [HACKERS] No, pg_size_pretty(numeric) was not such a hot idea

2012-06-05 Thread Magnus Hagander
with the same identifier though, so that may not be the best idea. If we're just leaving it, should we take it off the open items list, or leave it in there in case something else shows up? --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers

[HACKERS] pg_receivexlog and feedback message

2012-06-05 Thread Magnus Hagander
as a general monitoring thing as well. I think the original reason was that it shouldn't interefer with synchronous replication - but it does take away a fairly useful usecase... --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing

Re: [HACKERS] incorrect handling of the timeout in pg_receivexlog

2012-06-05 Thread Magnus Hagander
On Tue, Jun 5, 2012 at 3:36 PM, Fujii Masao masao.fu...@gmail.com wrote: On Tue, Jun 5, 2012 at 5:32 PM, Magnus Hagander mag...@hagander.net wrote: It contains a number of unrelated changes of %m - %s - what's the motivation for those? %m in fprintf() is glibc extension according to man page

[HACKERS] Backup docs

2012-06-05 Thread Magnus Hagander
than why we do it? Of course not removing the details, just showing the simplest case in, um, a simpler way? --  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] incorrect handling of the timeout in pg_receivexlog

2012-06-05 Thread Magnus Hagander
On Tue, Jun 5, 2012 at 4:28 PM, Fujii Masao masao.fu...@gmail.com wrote: On Tue, Jun 5, 2012 at 10:39 PM, Magnus Hagander mag...@hagander.net wrote: On Tue, Jun 5, 2012 at 3:36 PM, Fujii Masao masao.fu...@gmail.com wrote: On Tue, Jun 5, 2012 at 5:32 PM, Magnus Hagander mag...@hagander.net wrote

Re: [HACKERS] pg_receivexlog and feedback message

2012-06-05 Thread Magnus Hagander
On Tue, Jun 5, 2012 at 4:42 PM, Fujii Masao masao.fu...@gmail.com wrote: On Tue, Jun 5, 2012 at 9:53 PM, Magnus Hagander mag...@hagander.net wrote: Right now, pg_receivexlog sets:                        replymsg-write = InvalidXLogRecPtr;                        replymsg-flush

Re: [HACKERS] Updated version of pg_receivexlog

2012-06-04 Thread Magnus Hagander
On Mon, Jun 4, 2012 at 5:48 PM, Ants Aasma a...@cybertec.at wrote: On Mon, Jun 4, 2012 at 6:20 PM, Fujii Masao masao.fu...@gmail.com wrote: On Mon, Jun 4, 2012 at 11:25 PM, Ants Aasma a...@cybertec.at wrote: On Thu, Sep 29, 2011 at 11:30 PM, Magnus Hagander mag...@hagander.net wrote

Re: [HACKERS] Visual Studio 2012 RC

2012-06-03 Thread Magnus Hagander
much hope for them actually changing it - they seem hell-bent on forcing everybody into metro, and this seems to be yet another way to do that. But we can always hope... --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing

Re: [HACKERS] Visual Studio 2012 RC

2012-06-03 Thread Magnus Hagander
On Sun, Jun 3, 2012 at 12:37 PM, Dave Page dp...@pgadmin.org wrote: On Sun, Jun 3, 2012 at 11:22 AM, Magnus Hagander mag...@hagander.net wrote: On Sat, Jun 2, 2012 at 11:26 PM, Brar Piening b...@gmx.de wrote: The attached patch makes postgres build with Visual Studio 2012 RC. Looks good

Re: [HACKERS] Draft release notes complete

2012-05-31 Thread Magnus Hagander
On Thu, May 31, 2012 at 5:55 PM, Bruce Momjian br...@momjian.us wrote: On Tue, May 15, 2012 at 12:57:37PM -0400, Magnus Hagander wrote: On Fri, May 11, 2012 at 11:44 AM, Andrew Dunstan and...@dunslane.net wrote: On 05/11/2012 05:32 AM, Magnus Hagander wrote: But in the interest

[HACKERS] Create collation incorrect error code

2012-05-31 Thread Magnus Hagander
/functions/newlocale.html) errno should be set. --  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] Create collation incorrect error code

2012-05-31 Thread Magnus Hagander
On Thu, May 31, 2012 at 8:16 PM, Tom Lane t...@sss.pgh.pa.us wrote: Magnus Hagander mag...@hagander.net writes: template1=# create collation nb_NO.utf8 (locale=nb_NO.utf8); ERROR:  could not create locale nb_no.utf8: Success What platform? D'uh, sorry. Ubuntu 12.04. --  Magnus Hagander

Re: [HACKERS] \conninfo and SSL

2012-05-31 Thread Magnus Hagander
are now connected to database postgres as user postgres. Well, \c creates a new connection, so that's not really an information command. It might not connect that trivially, depending on what authentication method you use. Including ssl info in \conninfo would be useful, I think. //Magnus -- Sent

Re: [HACKERS] pg_basebackup --xlog compatibility break

2012-05-29 Thread Magnus Hagander
On Tue, May 29, 2012 at 8:51 PM, Fujii Masao masao.fu...@gmail.com wrote: On Wed, May 30, 2012 at 2:03 AM, Robert Haas robertmh...@gmail.com wrote: On Mon, May 28, 2012 at 4:38 PM, Magnus Hagander mag...@hagander.net wrote: On Mon, May 28, 2012 at 10:11 PM, Peter Eisentraut pete...@gmx.net

Re: [HACKERS] pg_basebackup --xlog compatibility break

2012-05-28 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] pg_receivexlog stops upon server restart

2012-05-27 Thread Magnus Hagander
On Thursday, May 24, 2012, Thom Brown wrote: On 24 May 2012 13:37, Magnus Hagander mag...@hagander.net javascript:; wrote: On Thu, May 24, 2012 at 2:34 PM, Thom Brown t...@linux.comjavascript:; wrote: On 24 May 2012 13:05, Magnus Hagander mag...@hagander.netjavascript:; wrote: On Thu

Re: [HACKERS] pg_stat_statments queryid

2012-05-25 Thread Magnus Hagander
expose the value, users are going to do this sort of thing anyway, but will be far worse off due to using the query text or a hash thereof instead of the internal value. Exactly. --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers

Re: [HACKERS] pg_basebackup -x stream from the standby gets stuck

2012-05-25 Thread Magnus Hagander
On Thu, May 24, 2012 at 7:02 PM, Fujii Masao masao.fu...@gmail.com wrote: On Wed, May 23, 2012 at 9:25 PM, Magnus Hagander mag...@hagander.net wrote: While reviewing and cleaning this patch up a bit I noticed it actually broke pg_receivexlog in the renaming. Here is a new version of the patch

Re: [HACKERS] pg_stat_statements temporary file

2012-05-25 Thread Magnus Hagander
On Thu, May 24, 2012 at 2:19 PM, Magnus Hagander mag...@hagander.net wrote: On Thu, May 24, 2012 at 2:16 PM, Peter Geoghegan pe...@2ndquadrant.com wrote: On 24 May 2012 12:42, Magnus Hagander mag...@hagander.net wrote: What actually happens if it tries to repalloc() something huge? palloc

Re: [HACKERS] pg_stat_statements temporary file

2012-05-25 Thread Magnus Hagander
On Fri, May 25, 2012 at 4:09 PM, Tom Lane t...@sss.pgh.pa.us wrote: Peter Geoghegan pe...@2ndquadrant.com writes: On 25 May 2012 14:13, Magnus Hagander mag...@hagander.net wrote: I still think we should consider the placement of this file to not be in the global/ directory, but this is a quick

Re: [HACKERS] pg_stat_statements temporary file

2012-05-25 Thread Magnus Hagander
to make that decision separately from the stats file. Why would they want that? PSS only writes the tempfile on shutdown and reads it on startup. Unlike pgstats which reads and writes it all the time. --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- Sent via

[HACKERS] pg_stat_statements temporary file

2012-05-24 Thread Magnus Hagander
directory under the data directory that is always excluded from base backup, and store it there? That would also work for third party modules that core can never learn about... In general, should a contrib module really store data in the global/ directory? Seems pretty ugly to me... --  Magnus

[HACKERS] pg_stat_statments queryid

2012-05-24 Thread Magnus Hagander
Was there any actual reason why we didn't end up exposing queryid in the pg_stat_statements view? It would be highly useful when tracking changes over time. Right now I see people doing md5(query) to do that, which is a lot more ugly (and obviously uses more space and is slow, too). --  Magnus

Re: [HACKERS] LISTEN/NOTIFY Security and the docs

2012-05-24 Thread Magnus Hagander
that it's a broadcast, but it wouldn't hurt to have an extra one. Want to prepare a patch? --  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] pg_stat_statements temporary file

2012-05-24 Thread Magnus Hagander
On Thu, May 24, 2012 at 1:36 PM, Peter Geoghegan pe...@2ndquadrant.com wrote: On 24 May 2012 11:43, Magnus Hagander mag...@hagander.net wrote: In general, should a contrib module really store data in the global/ directory? Seems pretty ugly to me... I think the case could be made for moving

Re: [HACKERS] pg_receivexlog stops upon server restart

2012-05-24 Thread Magnus Hagander
On Thu, Apr 19, 2012 at 1:00 PM, Thom Brown t...@linux.com wrote: On 10 April 2012 21:07, Magnus Hagander mag...@hagander.net wrote: On Friday, April 6, 2012, Thom Brown wrote: Hi, I've tried out pg_receivexlog and have noticed that when restarting the cluster, pg_receivexlog gets cut off

[HACKERS] shared_preload_libraries path

2012-05-24 Thread Magnus Hagander
reimplementing OS functionality? --  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] pg_stat_statements temporary file

2012-05-24 Thread Magnus Hagander
On Thu, May 24, 2012 at 2:16 PM, Peter Geoghegan pe...@2ndquadrant.com wrote: On 24 May 2012 12:42, Magnus Hagander mag...@hagander.net wrote: What actually happens if it tries to repalloc() something huge? palloc will throw an elog(ERROR), and since this happens during postmaster startup

Re: [HACKERS] pg_receivexlog stops upon server restart

2012-05-24 Thread Magnus Hagander
On Thu, May 24, 2012 at 2:34 PM, Thom Brown t...@linux.com wrote: On 24 May 2012 13:05, Magnus Hagander mag...@hagander.net wrote: On Thu, Apr 19, 2012 at 1:00 PM, Thom Brown t...@linux.com wrote: On 10 April 2012 21:07, Magnus Hagander mag...@hagander.net wrote: On Friday, April 6, 2012, Thom

Re: [HACKERS] pg_stat_statments queryid

2012-05-24 Thread Magnus Hagander
On Thu, May 24, 2012 at 4:26 PM, Peter Geoghegan pe...@2ndquadrant.com wrote: On 24 May 2012 11:50, Magnus Hagander mag...@hagander.net wrote: Was there any actual reason why we didn't end up exposing queryid in the pg_stat_statements view? It would be highly useful when tracking changes over

Re: [HACKERS] shared_preload_libraries path

2012-05-24 Thread Magnus Hagander
On Thu, May 24, 2012 at 7:58 PM, Peter Eisentraut pete...@gmx.net wrote: On tor, 2012-05-24 at 14:09 +0200, Magnus Hagander wrote: Would i make sense to have a postgresql.conf parameter that would add to LD_LIBRARY_PATH when loading libraries from shared_preload_libraries (and other library

Re: [HACKERS] pg_basebackup -x stream from the standby gets stuck

2012-05-23 Thread Magnus Hagander
On Fri, Mar 2, 2012 at 2:26 PM, Magnus Hagander mag...@hagander.net wrote: On Tue, Feb 28, 2012 at 09:22, Fujii Masao masao.fu...@gmail.com wrote: On Thu, Feb 23, 2012 at 1:02 AM, Magnus Hagander mag...@hagander.net wrote: On Tue, Feb 7, 2012 at 12:30, Fujii Masao masao.fu...@gmail.com wrote

Re: [HACKERS] incorrect handling of the timeout in pg_receivexlog

2012-05-23 Thread Magnus Hagander
On Wed, May 23, 2012 at 8:11 PM, Fujii Masao masao.fu...@gmail.com wrote: On Tue, May 22, 2012 at 11:04 PM, Robert Haas robertmh...@gmail.com wrote: On Mon, May 14, 2012 at 2:24 PM, Fujii Masao masao.fu...@gmail.com wrote: On Fri, May 11, 2012 at 11:43 PM, Magnus Hagander mag...@hagander.net

Re: [HACKERS] Draft release notes complete

2012-05-15 Thread Magnus Hagander
On Fri, May 11, 2012 at 11:44 AM, Andrew Dunstan and...@dunslane.net wrote: On 05/11/2012 05:32 AM, Magnus Hagander wrote: But in the interest of actually being productive - what *is* the usecase for needing a 5 minute turnaround time? I don't buy the check what a patch looks like, because

Re: [HACKERS] Why do we still have commit_delay and commit_siblings?

2012-05-14 Thread Magnus Hagander
because no one has bothered to measure, that's not a reason to remove them. Another option might be to as a first step remove them from the .conf file or have a deprecated section, maybe? But if we do that, people aren't likely to use them anyway... --  Magnus Hagander  Me: http

Re: [HACKERS] pgstat wait timeout just got a lot more common on Windows

2012-05-12 Thread Magnus Hagander
On Fri, May 11, 2012 at 3:35 PM, Tom Lane t...@sss.pgh.pa.us wrote: Magnus Hagander mag...@hagander.net writes: On Thu, May 10, 2012 at 6:52 PM, Tom Lane t...@sss.pgh.pa.us wrote: Oh ... while hacking win32 PGSemaphoreLock I saw that it has a *seriously* nasty bug: it does not reset

Re: [HACKERS] Draft release notes complete

2012-05-11 Thread Magnus Hagander
On Thu, May 10, 2012 at 6:28 PM, Peter Eisentraut pete...@gmx.net wrote: On tor, 2012-05-10 at 17:31 +0200, Magnus Hagander wrote: If people want the main docs building more often that's not really a problem other than time - we just need to decouple it from the buildfarm and run a separate

Re: [HACKERS] Draft release notes complete

2012-05-11 Thread Magnus Hagander
On Fri, May 11, 2012 at 9:55 AM, Peter Eisentraut pete...@gmx.net wrote: On fre, 2012-05-11 at 09:26 +0200, Magnus Hagander wrote: On Thu, May 10, 2012 at 6:28 PM, Peter Eisentraut pete...@gmx.net wrote: On tor, 2012-05-10 at 17:31 +0200, Magnus Hagander wrote: If people want the main docs

Re: [HACKERS] pgstat wait timeout just got a lot more common on Windows

2012-05-11 Thread Magnus Hagander
that? Or am I misreading this completely? --  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] incorrect handling of the timeout in pg_receivexlog

2012-05-11 Thread Magnus Hagander
On Thursday, May 10, 2012, Fujii Masao wrote: On Thu, May 10, 2012 at 11:51 PM, Magnus Hagander mag...@hagander.netjavascript:; wrote: And taking this a step further - we *already* send these GUCs. Previous references to us not doing that were incorrect :-) So this should be a much

Re: [HACKERS] psql: server version check for \dO

2012-05-10 Thread Magnus Hagander
talking to servers older than 9.1, which don't have pg_collation. Simple patch for listCollations() attached. Indeed. Thanks, applied and backpatched to 9.1. --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql

Re: [HACKERS] Draft release notes complete

2012-05-10 Thread Magnus Hagander
: * Add libpq parameters for specifying the locations of server-side SSL files (Peter Eisentraut) Those are regular server side gucs and not libpq parameters. You certainly can't control the location of server-side files with libpq parameters.. --  Magnus Hagander  Me: http://www.hagander.net

Re: [HACKERS] Draft release notes complete

2012-05-10 Thread Magnus Hagander
- if the lock file is held by another run it exits gracefully). Of course, that's up to Magnus and Stefan. If we can make it do *just* the docs, we can certainly run it a bit more often. But we don't want to make it run the full set of checks more or less continously, since the machine is shared

Re: [HACKERS] incorrect handling of the timeout in pg_receivexlog

2012-05-10 Thread Magnus Hagander
, Fujii Masao masao.fu...@gmail.com wrote: On Wed, Feb 8, 2012 at 1:33 AM, Magnus Hagander mag...@hagander.net wrote: Will it break using pg_basebackup 9.2 on a 9.1 server, though? that would also be very useful in the scenario of the central server... No unless I'm missing something. Because

Re: [HACKERS] incorrect handling of the timeout in pg_receivexlog

2012-05-10 Thread Magnus Hagander
On Thu, May 10, 2012 at 3:04 PM, Magnus Hagander mag...@hagander.net wrote: Argh. This thread appears to have been forgotten - sorry about that. Given that we're taling about a potential protocol change, we really should resolve this before we wrap beta, no? Had a chat with Heikki about

Re: [HACKERS] incorrect handling of the timeout in pg_receivexlog

2012-05-10 Thread Magnus Hagander
On Thu, May 10, 2012 at 4:43 PM, Magnus Hagander mag...@hagander.net wrote: On Thu, May 10, 2012 at 3:04 PM, Magnus Hagander mag...@hagander.net wrote: Argh. This thread appears to have been forgotten - sorry about that. Given that we're taling about a potential protocol change, we really

Re: [HACKERS] pgstat wait timeout just got a lot more common on Windows

2012-05-10 Thread Magnus Hagander
the pgstat failures, because the stats collector's latch really shouldn't ever get set during normal regression test runs. So could there be something wrong in the other end, meaning the latch *does* get set? /Magnus

Re: [HACKERS] Draft release notes complete

2012-05-10 Thread Magnus Hagander
On May 10, 2012 5:24 PM, Bruce Momjian br...@momjian.us wrote: On Thu, May 10, 2012 at 12:49:51PM +0200, Magnus Hagander wrote: On Thu, May 10, 2012 at 12:43 PM, Andrew Dunstan and...@dunslane.net wrote: On 05/10/2012 01:29 AM, Tom Lane wrote: Bruce Momjianbr...@momjian.us

Re: [HACKERS] unexpected EOF messages

2012-05-07 Thread Magnus Hagander
On Thu, May 3, 2012 at 9:26 PM, Magnus Hagander mag...@hagander.net wrote: On Thu, May 3, 2012 at 7:48 PM, Tom Lane t...@sss.pgh.pa.us wrote: Magnus Hagander mag...@hagander.net writes: Heh - we already used ERRCODE_CONNECTION_FAILURE on the errors in copy.c. Since COPY can only happen when

Re: [HACKERS] unexpected EOF messages

2012-05-07 Thread Magnus Hagander
On Mon, May 7, 2012 at 5:15 PM, Tom Lane t...@sss.pgh.pa.us wrote: Magnus Hagander mag...@hagander.net writes: Any further suggestoins for which codes to use? If not, I think I'm going to commit the patch as I had it, because it's not any worse than what we had before (but fixes the annoying

Re: [HACKERS] unexpected EOF messages

2012-05-07 Thread Magnus Hagander
On Mon, May 7, 2012 at 7:18 PM, Robert Haas robertmh...@gmail.com wrote: On Mon, May 7, 2012 at 12:39 PM, Magnus Hagander mag...@hagander.net wrote: Makes sense, will change and commit. Since the following hunk is repeated 3x, maybe it should be stuffed into a function that is then called

Re: [HACKERS] Latch for the WAL writer - further reducing idle wake-ups.

2012-05-03 Thread Magnus Hagander
). Which it seems you both are doing now, so that makes it ok ;) --  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] unexpected EOF messages

2012-05-03 Thread Magnus Hagander
to push this off to the mythical let's improve the logging subsystem project that might eventually materialize if we're lucky? Meaning - would people object to such a switch? --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing

[HACKERS] ALTER DATABASE and datallowconn

2012-05-03 Thread Magnus Hagander
Is there a particular reason we don't have an ALTER DATABASE switch that controls the datallowconn, or is it just something missed out? --  Magnus Hagander  Me: http://www.hagander.net/  Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] unexpected EOF messages

2012-05-03 Thread Magnus Hagander
On Thu, May 3, 2012 at 2:31 PM, Simon Riggs si...@2ndquadrant.com wrote: On Thu, May 3, 2012 at 1:26 PM, Magnus Hagander mag...@hagander.net wrote: I had a request from a customer asking if we could make a switch to specifically disable the unexpected EOF message that fills lots of peoples

Re: [HACKERS] unexpected EOF messages

2012-05-03 Thread Magnus Hagander
- I guess my phrasing of those two questions was really stupid :) --  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] ALTER DATABASE and datallowconn

2012-05-03 Thread Magnus Hagander
On Thu, May 3, 2012 at 2:48 PM, Simon Riggs si...@2ndquadrant.com wrote: On Thu, May 3, 2012 at 1:31 PM, Magnus Hagander mag...@hagander.net wrote: Is there a particular reason we don't have an ALTER DATABASE switch that controls the datallowconn, or is it just something missed out? I think

Re: [HACKERS] ALTER DATABASE and datallowconn

2012-05-03 Thread Magnus Hagander
On Thu, May 3, 2012 at 4:13 PM, Tom Lane t...@sss.pgh.pa.us wrote: Magnus Hagander mag...@hagander.net writes: Is there a particular reason we don't have an ALTER DATABASE switch that controls the datallowconn, or is it just something missed out? It was never intended to be a user-accessible

Re: [HACKERS] ALTER DATABASE and datallowconn

2012-05-03 Thread Magnus Hagander
On Thu, May 3, 2012 at 4:26 PM, Tom Lane t...@sss.pgh.pa.us wrote: Magnus Hagander mag...@hagander.net writes: On Thu, May 3, 2012 at 4:13 PM, Tom Lane t...@sss.pgh.pa.us wrote: Magnus Hagander mag...@hagander.net writes: Is there a particular reason we don't have an ALTER DATABASE switch

Re: [HACKERS] unexpected EOF messages

2012-05-03 Thread Magnus Hagander
On Thu, May 3, 2012 at 2:46 PM, Kevin Grittner kevin.gritt...@wicourts.gov wrote: Magnus Hagander  wrote: Also, AFAIK we don't *have* a message type at this point (one of the things said mythical project wanted to look at), so the only thing we could really filter on would be the whole text

Re: [HACKERS] unexpected EOF messages

2012-05-03 Thread Magnus Hagander
On Thu, May 3, 2012 at 4:17 PM, Tom Lane t...@sss.pgh.pa.us wrote: Simon Riggs si...@2ndquadrant.com writes: On Thu, May 3, 2012 at 1:26 PM, Magnus Hagander mag...@hagander.net wrote: I had a request from a customer asking if we could make a switch to specifically disable the unexpected EOF

<    9   10   11   12   13   14   15   16   17   18   >