of the old server, for example by typing ps ax | grep postmaster and signal it to stop this way: kill -INT processID 4. If you are installing in the same place as the old version then it is also a good directly using kill. The PID of the postmaster process can be found using the ps program, or from the file postmaster.pid in the data directory. For example, to do a fast shutdown: $ kill -INT ‘head -1 postmaster process without letting it relay the signal to its subprocesses, so it will be necessary to kill the individual subprocesses by hand as well. 284 Chapter 16. Server Run-time Environment 16.7.

of the old server, for example by typing ps ax | grep postmaster and signal it to stop this way: kill -INT processID 4. If you are installing in the same place as the old version then it is also a good directly using kill. The PID of the postmaster process can be found using the ps program, or from the file postmaster.pid in the data directory. For example, to do a fast shutdown: $ kill -INT ‘head -1 postmaster process without letting it relay the signal to its subprocesses, so it will be necessary to kill the individual subpro- cesses by hand as well. 269 Chapter 16. Server Run-time Environment 16.7

of the old server, for example by typing ps ax | grep postmaster and signal it to stop this way: kill -INT processID 4. If you are installing in the same place as the old version then it is also a good directly using kill. The PID of the postmaster process can be found using the ps program, or from the file postmaster.pid in the data directory. For example, to do a fast shutdown: $ kill -INT ‘head -1 postmaster process without letting it relay the signal to its subprocesses, so it will be necessary to kill the individual subprocesses by hand as well. 16.6. Encryption Options PostgreSQL offers encryption

of the old server, for example by typing ps ax | grep postmaster and signal it to stop this way: kill -INT processID 4. If you are installing in the same place as the old version then it is also a good directly using kill. The PID of the postmaster process can be found using the ps program, or from the file postmaster.pid in the data directory. For example, to do a fast shutdown: $ kill -INT ‘head -1 postmaster process without letting it relay the signal to its subprocesses, so it will be necessary to kill the individual subprocesses by hand as well. 16.6. Encryption Options PostgreSQL offers encryption

directly using kill. The PID of the postgres process can be found using the ps program, or from the file postmaster.pid in the data directory. For example, to do a fast shutdown: $ kill -INT ‘head -1 postgres process without letting it relay the signal to its subprocesses, so it will be necessary to kill the individual subprocesses by hand as well. 16.6. Encryption Options PostgreSQL offers encryption you edit the file on an active system, you will need to signal the server (using pg_ctl reload or kill -HUP) to make it re-read the file. Tip: To connect to a particular database, a user must not only

directly using kill. The PID of the postgres process can be found using the ps program, or from the file postmaster.pid in the data directory. For example, to do a fast shutdown: $ kill -INT ‘head -1 postgres process without letting it relay the signal to its subprocesses, so it will be necessary to kill the individual subprocesses by hand as well. 16.6. Encryption Options PostgreSQL offers encryption you edit the file on an active system, you will need to signal the server (using pg_ctl reload or kill -HUP) to make it re-read the file. Tip: To connect to a particular database, a user must not only

handling. By default, overcommit of paging space can happen. While we have not seen this occur, AIX will kill processes when it runs out of memory and the overcommit is accessed. The closest to this that we have another process. Like many other parts of AIX, the paging space allocation method and out-of-memory kill is configurable on a system- or process-wide basis if this becomes a problem. 17.7.2. Cygwin PostgreSQL Type=notify User=postgres ExecStart=/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data ExecReload=/bin/kill -HUP $MAINPID KillMode=mixed KillSignal=SIGINT TimeoutSec=infinity [Install] WantedBy=multi-user

handling. By default, overcommit of paging space can happen. While we have not seen this occur, AIX will kill processes when it runs out of memory and the overcommit is accessed. The closest to this that we have another process. Like many other parts of AIX, the paging space allocation method and out-of-memory kill is configurable on a system- or process-wide basis if this becomes a problem. 17.7.2. Cygwin 565 Type=notify User=postgres ExecStart=/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data ExecReload=/bin/kill -HUP $MAINPID KillMode=mixed KillSignal=SIGINT TimeoutSec=infinity [Install] WantedBy=multi-user

handling. By default, overcommit of paging space can happen. While we have not seen this occur, AIX will kill processes when it runs out of memory and the overcommit is accessed. The closest to this that we have another process. Like many other parts of AIX, the paging space allocation method and out-of-memory kill is configurable on a system- or process-wide basis if this becomes a problem. References and resources using kill on non-Windows systems. The PID of the postgres process can be found using the ps program, or from the file postmaster.pid in the data directory. For example, to do a fast shutdown: $ kill -INT

handling. By default, overcommit of paging space can happen. While we have not seen this occur, AIX will kill processes when it runs out of memory and the overcommit is accessed. The closest to this that we have another process. Like many other parts of AIX, the paging space allocation method and out-of-memory kill is configurable on a system- or process-wide basis if this becomes a problem. References and resources using kill on non-Windows systems. The PID of the postgres process can be found using the ps program, or from the file postmaster.pid in the data directory. For example, to do a fast shutdown: $ kill -INT