Using an externally hosted postGreSQL as a gnu cash backend?

Colin Law clanlaw at gmail.com
Tue Apr 12 03:34:32 EDT 2016


On 12 April 2016 at 01:07, Dean Gibson <gnucash.stuff at mailpen.com> wrote:
> On 2016-04-11 12:51, Colin Law wrote:
>>
>> If you are hosting PostGres on a machine connected to the internet don't
>> forget to consider all the security implications. You don't want anyone
>> getting into your machine via the open ports, or of accessing your data if
>> you have not got it right. For example, if you connect to a pg server are
>> the user and pwd encrypted or are they open for anyone to snoop between you
>> and the server? I don't know the answer to that.
>
>
> You can easily set up a PostgreSQL server using an SSL connection and
> certificate.

You can do that and I can do that, but the majority of readers here will not.

>  The user/password and all the data is encrypted. That's how
> I've been running PostgreSQL in another application across the Internet for
> five years, and it *works very well*. In this instance, it is the *right
> tool for the job*.  In addition, I've been PostgreSQL for other web-based
> applications for over a decade, one of which won me an award (since we're
> mentioning experience & qualifications in this thread).  I've also been
> programming computers since 1962, and am now retired.

You beat me by a few years, but not many :)

Colin


More information about the gnucash-user mailing list