Reputation
480
Top tag
Next privilege 500 Rep.
Access review queues
Badges
7 22
Impact
~37k people reached

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?
Oct
31
accepted Could SpinRite possibly be messing up my laptop hard drives?
Oct
31
comment Is there a way to centrally manage Dropbox/centrally disable LAN sync for all Dropbox clients on a Windows LAN?
That's not a problem, since nobody uses the LAN sync functionality. That functionality is only useful if you have two workstations on the same LAN with your dropbox installed on both. Management is okay with it, mostly because the netadmins have a fair amount of clout.
Oct
31
asked Is there a way to centrally manage Dropbox/centrally disable LAN sync for all Dropbox clients on a Windows LAN?
Oct
24
asked Per-application library paths on CentOS
Oct
15
comment Is it worth hiring a hacker to perform some penetration testing on my servers?
This is one of the most durable solutions yet proposed: Nessus, Splunk, and some general "wierd behavior" monitor like Zenoss when properly configured are your best friends. However, a lot of people assume they are "drop in" solutions, which they aren't. There's a very high setup overhead, and, once done, a very high security yield.
Sep
30
comment How can I block a specific type of DDoS attack?
+1 for best answer. This isn't any more "right" than making iptables rules manually, but fail2ban is much easier to admin. Just make sure you don't ban your own logins via SSH...this happened to me (forgot my password before Monday coffee...it was a bad day).
Sep
30
comment How does Windows 2008 R2 run 32-bit applications?
For more info, see en.wikipedia.org/wiki/WoW64. WOW64 does a good deal more than just translating 32-bit instructions into 64-bit ones; it's a very large and complex compatibility layer that interacts with a lot of different parts of the OS.
Sep
29
comment Why can't you mount a windows share in linux and make it writable?
If you've tried as much stuff on the Linux side as you can, I'd look at the Windows side. Create a dummy account on the windows box with promiscuous perms on the share, and have Linux connect using that account's credentials. Windows handles the administrator account differently in a lot of ways; this might be a symptom of that.
Sep
27
comment Does the Intel DX79TO motherboard support x8 devices (SAS HBAs) on PCIe x16 slots?
Verified on this particular board: both x16 slots will work with x8 cards.
Sep
27
accepted Does the Intel DX79TO motherboard support x8 devices (SAS HBAs) on PCIe x16 slots?
Sep
27
accepted How to use AD/GPO/Print Services to “push out” a new printer driver to replace a broken one? How did my server get a broken driver?