pclark's blog

 

pclark's picture

PostgreSQL Kung-Fu: Migrating between major versions.

Has this happened to you?  You're called in to sandbox the newest version of xTuple for a customer.  "Piece of cake" you think to yourself, "I'll buzz in and buzz out, 30 minutes tops".

"ERROR: syntax error at or near "(" at character 578"

Arrrrgh!  We'll you try again, maybe even open up the update package and poke around looking for a syntax erorr.  "I know this worked on my laptop when I tried it at home..."  Deep breath, keep your cool... We all know that the 10 minute jobs are the ones that end up taking days and years off of our lives.  Read more »

pclark's picture

Simple Postgres Server Monitoring Script for Linux and OSX

Nagios, Splunk, SNMP are various monitoring tools that can alert you to the status of connectivity to your SQL server.  While I would like to employ these tools to monitor our network, I find that I really just want a tool to tell me 'Hey!  Go check the server!  It ain't working because of x,y,z...'.  Checkpg.sh is such a tool. Read more »

pclark's picture

Remote Connection Fun with Tunneling!

Oftentimes, we find ourselves not able to be On-Site or otherwise physically On-Console of the server we need to work on.  If time is of the essence the administrator with command line savvy can conquer just about any remote administration or troubleshooting need. How does one acheive this level of connectivity?  Where can I get some of that? Well, look no further than 'terminal' and 'ssh'. Read more »

pclark's picture

Running the xTuple Installer on x86_64 Fedora 11

So, you have a fancy new Fedora 11 x86_64 workstation like me?  Well, there's some special consideration you need to give your setup to get our Installer working correctly.

Check out http://www.xtuple.org/xTuple-3.3.0-Fedora-11-x86_64-How-To

pclark's picture

My brain is full... News from the labs.

One of my favorite things EVER (besides a list of 1000 other favorite things ever) are 'The Far Side' comics by Gary Larson.  For those of us fortunate enough to remember, or to have owned the collected works of the strips, have no problem remembering the artwork for "Mr. Osborne, may I be excused? My brain is full.". 

Well, assume that I am in that comic - I'm Mr. Osborne... What do I tell the kid? What? What? What! Poor Brian is about to spew his brain gunk all over the class!  WHAT DO YOU SAY MR. OSBORNE?!  Read more »

pclark's picture

Got < 50µs Latency? Solid State Storage

Recently, I've had the opportunity to install a solid state storage device for a customer. (Think of your USB thumb drive, or the card you shove into your digital camera, only this thing plugs into your server's 4x PCI slot.)

At first glance, the thing is fast, really really really fast. How fast? How about +500MB/s write speeds?

That's turning it way past 11, folks... Read more »

 

Syndicate content