GitHub
07/24/2025, 9:05 PMmeltano[postgres] vs meltano[psycopg2])
• Database Privileges: Comprehensive list of required privileges at database, schema, and object levels
• Setup Instructions: Provides complete SQL commands for setting up database user privileges
• Table Documentation: Lists the tables created by Meltano and their purposes
• Migration Support: Explains Alembic integration and required ALTER TABLE privileges
• Security Guidelines: Best practices for secure PostgreSQL deployments
## Technical Details
The documentation covers three levels of privileges:
1. Database-level: CONNECT, CREATE, TEMPORARY
2. Schema-level: CREATE, USAGE (on target schema)
3. Object-level: SELECT, INSERT, UPDATE, DELETE on tables; USAGE, SELECT on sequences
## Testing
• Documentation has been added to the existing PostgreSQL section in /docs/reference/settings.mdx
• Pre-commit hooks have been run and passed
• Content follows existing documentation patterns and formatting
## Impact
This resolves a documentation gap that required users to discover PostgreSQL privilege requirements through trial and error. With this documentation, users can properly configure their PostgreSQL databases before deploying Meltano.
Resolves: #8286
## Summary by Sourcery
Add detailed documentation for PostgreSQL database configuration in Meltano, covering version requirements, installation options, privileges, setup commands, created tables, migration support, and security guidelines
Documentation:
• Specify PostgreSQL 13+ as the minimum supported version
• Document installation options using meltano[postgres] (psycopg3) or meltano[psycopg2]
• List required database-, schema-, and object-level privileges for the Meltano user
• Provide SQL commands to grant the necessary privileges and set default privileges for future objects
• Document the Meltano tables created in PostgreSQL and their purposes
• Explain Alembic-based migration support and required ALTER TABLE privileges
• Outline security best practices such as dedicated users, SSL, and secure credential storage
meltano/meltanoGitHub
07/24/2025, 9:05 PMGitHub
07/29/2025, 2:06 PM