How to Check Postgres Replication
Run the following command in Master Node: select application_name, state, sync_priority, sync_state from pg_stat_replication; You should see the below: application_name | state | sync_priority | […]
Postgres
Postgres SQL, Conditions using CASE
The SQL CASE expression is a generic conditional expression, similar to if/else statements in other programming languages: CASE WHEN condition THEN result [WHEN …] [ELSE […]
Tuning Semaphore for Postgres
Edit the file sysctl.conf: vi /etc/sysctl.conf Add: kernel.sem = 250 512000 100 2048 For the settings to take effect, run: sysctl -p Tuning Semaphore will […]
Tracking Postgres Process and Current Executing SQL
In the database server, check the SQL processes: ps -aux | grep postgres This will list all postgres processes. Pick the PID of the problematic […]
Change Postgres Default Data Directory
Quick Guide: service postgresql stop or systemctl stop postgresql mkdir /home/data cp -rf /var/lib/pgsql/#version#/data /home/. chmod -R 700 /home/data chown -R postgres:postgres /home/data Edit: /home/data/postgresql.conf […]