In this article, we will see how to move default location of postgresql.conf file to another in PostgreSQL?
Why we need to modify the default location of PostgreSQL.conf file?
1. By organization rule.
2. Or Maintaining standard location
3. Or Put all configuration files and scripts in the directory that is frequently backued up. Continue reading How to move default location of postgresql.conf file to another in PostgreSQL?
In this article, we will see how to log PostgreSQL queries step by step. We are going to configure PostgreSQL to permanently create iterative log files for all sessions and connections.
Steps to log PostgreSQL queries: Continue reading How to log PostgreSQL queries
In this article, we will see how to find all conf files location in PostgreSQL.
As a DBA, we must know where config files are located in our file system. Following steps are applied to Linux and Windows Operating Systems.
We cant get the config files location is PostgreSQL by using SHOW command, or by querying pg_settings catalog and by searching in Operating system.
Find all conf files location in PostgreSQL:
Continue reading How to find all conf files location in PostgreSQL
In this article, we will see how to setup streaming replication in PostgreSQL step by step on Ubuntu.
There is no recovery.conf file in standby anymore and that the replication setup (streaming replication) as slightly changed in PostgreSQL 12.
Continue reading How to setup streaming replication in PostgreSQL step by step on Ubuntu
