<#9410 docs: Document PostgreSQL database privileg...
# meltano-repo-activity
g
#9410 docs: Document PostgreSQL database privileges and requirements Pull request opened by tayloramurphy ## Summary This PR addresses issue #8286 by adding comprehensive documentation for PostgreSQL database privileges and requirements when using PostgreSQL as Meltano's system database. ## Changes • PostgreSQL Version Requirements: Documents that PostgreSQL 13+ is required • Installation Instructions: Clarifies the two installation options (
meltano[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/meltano