Skip to content

Category Archives: sysadmin

ptop - meeting summary from last nights pdxpug

Friday, November 16, 2007

Last night’s meeting was about ptop and Mark Wong’s efforts to make an interactive, command-line tool for monitoring the current status of a PostgreSQL database.
For our meeting, Mark set up a test operating system on a USB drive, and bravely demo’d his new software.
Mark got the idea for ptop a few months ago, and went […]

Also filed in pdxpug, postgresql, user groups | | Comments Off

psql and file, CSV exports

Saturday, October 13, 2007

Gabrielle and I met to talk about some projects today. She brought up a couple questions that were raised about differences between MySQL and PostgreSQL syntax for data export.
She showed me \pset fieldsep and \pset format for controlling interactive output from SELECTS (see psql documentation). You might say: \pset fieldsep , (although that […]

Also filed in postgresql | | Comments Off

non-profits and systems administration

Saturday, August 11, 2007

Wouldn’t it be great if the non-profit world could embrace free software? In my head, I’ve seen a giant Venn diagram labeled “VALUES” with Open Source/Free Software overlapping significantly with the of non-profits. Here’s a small one:
I think that non-profits are certainly not ignorant of open source. In Oregon, our legislators tried to pass […]

Also filed in | | Comments Off