Using an externally hosted postGreSQL as a gnu cash backend?

Michael Wagner mikepwagner at mikepwagner.net
Wed Apr 6 13:21:32 EDT 2016


I have been using postGres for my data store for gnucash for some time now,
and I am pretty happy with the results.

I ave been using a postGres server running on the same box as gnucash
("localhost").

I have been thinking of trying use an externally hosted (ie, "Postgres as a
service") postGres as my data store.

I am thinking of this for two reasons:

    1) Right now, I do manual backups (a postGres dump encrypted with PGP
an copied to a local disk and to GoogleDrive). Having someone else deal
with that would be very nice.

    2) It would be nice to have gnucash installed on several of my laptops
and be able to get to the same data on an machine when I am traveling. I
could do the same thing by setting up a postGres server on my home network
and allowing external connections, doing so securely would require more
time than I fee like allocating.

It seems as though a number of sites that offer postGres hosting have plans
for a small single DB for less than $10/month.

What questions do I need to ask the postGres hosting site about how to get
this to work? If I describe gnuacash as a financial program that used
liddbi with a postGres driver to talk to postGres, will they even know what
I am talking about.

[ PS I'd like to hear from folks who have some experience and want to help
me move forward on this. Last year, I asked a question about postGres, and
I got a number of "Why would anyone want to use posGres?", "gnucash doesn't
support a postGres back end!", and "You'll need to pay an experiences
postGres DBA $100,000 to set up a system like that", etc.

I have a year's worth of evidence that suggests that those were more or
less balderdash. :-) A somewhat wonky can in fact sit down with a couple of
postGres books and "how to" sites on the web and install, configure and
maintain postGres and use it as a gnucash backend.

So if you're first response to this topic is a rant against postGres (or a
rant against me for using postGres), I'd like to suggest that you start a
new thread. :-) ]

-- 
“The bassoon is one of my favorite instruments. It has a medieval aroma,
like the days when everything used to sound like that. Some people crave
baseball...I find this unfathomable, but I can easily understand why a
person could get excited about playing the bassoon.” - Frank Zappa


More information about the gnucash-user mailing list