PostgreSQL

 

Syndicate content
matherton's picture

Go Live: Are We Ready?

Posted Fri, 12/30/2011 - 09:13 by matherton

The clients I work with frequently ask me this question once we are deep into the implementation.  I never give a straight answer.  You see, I believe you should know if you are ready and with the right preparation you will.  So let's take a high level look at what must happen before you will be confident enough to go live.

Initial Training Read more »

pclark's picture

Batten down the Hatches!!! Encrypting your PostgreSQL Traffic with OpenSSL.

Posted Wed, 04/27/2011 - 14:15 by pclark

It's 3AM... do you know what your server is doing?

You probably don't know. If you do know, you need to do something other than worry about your server.

In most cases, it's probably not doing anything more than when you left it at the end of the day.  But, during the day, you have some external users connecting, querying your PostBooks or xTuple databases - All seemingly innocent... or ARE THEY?! It could be some MITM parsing your datastream. Read more »

pclark's picture

Installing PostBooks... the long way.

Posted Fri, 09/24/2010 - 11:52 by pclark

While we do publish PostBooks Installers that will quickly and easily install PostBooks, some people like to make the installation a fun little project by installing the individual components.  And really, it's not a bad way for you to practice installing, or to get hands on experience with some of the pieces that we try to hide from you in the packaged installers.  This will be like taking a long walk, but in the end, it's the journey that counts.  Now, if you've been following my writings/ramblings for a while, or if you have met me in person, you know that I'm fiercly aligned with the Penguin Nation, that is, I use, recommend, endorse, and otherwise try to sell everyone on using some flavor of Linux.  Well, In this blog, you'll notice I don't say "Now, go to 'terminal' and..." .  Yep - ALL GUI.  How's THAT for a surprise?  The other surprise is that I wrote this using screen shots from Windows 2000.

          Two roads diverged in a wood, and I--
          I took the one less traveled by,
          And that has made all the difference.
                    - Excerpt from The Road Not Taken by Robert Frost (1915)
  Read more »

anderson's picture

Automatically uploading Exchange Rates from a Web Service with Pentaho Data Integration

Posted Thu, 07/22/2010 - 18:56 by anderson

The Pentaho Data Integration tool is an extremely powerful open source tool for moving data from application to application.  I use it for automating data transfer between various applications and databases.  Why do things manually when you can automate smiley

One of my current projects involved a requirement to upload exchange rates into xTuple's PostBooks application.   This is a mundane task that required someone to remember to do this on a regular basis and a prime candidate for automation.  As we are using the Pentaho suite of tools for data warehousing, reporting, and application integration, automating the exchange rate upload into PostBooks was easy. 

This has proved a very useful solution and so I am offering it back to the community.

 Read more »

gmoskowitz's picture

Getting the most out of PostgreSQL

Posted Mon, 05/03/2010 - 16:23 by gmoskowitz

A few weeks ago, three of us from xTuple went to the PG East conference in Philadelphia to talk with other people who use and maintain Postgres. xTuple has attended 3 years running. It's been a great event for developers and database administrators and we learn a lot by going. The tenor of this particular conference is changing, though.  Each year the presentations have been getting more relevant to companies considering running applications built on top of Postgres, such as xTuple ERP. Read more »

sbuttgereit496's picture

PostgreSQL Connectivity and Security Configuration Primer

Posted Thu, 12/17/2009 - 13:15 by sbuttgereit496

One of the most frequent topics I see related to PostgreSQL in forums and on support lines is being able to establish simple remote connections to the database server.  While all the elements are well documented, I haven’t always seen good explainers related to how these elements related to one another nor systematic walkthroughs related to troubleshooting problems with PostgreSQL connectivity. Read more »

pclark's picture

PostgreSQL Kung-Fu: Migrating between major versions.

Posted Fri, 12/11/2009 - 12:06 by pclark

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

Posted Tue, 10/13/2009 - 11:37 by pclark

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!

Posted Wed, 09/16/2009 - 14:48 by pclark

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 »

Source Installing Postgresql on RedHat, Ubuntu and OSX

While xTuple does publish a full Installer which provides PostgreSQL, the preferred method for implementing a production PostgreSQL server is to build PostgreSQL from source. Using the Linux distribution provided packages (apt, yum, rpm, etc) has the potential to introduce incompatibilities and curtail the migration options. The easiest way to support the customer is to keep things simple - and building PostgreSQL from source is simple.

Read more »