1,286 reputation
712
bio website amd.co.at
location Vienna, Austria
age 30
visits member for 5 years, 2 months
seen Aug 13 at 9:45

  • Sysadmin gone architecture/team lead
  • kink for running large Web Projects
  • PostgreSQL evangelist
  • Scrum Master
  • also interested in Product development
  • Likes kitties.


    Working on pganalyze these days - a great PostgreSQL performance monitoring tool!


  • Mar
    24
    comment I have multiple PostgreSQL servers installed. How do I disable auto boot for older server?
    The packages from the PostgreSQL Debian packaging team are identical to the ones from Debian. You should use the pg_*cluster infrastructure instead of hacking up your own sysv init start scripts.
    Nov
    28
    comment Martian source in log of machine1 after ssh-DNAT to virtual machine located on machine2 (machine1 and machine2 xover connected)
    as well as tcpdump -p -i br1 -n -s0 for the nonworking packets and upload the dumps to cloudshark.org
    Nov
    28
    comment Martian source in log of machine1 after ssh-DNAT to virtual machine located on machine2 (machine1 and machine2 xover connected)
    ip neigh ls as well as ip route get <ip> for the nonworking IP addresses?
    Jan
    8
    comment Which SSD and controller for Postgre SQL database?
    Thanks for sharing your experiences, seeing OCZ coming on top of SSD reliability certainly raises a few eyebrows ;)
    Apr
    3
    comment rsync and --remove-source-files
    A much more elegant solution with current find versions would be: find /path/to/directory -type d -empty -delete
    Jun
    4
    comment Most Appropriate log-structured file system to use with Linux / SSD?
    Yes, modern SSDs targeted for server/desktop use spread writes quite fine. Just make sure that you reduce the amount of "unncessary" writes, if you're concerned about device wear. Disabling atime updates, as suggested above, is a good first start if you don't run applications which depend on it's presence.
    Jun
    2
    comment Naming Conventions
    Since we used either OpenVZ or VMware ESX on all of our physical servers, those had according names. The few machines without hypervisor we had, had very specific hardware catered for a single task. E.g. the backup machine had room for 16 3.5" disks and would be reinstalled if it were to be repurposed, and this would've included assigning a new hostname. And the virtual servers all had very specific hostnames and often served only a single service/task (which was reflected by the hostname).
    May
    31
    comment What's the most efficient way of taking backup snapshots of a mysql database over the internet?
    The more I think of it the more I'm convinced that your best bet is plain rsync with --compress. Both gzip and rsync can produce completely different output when the input is shifted (far enough into their respective blocksize).<br>I don't know how the pattern search algorithms in rsync exactly work, if you find anything on this, please do tell ;).
    May
    31
    comment Does orientation affect hard drive lifespan?
    There are reference server designs (mostly 4U+, but with 2.5" disks also 2U) which mount disk drives sideways, so this should be a non-issue. But as you already said, to get meaningful results you'd have to monitor failures in large environments like Amazon S3/EC2, Google or CERN.