PgSql
in [SQL]
|
comment needs to be updated for HS? On Thu, May 13, 2010 at 4:20 AM, Robert Haas <robertmhaas(a)gmail.com> wrote: postmaster.c contains the following comment just above the definition of PMState. It appears to be out of date: * After reaching a consistent point in WAL redo, startup process signals * us again, and we switch to PM_RECOVERY_... 12 May 2010 23:39
[HACKERS] recovery getting interrupted is not so unusual as it used to be When firing up a properly shut down HS slave, I get: LOG: database system was interrupted while in recovery at log time 2010-05-12 20:35:24 EDT HINT: If this has occurred more than once some data might be corrupted and you might need to choose an earlier recovery target. But this is kind of an alarming hint ... 12 May 2010 21:26
[HACKERS] Stefan's bug (was: max_standby_delay considered harmful) On Wed, May 12, 2010 at 3:55 PM, Robert Haas <robertmhaas(a)gmail.com> wrote: I am wondering if we are not correctly handling the case where we get a shutdown request while we are still in the PM_STARTUP state. It looks like we might go ahead and switch to PM_RECOVERY and then PM_RECOVERY_CONSISTENT without ... 12 May 2010 21:26
[HACKERS] How to know killed by pg_terminate_backend Hi, If a backend killed by pg_terminate_backend(), the backend returns 57P01 which is identical to the one when it's killed by postmaster. Problem is, pgpool-II needs to trigger failover if postmaster goes down because apparently pgpool-II cannot use the PostgreSQL server anymore. On the otherhand, pg_termi... 12 May 2010 21:26
Bug-fix and new feature of pg_lesslogis released Until we have a tool to use streaming replication to actually archive backups, there's still a fairly large usecase for it... yes, pglesslog is for PITR. We have a client who keeps 3 days of log files a time for forensic reasons, and I doubt they're the only one. -- --... 12 May 2010 18:06
Bug-fix and new feature of pg_lesslogis released On Wed, 2010-05-12 at 23:09 +0200, Magnus Hagander wrote: On Wed, May 12, 2010 at 11:03 PM, Tom Lane <tgl(a)sss.pgh.pa.us> wrote: Bruce Momjian <bruce(a)momjian.us> writes: Yes, I would love to get this into /contrib for PG 9.1! How much are people really going to care about pg_lesslog now that ... 12 May 2010 18:06
Bug-fix and new feature of pg_lesslog is released Bruce Momjian <bruce(a)momjian.us> writes: Yes, I would love to get this into /contrib for PG 9.1! How much are people really going to care about pg_lesslog now that we've got streaming replication? There might be some small use-case still left, but it's hard to believe that it would be worth carrying it in con... 13 May 2010 02:53
pg_dump should not try CREATE OR REPLACE LANGUAGE < 9.0 Greg Sabino Mullane <greg(a)turnstep.com> writes: Subject line kind of says it all: LANGUAGE replacement was introduced in 9.0, but pg_dump is trying it on all versions. So? pg_dump output is never promised to load into older server versions. The proposed patch is quite wrong anyway, because it is looking ... 12 May 2010 16:59
[HACKERS] pg_dump should not try CREATE OR REPLACE LANGUAGE < 9.0 Subject line kind of says it all: LANGUAGE replacement was introduced in 9.0, but pg_dump is trying it on all versions. -- Greg Sabino Mullane greg(a)turnstep.com End Point Corporation PGP Key: 0x14964AC8 201005121537 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 ... 12 May 2010 15:51
pg_upgrade versus MSVC build scripts Excerpts from Tom Lane's message of mié may 12 14:07:13 -0400 2010: We could try to make this a supported build arrangement, but I'm inclined to think that a cleaner solution is to split out the loadable module as a separate contrib subdirectory. Thoughts? Do you mean contrib/pg_upgrade/somelib? If so, ... 12 May 2010 20:20 |