PostgreSQL

​

Overview

• Self-hosted PostgreSQL
• Amazon RDS for PostgreSQL
• Azure Database for PostgreSQL
• Google Cloud SQL for PostgreSQL
• Supabase
• Neon

​

Connection Details

​

SSL Modes

​

Setting Up a Read-Only User

-- Create user
CREATE USER plumi_readonly WITH PASSWORD 'your_secure_password';

-- Grant connect permission
GRANT CONNECT ON DATABASE your_database TO plumi_readonly;

-- Grant schema usage
GRANT USAGE ON SCHEMA public TO plumi_readonly;

-- Grant select on all tables
GRANT SELECT ON ALL TABLES IN SCHEMA public TO plumi_readonly;

-- Grant select on future tables
ALTER DEFAULT PRIVILEGES IN SCHEMA public
GRANT SELECT ON TABLES TO plumi_readonly;

​

Cloud Provider Setup

​

Amazon RDS

1. Ensure your RDS instance is publicly accessible or use VPC peering
2. Add Plumi’s IP to your security group inbound rules
3. Use the RDS endpoint as the host

​

Azure Database

1. Enable “Allow access to Azure services” or add firewall rules
2. Use the server name as the host (e.g., yourserver.postgres.database.azure.com)
3. Username format: username@servername

​

Google Cloud SQL

1. Enable public IP or configure private IP access
2. Add Plumi’s IP to authorized networks
3. Use the Cloud SQL public IP as the host

​

Troubleshooting

​

”No pg_hba.conf entry”

​

”SSL connection required”