Aaron Parecki

  • Articles
  • Notes
  • Photos

#postgres

  • Monitoring CPU and memory usage from Postgres

    Let's say you have a cluster of Postgres database servers and you want a way to easily monitor their CPU and memory usage. You could install any of the system monitoring daemons like Nagios, Collectd, Munin, etc, but that means opening up another port in your firewall, and maintaning another running process. If all you're after is basic info like CPU and memory usage, there's an easier way!
    continue reading...
    1 mention
    #postgres #ops #linux
    Thu, Feb 19, 2015 12:30pm -08:00
  • Don't use Postgres's currval() - Wordeology (wordeology.com)
    #postgres
    Fri, Feb 6, 2015 4:38pm -08:00
  • pgcli (pgcli.com)
    Pgcli is a command line interface for Postgres with auto-completion and syntax highlighting.
    #postgres #resources #linux #database
    Tue, Jan 6, 2015 3:10pm -08:00
  • torodb/torodb (github.com)
    ToroDB is an open source, document-oriented, JSON database that runs on top of PostgreSQL.... It speaks natively the MongoDB protocol, meaning that it can be used with any mongo-compatible client.
    #postgres #mongodb #database #db
    Wed, Oct 29, 2014 8:46am -07:00
  • Querying Time Series in Postgresql (no0p.github.io)
    #postgres #stats
    Wed, May 28, 2014 7:56am -07:00
  • Simple API with Nginx and PostgreSQL (rny.io)
    #api #nginx #postgres
    Fri, Jul 26, 2013 10:11am -07:00
  • Converting MySQL to PostgreSQL (en.wikibooks.org)
    #convert #database #mysql #postgres #tips #tutorial
    Sun, Feb 10, 2013 3:17pm -08:00
  • Taps for Easy Database Transfers (adam.heroku.com)
    #database #mysql #postgres #sqlite #taps #tools #utilities
    Sun, Feb 10, 2013 3:16pm -08:00
  • Stupid PostgreSQL Tricks: Writable Views (legitimatesounding.com)
    #database #db #postgres
    Tue, Oct 16, 2012 4:13pm -07:00
  • Window Functions (www.postgresql.org)
    #database #documentation #postgres #sql #tutorial
    Sat, Aug 25, 2012 9:56am -07:00
  • PostgreSQL when it is not your job (reinout.vanrees.org)
    #database #db #postgres #servers #sysadmin #tips
    Wed, Jun 6, 2012 10:17am -07:00
next

Hi, I'm Aaron Parecki, Senior Security Architect at Okta, and co-founder of IndieWebCamp. I maintain oauth.net, write and consult about OAuth, and participate in the OAuth Working Group at the IETF. I also help people learn about video production and livestreaming and dabble in product design.

I've been tracking my location since 2008 and I wrote 100 songs in 100 days. I've spoken at conferences around the world about owning your data, OAuth, quantified self, and explained why R is a vowel. Read more.

  • Security Architect at Okta
  • IndieWebCamp Founder
  • OAuth WG Member

  • 🎥 YouTube Tutorials and Reviews
  • 🏠 We're building a triplex!
  • ⭐️ Life Stack
  • ⚙️ Home Automation
  • All
  • Articles
  • Bookmarks
  • Notes
  • Photos
  • Replies
  • Reviews
  • Trips
  • Videos
  • Contact
© 1999-2023 by Aaron Parecki. Powered by p3k. This site supports Webmention.
Except where otherwise noted, text content on this site is licensed under a Creative Commons Attribution 3.0 License.
IndieWebCamp Microformats Webmention W3C HTML5 Creative Commons
WeChat ID
aaronpk_tv