Thursday, April 19, 2018

My Geo Web Application Development Tech Stack

I thought that it would be interesting to post a list of technologies that I use in my so called "technology stack".  The day to day work happens in Ubuntu, PyCharm, Visual Studio Code, Postgresql (PgAdmin 4) all from my new Dell XPS 15 9560 rockin with 16 GB Ram and 512 GB SSD. My old Dell Precision m4500 lasted 7 years until the harddrive failed.  It is still alive with a new 512 GB SSD and running Ubuntu, sorry Windows.

Tuesday, April 10, 2018

How to backup Postgresql DB to an FTP site using Python

Using the standard tools of Postgresql pg_dump and Python's subprocess module we can call the command line tool via Python and have the dump file uploaded to an FTP site.  This is of course a very simple way to backup.

An alternative would be to use Pgbarman which is a higly effective way to minimize data loss.

Here you go: