PostgreSQL User Account
  • References/Database/PostgreSQL/Server Setup and Operation

As with any server daemon that is accessible to the outside world, it is advisable to run PostgreSQL under a separate user account. This user

2025-01-10 15:47:30
Managing Kernel Resources
  • References/Database/PostgreSQL/Server Setup and Operation

PostgreSQL can sometimes exhaust various operating system resource limits, especially when multiple copies of the server are running on the

2025-01-10 15:47:30
Creating a Database Cluster
  • References/Database/PostgreSQL/Server Setup and Operation

Before you can do anything, you must initialize a database storage area on disk. We call this a database cluster. (The SQL

2025-01-10 15:47:30
Secure TCP/IP Connections with SSH Tunnels
  • References/Database/PostgreSQL/Server Setup and Operation

It is possible to use SSH to encrypt the network connection between clients and a PostgreSQL server. Done

2025-01-10 15:47:30
Secure TCP/IP Connections with SSL
  • References/Database/PostgreSQL/Server Setup and Operation

PostgreSQL has native support for using SSL connections to encrypt client/server communications for increased

2025-01-10 15:47:30
Preventing Server Spoofing
  • References/Database/PostgreSQL/Server Setup and Operation

While the server is running, it is not possible for a malicious user to take the place of the normal database server. However, when the server is down, it is possible for a

2025-01-10 15:47:30
Shutting Down the Server
  • References/Database/PostgreSQL/Server Setup and Operation

There are several ways to shut down the database server. You control the type of shutdown by sending different signals to the master postgres process

2025-01-10 15:47:30
Encryption Options
  • References/Database/PostgreSQL/Server Setup and Operation

PostgreSQL offers encryption at several levels, and provides flexibility in protecting data from disclosure due to database server theft, unscrupulous

2025-01-10 15:47:30
Registering Event Log on Windows
  • References/Database/PostgreSQL/Server Setup and Operation

To register a Windows event log library with the operating system, issue this command:

2025-01-10 15:47:30
Upgrading a PostgreSQL Cluster
  • References/Database/PostgreSQL/Server Setup and Operation

This section discusses how to upgrade your database data from one PostgreSQL release to a newer one.

2025-01-10 15:47:30