September 1, 2018
How to reload config settings without restarting database

If you are making modifications to the PostgreSQL configuration file (postgresql.conf) you will need to reload the file for your changes to take effect.  Some configs need a full database cluster restart but many just require a reload of the configuration file. Option 1 - From the OS (Linux) command line Option 2 - From a database […]

Read More
September 1, 2018
Hide Column Values in PostgreSQL

Do you want to hide column values in PostgreSQL?  We had that exact need, allow our DevOps engineers to run selects from a table and obfuscate some of the column values that are returned.  For us, this masking of data generally applies to Personally Identifiable Information (PII).  There are a couple of methods to achieve this […]

Read More
August 26, 2018
Welcome to TalkPostgreSQL

Welcome to TalkPostgreSQL.  Here you will find tips, tutorials, new, and other articles all related to the world's best open source database, PostgreSQL.  If you are interested in topics that I have not yet written about feel free to leave a comment and let me know what you would like to see.

Read More
August 9, 2018
PostgreSQL 10.5 and 11 Beta 3 Released

PostgreSQL 10.5 and 11 Beta 3 Released! The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 10.5, 9.6.10, 9.5.14, 9.4.19, 9.3.24, with fixes for two security issues as well as bugs reported over the last three months. The third beta release of PostgreSQL 11 is also […]

Read More