PostgreSQL
How to Whitelist an IP Address in PostgreSQL Server?
A guide to whitelist Superjoin’s IP address in your PostgreSQL server for access.
Superjoin’s IP Address is 34.100.193.122. Whitelist this IP Address in your database and allow TCP/IP connection from this IP in your
firewall.
What is “Whitelisting”?
Think of your database like a private party. The “whitelist” is your guest list. Only the IP addresses (unique identifiers for computers on the internet) on this list can “enter the party,” i.e., connect to your database. IPs not on the list will receive the metaphorical “you’re not on the list” and cannot connect.Step by Step Guide to IP Whitelisting in your PostgreSQL DB
#1 Speak to your IT Admin
#1 Speak to your IT Admin
If you’re not hands-on with database management, contacting your IT admin is the best approach
1
Provide the IP
Share Superjoin’s IP address (34.100.193.122) with your admin.
2
Request Whitelisting
Ask them to whitelist this IP for your database access.
3
Test the Connection
Once whitelisted, connect your database in your Superjoin account to confirm everything is set up correctly.
4
Reach Out for Support
If you’ve tried the above steps and still facing issues, don’t hesitate to contact us at support@superjoin.ai. We will respond immediately.
#2 Whitelist it yourself
#2 Whitelist it yourself
If you’re ready to handle this yourself, here’s how you can whitelist IP addresses for PostgreSQL.
Solution
1
SSH Into Your Server
Use SSH to access your server where PostgreSQL is hosted.
2
Edit pg_hba.conf
Open the file located under
/etc/postgresql/[version]/main/. Add host all all 34.100.193.122/32 md5. Save and close.3
Edit postgresql.conf
Open the file located under
/etc/postgresql/[version]/main/. Locate the line where listen_addresses is mentioned and add our ip address in it in the following manner - 34.100.193.122 the resultant should look like listen_addresses = '34.100.193.122'4
Restart PostgreSQL
sudo service postgresql restart ensures your settings take effect.5
Reach Out for Support
If you’ve tried the above steps and still facing issues, don’t hesitate to contact us at support@superjoin.ai. We will respond immediately.
#3 Whitelist in Google Cloud (Cloud SQL)
#3 Whitelist in Google Cloud (Cloud SQL)
1
Navigate to Google Cloud Console
Go to the SQL section and select your instance.
2
Authorize Networks
Edit settings and under Authorized Networks, add Superjoin’s IP 34.100.193.122. Save your changes.
3
Reach Out for Support
If you’ve tried the above steps and still facing issues, don’t hesitate to contact us at support@superjoin.ai. We will respond immediately.
AWS Whitelisting
Whitelisting an IP for your PostgreSQL database doesn’t just bolster security—it ensures that only authorized locations can access your
data. Whether you choose to manage this process yourself or coordinate with IT professionals, ensuring your database’s security is
crucial. Remember, if you’re ever unsure, consulting with an expert is always a wise decision. Happy data managing!