PostgreSQL – Htbaa blogs?

SQL: Find & Replace text in all records

On type of query I always have to run when moving a website from its test environment to its live environment is to replace the test domain in all content pages with the live domain. With SQL this can be easily done with the REPLACE(text, search, substitution) function. For example: UPDATE some_table SET some_field = […]

Using rsnapshot for daily PostgreSQL backups

Fedora, Linux, News, Raspbian, Ubuntu, Xubuntu / February 26, 2014 / 2 minutes of reading

Having done backups for MySQL using rsnapshot before I recently had to do the same thing for PostgreSQL. Turns out PostgreSQL has similar tools to do this and it’s actually quite easy to set it up. First, assuming rsnapshot will run under the root user you’ll need to create a .pgpass file at /root/.pgpass that

Using rsnapshot for daily PostgreSQL backups Read More »