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 enable archive mode in PostgreSQL. Archive mode is not enabled by default in PostgreSQL.
What is archiving
Archiving is the concept to store history in a safe location. This also helps with Point In Time Recovery(PITR) and also in situations where a standby is lagging behind the primary and requires the recently removed WAL segments to get back to sync.
Steps to enable archive mode in PostgreSQL:
Continue reading How to enable archive mode in PostgreSQL
In this article, we will see how to rename role or user in PostgreSQL.
The alter role/user statement is used to rename role or user in PostgreSQL.
Syntax:
ALTER ROLE/USER ROLE_NAME RENAME TO NEW_NAME;
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
