Deployment considerations#
Before deploying Postgres Enterprise Manager, consider these factors.
Considerations |
Implementation instructions |
|---|---|
Is a standalone server sufficient or do you need a high availability architecture? |
Installing the server or Query information |
Do you need to implement connection pooling? |
Deploying connection pooling |
What type of authentication should you use? |
|
What actions should you take to avoid security vulnerabilities? |
|
Where should you host the web server? |
- Connection pooling using PgBouncer
- Authentication options
- Configuring the PEM server to use Kerberos authentication
- Configuring the PEM server to use Windows Active Directory domain services for Kerberos authentication (SSPI)
- 1. Install Active Directory, the PEM server, and the PEM backend database server
- 2. Create users in Active Directory to map with service principals
- 3. Extract key tables from Active Directory
- 4. Configure the PEM backend database server
- 5. Obtain and view the initial ticket
- 6. Configure the PEM server
- 7. Browser settings
- Configuring the PEM server to use two-factor authentication
- Securing your deployment
- Web server installation options
- High Availability Patterns for PEM Deployment