DBA Hub

šŸ“‹Steps in this guide1/10

How to START/STOP PostgreSQL 13 ON RHEL 7

How to START/STOP PostgreSQL 13 ON RHEL 7

postgresql configurationintermediate
by PostgreSQL
11 views
1

Overview

How to START/STOP PostgreSQL 13 ON RHEL 7 0. Overview As root user: OR

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
As root user:
service postgresql-13.service status
service postgresql-13.service
start
service postgresql-13.service
restart
service postgresql-13.service
reload
service postgresql-13.service stop
OR
systemctl stop postgresql-13.service
systemctl start postgresql-13.service
systemctl restart postgresql-13.service
systemctl status postgresql-13.service
systemctl reload postgresql-13.service
As Postgres user use pg_ctl command
/usr/pgsql-13/bin/pg_ctl stop -D /var/lib/pgsql/13/data
/usr/pgsql-13/bin/pg_ctl
start
-D /var/lib/pgsql/13/data
/usr/pgsql-13/bin/pg_ctl
restart
-D /var/lib/pgsql/13/data
/usr/pgsql-13/bin/pg_ctl status -D /var/lib/pgsql/13/data
/usr/pgsql-13/bin/pg_ctl
reload
-D /var/lib/pgsql/13/data
Restart or reload is required when changes are made to the postgresql.conf file.
Reload simply reloads the configuration in-memory. Restart replaces the entire instance.
2

Section 2

As Postgres user use pg_ctl command Restart or reload is required when changes are made to the postgresql.conf file. Reload simply reloads the configuration in-memory. Restart replaces the entire instance. 1. How to check Postgres server status?

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
[root@rac1 ~]#
systemctl list-units|grep postgresql
postgresql-13.service     loaded active running   PostgreSQL 13 database server
[root@rac1 ~]#
---- OR
-----

[root@rac1 ~]#
service postgresql-13.service status
Redirecting to /bin/systemctl status postgresql-13.service
ā— postgresql-13.service - PostgreSQL 13 database server
   Loaded: loaded (/usr/lib/systemd/system/postgresql-13.service; enabled; vendor preset: disabled)
Active:
active
(running) since Mon 2021-03-15 17:57:05 +08;
53min ago
Docs: https://www.postgresql.org/docs/13/static/
  Process: 969 ExecStartPre=/usr/pgsql-13/bin/postgresql-13-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)
 Main PID: 991 (postmaster)
   CGroup: /system.slice/postgresql-13.service
           ā”œā”€ 991 /usr/pgsql-13/bin/postmaster -D /var/lib/pgsql/13/data/
           ā”œā”€1053 postgres: logger
           ā”œā”€1178 postgres: checkpointer
           ā”œā”€1179 postgres: background writer
           ā”œā”€1180 postgres: walwriter
           ā”œā”€1181 postgres: autovacuum launcher
           ā”œā”€1182 postgres: stats collector
           ā”œā”€1183 postgres: logical replication launcher
           ā””ā”€2282 postgres: postgres postgres [local] idle

Mar 15 17:57:03 rac1.rajasekhar.com systemd[1]: Starting PostgreSQL 13 database server...
Mar 15 17:57:04 rac1.rajasekhar.com postmaster[991]: 2021-03-15 17:57:04.155 +08 [991] LOG:  redirecting log output to logging collector process
Mar 15 17:57:04 rac1.rajasekhar.com postmaster[991]: 2021-03-15 17:57:04.155 +08 [991] HINT:  Future log output will appear in directory "log".
Mar 15 17:57:05 rac1.rajasekhar.com systemd[1]: Started PostgreSQL 13 database server.
[root@rac1 ~]#
--- OR ---
[root@rac1 ~]#
ps -ef | grep postgres
postgres   991     1  0 17:57 ?        00:00:00 /usr/pgsql-13/bin/postmaster -D /var/lib/pgsql/13/data/
postgres  1053   991  0 17:57 ?        00:00:00 postgres: logger
postgres  1178   991  0 17:57 ?        00:00:00 postgres: checkpointer
postgres  1179   991  0 17:57 ?        00:00:00 postgres: background writer
postgres  1180   991  0 17:57 ?        00:00:00 postgres: walwriter
postgres  1181   991  0 17:57 ?        00:00:00 postgres: autovacuum launcher
postgres  1182   991  0 17:57 ?        00:00:00 postgres: stats collector
postgres  1183   991  0 17:57 ?        00:00:00 postgres: logical replication launcher
root      2201  2143  0 17:58 pts/0    00:00:00 su - postgres
postgres  2202  2201  0 17:58 pts/0    00:00:00 -bash
postgres  2281  2202  0 17:58 pts/0    00:00:00 psql
postgres  2282   991  0 17:58 ?        00:00:00 postgres: postgres postgres [local] idle
root      5744  5275  0 18:55 pts/1    00:00:00 grep --color=auto postgres
[root@rac1 ~]#

OR

[postgres@rac1 ~]$
cd /usr/pgsql-13/bin/
[postgres@rac1 bin]$
./pg_ctl status -D /var/lib/pgsql/13/data/
pg_ctl: server is
running
(PID: 991)
/usr/pgsql-13/bin/postgres "-D" "/var/lib/pgsql/13/data/"
[postgres@rac1 bin]$
3

Section 3

systemctl list-units|grep postgresql service postgresql-13.service status Active: active (running) since Mon 2021-03-15 17:57:05 +08; 53min ago ps -ef | grep postgres cd /usr/pgsql-13/bin/ ./pg_ctl status -D /var/lib/pgsql/13/data/
4

Section 4

running 2. How to Stop Postgres server? cd /usr/pgsql-13/bin/ ./pg_ctl stop -D /var/lib/pgsql/13/data/

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
[postgres@rac1 ~]$
cd /usr/pgsql-13/bin/
[postgres@rac1 bin]$
./pg_ctl stop -D /var/lib/pgsql/13/data/
waiting for server to shut down.... done
server stopped
[postgres@rac1 bin]$

[root@rac1 ~]#
ps -ef | grep postgres
root      6718  2143  0 19:07 pts/0    00:00:00 grep --color=auto postgres
[root@rac1 ~]#
--- OR ----
[root@rac1 ~]#
service postgresql-13.service stop
Redirecting to /bin/systemctl stop postgresql-13.service
[root@rac1 ~]#
[root@rac1 ~]#
service postgresql-13.service status
Redirecting to /bin/systemctl status postgresql-13.service
ā— postgresql-13.service - PostgreSQL 13 database server
   Loaded: loaded (/usr/lib/systemd/system/postgresql-13.service; enabled; vendor preset: disabled)
Active:
inactive
(dead) since Mon 2021-03-15 19:07:03 +08;
5min ago
Docs: https://www.postgresql.org/docs/13/static/
  Process: 991 ExecStart=/usr/pgsql-13/bin/postmaster -D ${PGDATA} (code=exited, status=0/SUCCESS)
  Process: 969 ExecStartPre=/usr/pgsql-13/bin/postgresql-13-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)
 Main PID: 991 (code=exited, status=0/SUCCESS)

Mar 15 17:57:03 rac1.rajasekhar.com systemd[1]: Starting PostgreSQL 13 database server...
Mar 15 17:57:04 rac1.rajasekhar.com postmaster[991]: 2021-03-15 17:57:04.155 +08 [991] LOG:  redirecting log output to logging collector process
Mar 15 17:57:04 rac1.rajasekhar.com postmaster[991]: 2021-03-15 17:57:04.155 +08 [991] HINT:  Future log output will appear in directory "log".
Mar 15 17:57:05 rac1.rajasekhar.com systemd[1]: Started PostgreSQL 13 database server.
[root@rac1 ~]#
5

Section 5

ps -ef | grep postgres service postgresql-13.service stop service postgresql-13.service status Active: inactive (dead) since Mon 2021-03-15 19:07:03 +08; 5min ago 3. How to Start Postgres server?
6

Section 6

./pg_ctl start -D /var/lib/pgsql/13/data/ service postgresql-13.service start service postgresql-13.service status Active: active (running) since Mon 2021-03-15 19:15:14 +08; 3s ago 4. How to Restart Postgres server?

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
[postgres@rac1 ~]$
cd /usr/pgsql-13/bin/
[postgres@rac1 bin]$
./pg_ctl start -D /var/lib/pgsql/13/data/
waiting for server to start....2021-03-15 19:14:17.815 +08 [7443] LOG:  redirecting log output to logging collector process
2021-03-15 19:14:17.815 +08 [7443] HINT:  Future log output will appear in directory "log".
 done
server started
[postgres@rac1 bin]$
--- OR ----
[root@rac1 ~]#
service postgresql-13.service start
Redirecting to /bin/systemctl start postgresql-13.service
[root@rac1 ~]#
[root@rac1 ~]#
service postgresql-13.service status
Redirecting to /bin/systemctl status postgresql-13.service
ā— postgresql-13.service - PostgreSQL 13 database server
   Loaded: loaded (/usr/lib/systemd/system/postgresql-13.service; enabled; vendor preset: disabled)
Active:
active
(running) since Mon 2021-03-15 19:15:14 +08;
3s ago
Docs: https://www.postgresql.org/docs/13/static/
  Process: 7523 ExecStartPre=/usr/pgsql-13/bin/postgresql-13-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)
 Main PID: 7529 (postmaster)
   CGroup: /system.slice/postgresql-13.service
           ā”œā”€7529 /usr/pgsql-13/bin/postmaster -D /var/lib/pgsql/13/data/
           ā”œā”€7533 postgres: logger
           ā”œā”€7535 postgres: checkpointer
           ā”œā”€7536 postgres: background writer
           ā”œā”€7537 postgres: walwriter
           ā”œā”€7538 postgres: autovacuum launcher
           ā”œā”€7539 postgres: stats collector
           ā””ā”€7540 postgres: logical replication launcher

Mar 15 19:15:14 rac1.rajasekhar.com systemd[1]: Starting PostgreSQL 13 database server...
Mar 15 19:15:14 rac1.rajasekhar.com postmaster[7529]: 2021-03-15 19:15:14.193 +08 [7529] LOG:  redirecting log output to logging collector process
Mar 15 19:15:14 rac1.rajasekhar.com postmaster[7529]: 2021-03-15 19:15:14.193 +08 [7529] HINT:  Future log output will appear in directory "log".
Mar 15 19:15:14 rac1.rajasekhar.com systemd[1]: Started PostgreSQL 13 database server.
[root@rac1 ~]#
7

Section 7

4. How to Restart Postgres server? -w, --wait wait until operation completes (default) ./pg_ctl -w restart -D /var/lib/pgsql/13/data/ --- OR ---- service postgresql-13.service restart

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
-w, --wait             wait until operation completes (default)
[postgres@rac1 ~]$
cd /usr/pgsql-13/bin/
[postgres@rac1 bin]$
./pg_ctl -w restart -D /var/lib/pgsql/13/data/
waiting for server to shut down.... done
server stopped
waiting for server to start....2021-03-15 19:22:58.920 +08 [8017] LOG:  redirecting log output to logging collector process
2021-03-15 19:22:58.920 +08 [8017] HINT:  Future log output will appear in directory "log".
 done
server started
[postgres@rac1 bin]$
--- OR ----
[root@rac1 ~]#
service postgresql-13.service restart
Redirecting to /bin/systemctl restart postgresql-13.service
[root@rac1 ~]#
[root@rac1 ~]#
service postgresql-13.service status
Redirecting to /bin/systemctl status postgresql-13.service
ā— postgresql-13.service - PostgreSQL 13 database server
   Loaded: loaded (/usr/lib/systemd/system/postgresql-13.service; enabled; vendor preset: disabled)
Active:
active
(running) since Mon 2021-03-15 19:52:26 +08;
3s ago
Docs: https://www.postgresql.org/docs/13/static/
  Process: 10439 ExecStartPre=/usr/pgsql-13/bin/postgresql-13-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)
 Main PID: 10445 (postmaster)
   CGroup: /system.slice/postgresql-13.service
           ā”œā”€10445 /usr/pgsql-13/bin/postmaster -D /var/lib/pgsql/13/data/
           ā”œā”€10449 postgres: logger
           ā”œā”€10451 postgres: checkpointer
           ā”œā”€10452 postgres: background writer
           ā”œā”€10453 postgres: walwriter
           ā”œā”€10454 postgres: autovacuum launcher
           ā”œā”€10455 postgres: stats collector
           ā””ā”€10456 postgres: logical replication launcher

Mar 15 19:52:26 rac1.rajasekhar.com systemd[1]: Starting PostgreSQL 13 database server...
Mar 15 19:52:26 rac1.rajasekhar.com postmaster[10445]: 2021-03-15 19:52:26.856 +08 [10445] LOG:  redirecting log output to logging collector process
Mar 15 19:52:26 rac1.rajasekhar.com postmaster[10445]: 2021-03-15 19:52:26.856 +08 [10445] HINT:  Future log output will appear in directory "log".
Mar 15 19:52:26 rac1.rajasekhar.com systemd[1]: Started PostgreSQL 13 database server.
[root@rac1 ~]#
8

Section 8

service postgresql-13.service status Active: active (running) since Mon 2021-03-15 19:52:26 +08; 3s ago 5. How to Reload Postgres server? ./pg_ctl reload -D /var/lib/pgsql/13/data

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
[postgres@rac1 bin]$
./pg_ctl reload -D /var/lib/pgsql/13/data
server signaled
[postgres@rac1 bin]$
--- OR ---
[root@rac1 ~]#
service postgresql-13.service reload
Redirecting to /bin/systemctl reload postgresql-13.service
[root@rac1 ~]#
[root@rac1 ~]#
service postgresql-13.service status
Redirecting to /bin/systemctl status postgresql-13.service
ā— postgresql-13.service - PostgreSQL 13 database server
   Loaded: loaded (/usr/lib/systemd/system/postgresql-13.service; enabled; vendor preset: disabled)
Active:
active
(running) since Mon 2021-03-15 19:52:26 +08;
11min ago
Docs: https://www.postgresql.org/docs/13/static/
  Process: 11218 ExecReload=/bin/kill -HUP $MAINPID (code=exited, status=0/SUCCESS)
  Process: 10439 ExecStartPre=/usr/pgsql-13/bin/postgresql-13-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)
 Main PID: 10445 (postmaster)
   CGroup: /system.slice/postgresql-13.service
           ā”œā”€10445 /usr/pgsql-13/bin/postmaster -D /var/lib/pgsql/13/data/
           ā”œā”€10449 postgres: logger
           ā”œā”€10451 postgres: checkpointer
           ā”œā”€10452 postgres: background writer
           ā”œā”€10453 postgres: walwriter
           ā”œā”€10454 postgres: autovacuum launcher
           ā”œā”€10455 postgres: stats collector
           ā””ā”€10456 postgres: logical replication launcher

Mar 15 19:52:26 rac1.rajasekhar.com systemd[1]: Starting PostgreSQL 13 database server...
Mar 15 19:52:26 rac1.rajasekhar.com postmaster[10445]: 2021-03-15 19:52:26.856 +08 [10445] LOG:  redirecting log output to logging collector process
Mar 15 19:52:26 rac1.rajasekhar.com postmaster[10445]: 2021-03-15 19:52:26.856 +08 [10445] HINT:  Future log output will appear in directory "log".
Mar 15 19:52:26 rac1.rajasekhar.com systemd[1]: Started PostgreSQL 13 database server.
Mar 15 19:53:40 rac1.rajasekhar.com systemd[1]: Reloaded PostgreSQL 13 database server.
Mar 15 20:03:49 rac1.rajasekhar.com systemd[1]: Reloaded PostgreSQL 13 database server.
[root@rac1 ~]#
9

Section 9

--- OR --- service postgresql-13.service reload service postgresql-13.service status Active: active (running) since Mon 2021-03-15 19:52:26 +08; 11min ago Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using. Caution:
10

Section 10

Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.

Comments (0)

Please to add comments

No comments yet. Be the first to comment!