PgSql
in [SQL]
|
Partitioning syntax On Mon, Jan 18, 2010 at 3:55 AM, Takahiro Itagaki <itagaki.takahiro(a)oss.ntt.co.jp> wrote: Robert Haas <robertmhaas(a)gmail.com> wrote: A couple of preliminary comments on this: Thanks. The attached is rebased on HEAD, with additional documentation. This one, doesn't apply to head anymore... p... 15 Jul 2010 12:04
[HACKERS] DB crash SOS Hi all, I use 8.2 on a windows server 2008. Suddenly postgres crashed and I can not do anything. Strange things happend to postgres in the last few weeks. Once, there was so many postgres process, that I could not connect to it with pgAdmin3. It said that too many connections and I had to restart postgres. Than... 17 Jun 2010 05:41
[HACKERS] Debug message in RemoveOldXlogFiles Hi, In the following debug message in RemoveOldXlogFiles(), the variables "log" and "seg" don't indicate LSN, so we should use %u instead of %X? elog(DEBUG2, "removing WAL segments older than %X/%X", log, seg); I attached the patch to do so. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE ... 17 Jun 2010 03:32
[HACKERS] trace_recovery_messages Hi, We should make trace_recovery_messages available only when the WAL_DEBUG macro was defined? Currently it's always available, so the standby seems to call elog() too frequently. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center -- Sent via pgsql-ha... 17 Jun 2010 03:32
Explicit psqlrc Hi David, At a pdxpug gathering, we took a look at your patch to psql for supporting multiple -f's and put together some feedback: REVIEW: Patch: support multiple -f options https://commitfest.postgresql.org/action/patch_view?id=286 ==Submission review== Is the patch in context diff format? yes Does i... 22 Jul 2010 09:12
[PATCH] elimination of code duplication in DefineOpFamily() I have not been able to find any comments or discussion on this patch. Contents and Purpose: ================ This patch removes duplicate code in opclasscmds.c. It removes the duplicate code from DefineOpFamily by calling CreateOpFamily. No new regression test or documentation are included with the patch. ... 16 Jul 2010 00:10
streaming replication breaks horribly if master crashes "Kevin Grittner" <Kevin.Grittner(a)wicourts.gov> wrote: It sounds like it behaves just fine except for not detecting a broken connection. Of course I meant in terms of the slave's attempts at retrieving more WAL, not in terms of it applying a second time line. TCP keepalive timeouts don't help with that p... 16 Jun 2010 19:56
ANNOUNCE list > On Wed, 2010-06-16 at 10:34 -0700, Josh Berkus wrote: Why is there significant delay on important posts, yet some posts go almost straight though? Every time I use Announce my posts are delayed for about 4-5 days. Why do some posts jump the queue, appearing to imply the moderator is... 17 Jun 2010 03:32
streaming replication breaks horribly if master crashes Robert Haas <robertmhaas(a)gmail.com> wrote: So, obviously at this point my slave database is corrupted beyond repair due to nothing more than an unexpected crash on the master. Certainly that's true for resuming replication. From your description it sounds as though the slave would be usable for purposes... 17 Jun 2010 13:25
streaming replication breaks horribly if mastercrashes On Wed, 2010-06-16 at 15:47 -0400, Robert Haas wrote: So, obviously at this point my slave database is corrupted beyond repair due to nothing more than an unexpected crash on the master. That's bad. What is worse is that the system only detected the corruption because the slave had crossed an xlog segmen... 16 Jun 2010 16:36 |