18.4. Managing Kernel Resources

Started by PG Bug reporting form6 days ago6 messagesdocs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/18/kernel-resources.html
Description:

18.4. Kernel Resource Management
In this section:

1) Table 18.1. System V IPC Parameters

SEMMAP > “see text” -- what does this mean?

2) in the Linux section:
block

$ sysctl -w kernel.shmmax=17179869184
$ sysctl -w kernel.shmall=4194304

$ replace with #

To make these settings persist over reboots, see /etc/sysctl.conf.

replace “see” with “modify”

3) Global changes in the section:

you continue to use the server process name as “postmaster”!!! way too many
times (find and replace it)

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: PG Bug reporting form (#1)
Re: 18.4. Managing Kernel Resources

PG Doc comments form <noreply@postgresql.org> writes:

you continue to use the server process name as “postmaster”!!! way too many
times (find and replace it)

This is intentional. See the Glossary [1]https://www.postgresql.org/docs/current/glossary.html:

Postmaster (process)

The very first process of an instance. It starts and manages the
auxiliary processes and creates backend processes on demand.

The postmaster shares an executable file with the other processes,
but it's still a distinct concept.

regards, tom lane

[1]: https://www.postgresql.org/docs/current/glossary.html

#3Yaroslav Saburov
y.saburov@gmail.com
In reply to: Tom Lane (#2)
Re: 18.4. Managing Kernel Resources

postgres@sql:~$ cat /pgdatabase/data/postmaster.pid
58
/pgdatabase/data
1783830699
5432
/var/run/postgresql
localhost
24381256 0
ready
postgres@sql:~$ ps 58
PID TTY STAT TIME COMMAND
58 ? Ss 0:00 /usr/lib/postgresql/18/bin/postgres -D /pgdatabase/data -c config_file=/etc/postgresql/18/main/postgresql.conf

Show me process postmaster?

Show quoted text

11 лип. 2026 р. о 22:19 Tom Lane <tgl@sss.pgh.pa.us> пише:

PG Doc comments form <noreply@postgresql.org> writes:

you continue to use the server process name as “postmaster”!!! way too many
times (find and replace it)

This is intentional. See the Glossary [1]:

Postmaster (process)

The very first process of an instance. It starts and manages the
auxiliary processes and creates backend processes on demand.

The postmaster shares an executable file with the other processes,
but it's still a distinct concept.

regards, tom lane

[1] https://www.postgresql.org/docs/current/glossary.html

#4Laurenz Albe
laurenz.albe@cybertec.at
In reply to: Yaroslav Saburov (#3)
Re: 18.4. Managing Kernel Resources

On Sun, 2026-07-12 at 07:46 +0300, Yaroslav Saburov wrote:

postgres@sql:~$ cat /pgdatabase/data/postmaster.pid 
58
/pgdatabase/data
1783830699
5432
/var/run/postgresql
localhost
 24381256         0
ready   
postgres@sql:~$ ps 58
    PID TTY      STAT   TIME COMMAND
     58 ?        Ss     0:00 /usr/lib/postgresql/18/bin/postgres -D /pgdatabase/data -c config_file=/etc/postgresql/18/main/postgresql.conf

Show me process postmaster?

You found it!

"Postmaster" is not the name of the executable or the process title (any more),
it is just what we call that process. It is a technical term.

Yours,
Laurenz Albe

#5Yaroslav Saburov
y.saburov@gmail.com
In reply to: Laurenz Albe (#4)
Re: 18.4. Managing Kernel Resources

You're wrong.

Let's take a look:

Section 18.3.1

Show quoted text

HINT: Is another postmaster already running on port 5432?

What is the name of the process used here? 12 лип. 2026 р. о 10:12 Laurenz Albe <laurenz.albe@cybertec.at> пише:

On Sun, 2026-07-12 at 07:46 +0300, Yaroslav Saburov wrote:

postgres@sql:~$ cat /pgdatabase/data/postmaster.pid
58
/pgdatabase/data
1783830699
5432
/var/run/postgresql
localhost
24381256 0
ready
postgres@sql:~$ ps 58
PID TTY STAT TIME COMMAND
58 ? Ss 0:00 /usr/lib/postgresql/18/bin/postgres -D /pgdatabase/data -c config_file=/etc/postgresql/18/main/postgresql.conf

Show me process postmaster?

You found it!

"Postmaster" is not the name of the executable or the process title (any more),
it is just what we call that process. It is a technical term.

Yours,
Laurenz Albe

#6Laurenz Albe
laurenz.albe@cybertec.at
In reply to: Yaroslav Saburov (#5)
Re: 18.4. Managing Kernel Resources

On Mon, 2026-07-13 at 10:25 +0300, Yaroslav Saburov wrote:

What is the name of the process used here? 12 лип. 2026 р. о 10:12 Laurenz Albe <laurenz.albe@cybertec.at> пише:

On Sun, 2026-07-12 at 07:46 +0300, Yaroslav Saburov wrote:

postgres@sql:~$ cat /pgdatabase/data/postmaster.pid 
58
/pgdatabase/data
1783830699
5432
/var/run/postgresql
localhost
 24381256         0
ready   
postgres@sql:~$ ps 58
    PID TTY      STAT   TIME COMMAND
     58 ?        Ss     0:00 /usr/lib/postgresql/18/bin/postgres -D /pgdatabase/data -c config_file=/etc/postgresql/18/main/postgresql.conf

Show me process postmaster?

You found it!

"Postmaster" is not the name of the executable or the process title (any more),
it is just what we call that process.  It is a technical term.

You're wrong.

Let's take a look:

Section 18.3.1

HINT: Is another postmaster already running on port 5432?

I don't see the connection.
But since you know enough to be certain that I am wrong, I am clearly not
in a position to be of assistance.

Yours,
Laurenz Albe