445 reputation
317
bio website
location
age
visits member for 2 years, 4 months
seen Apr 15 at 17:31

Mar
28
awarded  Notable Question
Dec
24
asked How can I prevent the proliferation of stale/false RabbitMQ connection objects in the management plugin without upgrading the server?
Dec
21
awarded  Yearling
Aug
20
awarded  Popular Question
Jun
24
awarded  Popular Question
May
27
awarded  Popular Question
Apr
29
awarded  Popular Question
Apr
24
comment “Never take kernel updates” — Any truth to this?
Here's the referenced Linus story. It's an interesting look into FOSS project administration at scale: developers.slashdot.org/story/12/12/29/018234/…
Apr
18
awarded  Popular Question
Mar
22
awarded  Popular Question
Dec
21
awarded  Yearling
Dec
18
awarded  Popular Question
Nov
19
comment How can I force a merge of all WAL files in pg_xlog back into my base “data” directory?
Are you saying that when I issue the stop command to the database server, all of the WALs in the pg_xlog directory get applied to the base data set? If so, why aren't they then deleted? The same is true for CHECKPOINT commands; I can issue one, and the WALs contained in pg_xlog shift by one sometimes (the oldest vanishes and a new one is created), but the volume stays the same, as per checkpoint_segments.
Nov
19
answered Puppet 2.7: Can I set up a puppet:// fileserver with Apache on a non-puppetmaster?
Nov
19
comment How can I force a merge of all WAL files in pg_xlog back into my base “data” directory?
Ideally, the procedure I am looking for could be run on a server post-restoration of a filesystem level backup, and would flush WAL segments shipped with the backup, as well.
Nov
19
revised How can I force a merge of all WAL files in pg_xlog back into my base “data” directory?
added 40 characters in body
Nov
19
comment How can I force a merge of all WAL files in pg_xlog back into my base “data” directory?
Your corrections are accurate. That is what we do; a filesystem-level backup, preceeded by pg_start_backup, and followed by pg_stop_backup. I know that a few WALs are necessary; at least the one closed when pg_stop_backup is called; that's why I am asking for a "near-zero" WAL volume, rather than a totally empty pg_xlog directory.
Nov
19
asked How can I force a merge of all WAL files in pg_xlog back into my base “data” directory?
Oct
31
accepted Is there a way to centrally manage Dropbox/centrally disable LAN sync for all Dropbox clients on a Windows LAN?
Oct
31
accepted How to connect a VM running on an ESXi host to that host via a VMKernel NIC?