FAQ

Search Discussions

218 discussions - 3,118 posts

  • OK, we have a proposal on the table to bump some patches from this CommitFest to free up more committer resources, particularly Tom, to work on Hot Standby and Streaming Replication and attempt to ...
    Robert HaasRobert Haas
    Jan 8, 2010 at 1:57 am
    Feb 8, 2010 at 8:21 pm
  • There has been periodic discussion here about allowing psql to deal with multiple sessions, or possibly creating another tool to allow this sort of test. Is anyone working on this? It's very soon ...
    Kevin GrittnerKevin Grittner
    Jan 2, 2010 at 2:01 am
    Feb 13, 2010 at 4:39 pm
  • Tim Bunce's recent patch has been mangled apparently by the list archives. He sent it as an attachment, and that's how I have it in my mailbox, so why isn't it appearing as such in the web archive so ...
    Andrew DunstanAndrew Dunstan
    Jan 8, 2010 at 11:51 pm
    Feb 13, 2010 at 12:35 pm
  • Pavel, My review of your listagg patch. Submission Review ----------------- * The diff is a context diff and applies cleanly to HEAD (with just two hunks offset by 2 lines each). * There is ...
    David E. WheelerDavid E. Wheeler
    Jan 22, 2010 at 7:14 pm
    Feb 1, 2010 at 3:40 pm
  • Hi, I read the thread "Our CLUSTER implementation is pessimal" http://archives.postgresql.org/pgsql-hackers/2008-08/msg01371.php . I would like to try/integrate that patch as we use CLUSTER a lot on ...
    Leonardo FLeonardo F
    Jan 15, 2010 at 11:45 am
    Oct 8, 2010 at 8:20 am
  • I've gone through the patch in detail now. Here's my list of remaining issues: * If there's no WAL to send, walsender doesn't notice if the client has closed connection already. This is the issue ...
    Heikki LinnakangasHeikki Linnakangas
    Jan 8, 2010 at 9:16 pm
    Mar 23, 2010 at 2:29 am
  • Here is a small patch that changes the error message duplicate key value violates unique constraint "%s" into duplicate key value violates primary key "%s" when the constraint is in fact a primary ...
    Peter EisentrautPeter Eisentraut
    Jan 21, 2010 at 8:30 pm
    Jan 25, 2010 at 6:37 pm
  • Hey -hackers, I whipped up a quick patch for supporting some of the common mysql- based "meta" commands; this is different than some things which have been discussed in the past, in that it provides ...
    David ChristensenDavid Christensen
    Jan 19, 2010 at 7:02 pm
    Feb 5, 2010 at 5:40 pm
  • With the release of Postgres 9.0, should we consider changing the default for 'standard_conforming_strings'? -- Bruce Momjian <bruce@momjian.us http://momjian.us EnterpriseDB http://enterprisedb.com ...
    Bruce MomjianBruce Momjian
    Jan 29, 2010 at 7:52 pm
    Feb 4, 2010 at 5:28 pm
  • In an attempt to pre-empt the normally drawn-out discussions about what the next version of PostgreSQL will be numbered. the core team have discussed the issue and following a lenghty debate lasting ...
    Dave PageDave Page
    Jan 21, 2010 at 9:37 am
    Jan 24, 2010 at 10:30 pm
  • Hackers, I've posted a [plan] to implement PGAN][], a CPAN for PostgreSQL extensions. I've tried to closely follow the [CPAN philosophy][] to come up with a plan that requires a minimum-work ...
    David E. WheelerDavid E. Wheeler
    Jan 7, 2010 at 8:07 pm
    Jan 13, 2010 at 8:45 pm
  • I realize this is a very platform-specific thing, but should we consider setting the value of /proc/<pid /oom_adj when running on linux? See: ...
    Magnus HaganderMagnus Hagander
    Jan 4, 2010 at 3:39 pm
    Jan 11, 2010 at 6:43 pm
  • I've a .git/info/exclude file I pulled from a link on the dev wiki. Some of the changes I'm making create new files that ought to be added to the excluded files. I can easily add them to my ...
    Tim BunceTim Bunce
    Jan 7, 2010 at 10:16 pm
    Jan 14, 2010 at 6:15 pm
  • Looking at the latest streaming replication patch, I don't much like the signaling between WAL sender and postmaster. It seems complicated, and as a rule of thumb postmaster shouldn't be accessing ...
    Heikki LinnakangasHeikki Linnakangas
    Jan 5, 2010 at 2:08 pm
    Jan 8, 2010 at 6:59 pm
  • This is the third of the patches to be split out from the former 'plperl feature patch 1'. Changes in this patch: - Added plperl.on_perl_init GUC for DBA use (PGC_SIGHUP) SPI functions are not ...
    Tim BunceTim Bunce
    Jan 14, 2010 at 10:11 pm
    Jan 28, 2010 at 4:03 pm
  • This is an update the fourth of the patches to be split out from the former 'plperl feature patch 1'. Changes in this patch: - Adds plperl.on_trusted_init and plperl.on_untrusted_init GUCs ...
    Tim BunceTim Bunce
    Jan 30, 2010 at 3:50 pm
    Feb 12, 2010 at 3:24 pm
  • -hackers, In the spirit of small, but hopefully useful interface improvement patches, enclosed for your review is a patch for providing psql with a \whoami command (maybe a better name is \conninfo ...
    David ChristensenDavid Christensen
    Jan 26, 2010 at 11:24 pm
    Jul 23, 2010 at 2:58 pm
  • We seem to have a large portion of the buildfarm red from the ECPG tests, presumably due to the recently applied out-of-scope cursor patches. cheers andrew
    Andrew DunstanAndrew Dunstan
    Jan 29, 2010 at 4:14 am
    Feb 27, 2010 at 9:56 pm
  • Hi, When I configured a cascaded standby (i.e, made the additional standby server connect to the standby), I got the following errors, and a cascaded standby didn't start replication. ERROR: timeline ...
    Fujii MasaoFujii Masao
    Jan 18, 2010 at 5:20 am
    Mar 17, 2010 at 1:05 am
  • Hi Robert, I've also spent some time reviewing this patch since it is a pre-requisite to the KNNGiST patch. I did have a much more comprehensive list of suggestions, but it seems you've managed to ...
    Mark Cave-AylandMark Cave-Ayland
    Jan 29, 2010 at 2:00 pm
    Feb 10, 2010 at 7:32 pm
  • Conflict resolution improvements are important to include in this release, as discussed many times. Proposal given here http://archives.postgresql.org/pgsql-hackers/2009-12/msg01175.php presents a ...
    Simon RiggsSimon Riggs
    Jan 28, 2010 at 9:49 pm
    Feb 3, 2010 at 9:52 am
  • Hi! I poked around a little at pg_standby because of some 'cp: file does not exist' errors that were cropping up as pg_standby searched around for .history files. I added a stat that still outputs ...
    Selena DeckelmannSelena Deckelmann
    Jan 25, 2010 at 5:46 pm
    Jan 28, 2010 at 1:16 am
  • Maybe I'm hallucinating and someone could check this in their environment, but it appears to me that the Git repository is missing parts of two non-recent commits. See attached patch.
    Peter EisentrautPeter Eisentraut
    Jan 17, 2010 at 7:25 pm
    Jan 21, 2010 at 4:29 pm
  • I'm trying to figure out why streaming replication doesn't work on win32. Here is what I have so far: It starts up fine, and outputs: LOG: starting archive recovery LOG: standby_mode = 'on' LOG: ...
    Magnus HaganderMagnus Hagander
    Jan 17, 2010 at 1:58 pm
    Feb 16, 2010 at 7:27 pm
  • The last item on my list before close is making VACUUM FULL and Hot Standby play nicely together. The options to do this were and still are: (1) Add WAL messages for non-transactional relcache ...
    Simon RiggsSimon Riggs
    Jan 30, 2010 at 7:33 pm
    Feb 3, 2010 at 5:31 pm
  • WTF? Simon, this seems to be getting way way beyond anything the community has agreed to. Particularly, inventing GUCs is not something to be doing without consensus. regards, tom lane
    Tom LaneTom Lane
    Jan 29, 2010 at 7:04 pm
    Mar 28, 2010 at 8:56 am
  • There has been some more discussion lately of problems caused by contrib/xml2. http://archives.postgresql.org/pgsql-bugs/2010-01/msg00251.php ...
    Robert HaasRobert Haas
    Jan 28, 2010 at 8:56 pm
    Mar 1, 2010 at 1:53 pm
  • I've now committed streaming replication. I moved the files around a bit, and put the walreceiver/walsender stuff in a new src/backend/replication subdirectory. There's enough stuff there already to ...
    Heikki LinnakangasHeikki Linnakangas
    Jan 15, 2010 at 9:19 am
    Jan 16, 2010 at 3:22 am
  • I've been working on my demo, and I'm discovering that due to the connection from the walsender and walreceiver, "smart" shutdown from pg_ctl doesn't work if replication is active. This seems worth ...
    Josh BerkusJosh Berkus
    Jan 20, 2010 at 11:04 pm
    Mar 4, 2010 at 5:43 pm
  • Over the past few months, I've been attempting to keep tracks of which postings on pgsql-bugs have not gotten a response and to respond to those where I have a clue what the issue might be. However, ...
    Robert HaasRobert Haas
    Jan 6, 2010 at 8:15 pm
    Apr 20, 2010 at 12:31 am
  • This is the final plperl patch in the series from me. Changes in this patch: - Moved internal functions out of main:: namespace into PostgreSQL::InServer and PostgreSQL::InServer::safe - Restructured ...
    Tim BunceTim Bunce
    Jan 15, 2010 at 4:02 am
    Feb 14, 2010 at 12:38 am
  • I finally put enough code together and it has some chance it could work. It's time to test it. Now I'm going to test it quite frequently. My code is written and compiled in my ~/. Then it is moved ...
    Ivan Sergio BorgonovoIvan Sergio Borgonovo
    Jan 30, 2010 at 10:57 am
    Feb 1, 2010 at 11:57 pm
  • I'm having a hard time trying to understand how everything should be done in C extensions. Now I'm trying to understand how and when I should accept/return cstring vs text and if and how I should ...
    Ivan Sergio BorgonovoIvan Sergio Borgonovo
    Jan 25, 2010 at 8:12 pm
    Jan 27, 2010 at 10:46 pm
  • We need to calculate a more accurate time since WAL arrived to make max_standby_delay sensible in all cases. Difficult to know exactly when to record new timestamps for received WAL. So, proposal ...
    Simon RiggsSimon Riggs
    Jan 15, 2010 at 6:19 pm
    Jan 18, 2010 at 5:31 pm
  • Folks, Please find enclosed a patch which adds tab completion for DO blocks. Thanks to Andrew Gierth and Stefan Kaltenbrunner for help putting it together :) Cheers, David. -- David Fetter ...
    David FetterDavid Fetter
    Jan 2, 2010 at 9:11 pm
    Feb 15, 2010 at 2:57 am
  • Why do we have a parameter called "default_do_language" when we don't have a parameter called "default_language"? This is remarkably inconsistent. Why the difference? 5 years from now, whatever ...
    Simon RiggsSimon Riggs
    Jan 24, 2010 at 8:33 pm
    Jan 26, 2010 at 6:40 am
  • I didn't get any significant feedback from the earlier draft so here's the finished 'feature patch 1' for plperl. (This builds on my earlier plperl refactoring patch, and the follow-on ppport.h ...
    Tim BunceTim Bunce
    Jan 8, 2010 at 3:01 pm
    Jan 13, 2010 at 11:30 am
  • I have a question regarding true serializability and predicate locking. There's some context on the wiki page: http://wiki.postgresql.org/wiki/Serializable under the heading "Predicate Locking". If ...
    Jeff DavisJeff Davis
    Jan 5, 2010 at 7:14 pm
    Jan 8, 2010 at 5:53 pm
  • Here is a revised partitioning syntax patch. It implements only syntax and on-disk structure mentioned below: Table Partitioning#Syntax http://wiki.postgresql.org/wiki/Table_partitioning#Syntax Table ...
    Takahiro ItagakiTakahiro Itagaki
    Jan 14, 2010 at 9:12 am
    Jul 15, 2010 at 3:35 pm
  • It is possible to get an invalid byte sequence into a text field via pl, in this case pl/perl : ---8<------8<------8<------8<------8<------8<--- CREATE TABLE utf_test ( id serial PRIMARY KEY, data ...
    Hannu KrosingHannu Krosing
    Jan 2, 2010 at 10:22 pm
    Mar 12, 2010 at 3:25 pm
  • Hello, O.k. I know there is no way we will hit this for 8.5. So this is more of a future discussion more than anything. We at CMD have been working diligently on our next version of Mammoth ...
    Joshua D. DrakeJoshua D. Drake
    Jan 15, 2010 at 11:29 pm
    Feb 5, 2010 at 11:40 pm
  • Marko, Submission Review ----------------- *) patch applies clean to HEADwever *) applied tests ran ok *) there is some documentation adjustments in the patch. possibly a little underweight, but ...
    Merlin MoncureMerlin Moncure
    Jan 26, 2010 at 2:13 pm
    Feb 3, 2010 at 11:05 pm
  • Imagine this scenario: 1. Master is up and running, standby is connected and streaming happily 2. Network goes down, connection is broken. 3. Standby falls behind a lot. Old WAL files that the ...
    Heikki LinnakangasHeikki Linnakangas
    Jan 14, 2010 at 2:15 pm
    Jan 21, 2010 at 10:15 pm
  • Hi, If the primary has a connected standby, the WAL files required for the standby cannot be deleted. So if it has fallen too far behind for some reasons, a disk full failure might occur on the ...
    Fujii MasaoFujii Masao
    Jan 21, 2010 at 1:44 pm
    Apr 20, 2010 at 11:15 am
  • Hi, In relation to the functions added recently, I found an annoying problem; pg_xlogfile_name(pg_last_xlog_receive/replay_location()) might report the wrong name because pg_xlogfile_name() always ...
    Fujii MasaoFujii Masao
    Jan 19, 2010 at 9:35 am
    Mar 5, 2010 at 12:20 am
  • this broke the build on spoonbill: http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=spoonbill&dt=2010-01-05%2015:05:08 manually executing the command shows that the perl process eats more than ...
    Stefan KaltenbrunnerStefan Kaltenbrunner
    Jan 5, 2010 at 5:25 pm
    Jan 5, 2010 at 8:48 pm
  • The attached patch supports new keyword 'replication' on .pgpass file. This keyword is used to specify the password for the standby server to connect to the primary server. Without this keyword, ...
    Fujii MasaoFujii Masao
    Jan 6, 2010 at 3:54 am
    Jan 7, 2010 at 3:09 pm
  • Was there a designed-in reason not to have psql tab completion for COMMIT/ROLLBACK PREPARED ...? It does complete the "PREPARED" but not the transaction identifiers. Maybe it's not a common use case, ...
    Peter EisentrautPeter Eisentraut
    Jan 23, 2010 at 5:09 pm
    Jan 26, 2010 at 7:05 am
  • This is the second of the patches to be split out from the former 'plperl feature patch 1'. Changes in this patch: - Allow (ineffective) use of 'require' in plperl If the required module is not ...
    Tim BunceTim Bunce
    Jan 14, 2010 at 4:07 pm
    Jan 25, 2010 at 8:10 pm
  • When trying to build plpython on win64, it fails because ssize_t is defined differently. PostgreSQL has it as typedef long ssize_t; And python has it as: typedef __int64 ssize_t; The postgresql ...
    Magnus HaganderMagnus Hagander
    Jan 2, 2010 at 3:07 pm
    Jan 3, 2010 at 12:38 am
Group Navigation
period‹ prev | Jan 2010 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions218
posts3,118
users152
websitepostgresql.org...
irc#postgresql

152 users for January 2010

Tom Lane: 440 posts Robert Haas: 306 posts Magnus Hagander: 144 posts Simon Riggs: 138 posts Kevin Grittner: 122 posts Andrew Dunstan: 118 posts Heikki Linnakangas: 112 posts Peter Eisentraut: 110 posts Bruce Momjian: 87 posts Pavel Stehule: 84 posts David E. Wheeler: 77 posts Fujii Masao: 73 posts Josh Berkus: 63 posts Dimitri Fontaine: 62 posts Alvaro Herrera: 60 posts Tim Bunce: 57 posts Boszormenyi Zoltan: 51 posts Greg Smith: 50 posts Stefan Kaltenbrunner: 47 posts Takahiro Itagaki: 41 posts
show more
Archives