PostgreSQL networking - LayerRail Docs

PostgreSQL access should be limited to the services that need it. LayerRail databases can be used with project networking, firewall rules, and service hostnames.

Recommended layout

Use this layout for production:

Place the application and database in the same or nearby location.
Prefer private connectivity when possible.
Restrict public access with firewall rules.
Rotate credentials when access changes.

Application access

Applications usually connect by setting DATABASE_URL.

DATABASE_URL="postgresql://<user>:<password>@<host>:5432/<database>?sslmode=require"

Firewall checklist

Allow only trusted source IPs or private network ranges.
Keep administrative access separate from application access.
Remove temporary rules after debugging.
Avoid broad 0.0.0.0/0 access for production databases.

Put app servers, worker VMs, and databases in the same project so access and audit trails stay easier to reason about.