Connecting to PostgreSQL
Manage Connectionsin the top center of the app.
New Connectionin the
Manage Connectionsmodal in PopSQL.
Nickname, enter something a descriptive name for your connection, like
Hostname, enter the hostname of your database server.
Port, use the default
5432, or enter the port used by your server.
Database, enter your the name of your database.
Password, enter the username and password for PostgreSQL. These are optional.
Connectand you're all set!
Happy querying! 🍭
AWS RDS IAM
Once enabled, you will able to select "Amazon RDS IAM" as method to connect in PostgreSQL, and you would then input your
AWS Access Key ID,
AWS Secret Access Key as provided by your administrator.
-- Create a new database user CREATE USER iam_user; -- Grant permission to use RDS IAM to that user GRANT rds_iam TO iam_user;
As this feature currently works only on private connections, your computer's network will be utilized to make the database connection. As such, your computer's IP address will need to be whitelisted for the AWS VPN that the RDS instance lives behind.
Spread the wordTweet