IP control is critical in modern database security. With the DynHyp platform, you can protect your data by allowing access to your PostgreSQL database only from trusted IP addresses.

What You'll Learn in This Guide:

How to configure IP whitelist
How to define single IP and IP ranges
How to manage IP access rules
Best practices for IP security

What is IP Whitelist and Why is it Important?

IP whitelist is a security measure that ensures access to your database is granted only from allowed IP addresses. With DynHyp's IP Security module, you can:

✓ Block unauthorized access ✓ Manage secure connections ✓ Create IP-based access policies ✓ Make instant IP rule updates

IP Whitelist Configuration: Step-by-Step Guide

1. Accessing the IP Security Module

Click the three dots (⋮) menu of the relevant server on the Database Servers page
Select "IP Security" from the menu

2. Creating IP Rules

Single IP Address Definition:

42.42.42.42

IP Aralığı Tanımlama:

42.42.42.42/27

Allows access from IP addresses in the range 42.42.42.33 - 42.42.42.62.

Allow All Access:

0.0.0.0/0

Note: By default, when your server is first created, all access is allowed.

3. IP Rules Management

Important Points:

Write one IP address or IP block per line
Don't use commas or other separators
Rules take effect immediately, no server restart required
New rules overwrite old ones

IP Security Best Practices

1. Principle of Least Privilege

Allow only necessary IP addresses
Use specific IPs instead of wide IP ranges
Review IP list regularly

2. IP Management Strategy

Create separate IP lists for each environment (dev, staging, prod)
Document IP changes
Establish procedure for emergency access
Conduct periodic IP audits

3. Security Tips

💡 Don't leave IP whitelist empty
💡 Avoid leaving access open to all IPs
💡 Don't forget VPN IPs
💡 Include cloud service IPs

Conclusion

You have now secured access to your PostgreSQL database with IP whitelist configuration. This fundamental security layer, combined with DynHyp's automatic DDoS protection and SSL/TLS certificates, provides comprehensive protection for your database.

PostgreSQL Management Series

Check out our other guides for professional database management:

PostgreSQL IP Security: IP Whitelist Management with DynHyp [2024 Guide]

What You'll Learn in This Guide:

What is IP Whitelist and Why is it Important?

IP Whitelist Configuration: Step-by-Step Guide

1. Accessing the IP Security Module

2. Creating IP Rules

3. IP Rules Management

IP Security Best Practices

1. Principle of Least Privilege

2. IP Management Strategy

3. Security Tips

Conclusion

PostgreSQL Management Series

PostgreSQL Cloud Setup: Production-Ready Database with DynHyp in 5 Minutes →

PostgreSQL Backup Strategies: Automatic Backup and Recovery with DynHyp →

PostgreSQL Performance Optimization: Resource Management and Scaling with DynHyp →

POSTED BY

MORE ARTICLES

FATAL: Peer authentication failed for user "postgres"

PostgreSQL Create User: A Complete Guide [2024]

Drizzle ORM: A Type-Safe and Modern ORM for TypeScript Applications