pg_ctl

How to open postgres standby database for read write(snapshot standby)

There is no technical term called snapshot standby in postgres. If you have knowledge of oracle database, then this  snapshot standby method is there in dataguard. I.e you can open the standby databa...

How to change port number in postgres

This article explains how to change the port number in postgres. We will change the port from 5444 to 5432 . 1. Check the existing port details postgres=# select * from pg_settings where name='port'; ...