In this article, we will see the difference between pg_ctl and systemctl in PostgreSQL.
Difference between pg_ctl and systemctl in PostgreSQL
Continue reading What is difference between pg_ctl and systemctl in PostgreSQL
Tag: restart
How to start stop PostgreSQL server using pg_ctl
In this article, we will see how to start stop PostgreSQL server using pg_ctl.
We can start or stop or promote PostgreSQL server(cluster) by using following three methods.
1. Using pg_ctl
2. Using Systemctl
3. Using service
Last two methods are straight forward.
How to start stop restart PostgreSQL server using pg_ctl
pg_ctl is the utility used to start stop status or promote/failover of PostgreSQL cluster(server).
To use pg_ctl to start the PostgreSQL, we must have an already existing or newly initialized data directory.
We have to use PostgreSQL server data directory location while using pg_ctl.
Before going to examples, set the PostgreSQL environment variables using this link
Syntax of pg_ctl: Continue reading How to start stop PostgreSQL server using pg_ctl
How to find the PostgreSQL server uptime
In this article, we will see how to find the PostgreSQL server uptime. To find the PstgreSQL server uptime, we use PostgreSQL built-in function pg_postmaster_start_time(). Or by checking the time host and postgresql server start time.
Find the PostgreSQL server uptime
PostgreSQL Server Shutdown modes
In this article, we will different PostgreSQL Server Shutdown modes.
Like other RDMS, in PostgreSQL also there are threes modes in which a shutdown can be performed.
1. Smart Mode
2. Fast Mode
3. Immediate Mode