PostgreSQL DBA Troubleshooting Scripts
Essential PostgreSQL Database Administration Commands: A Comprehensive Guide Database administrators need a reliable set of commands for managing and maintaining PostgreSQL databases. This guide provides essential commands for common administrative tasks, from checking database versions to managing users and performing maintenance operations. Basic Database Information Version Information To check your PostgreSQL version: sql Copy show server_version ; -- or SELECT version ( ) ; User Management Check current user: sql Copy SELECT CURRENT_USER ; Switch between users: sql Copy SET session authorization your_username ; -- Reset to default user SET session authorization DEFAULT ; Database Size Information View sizes of all databases: sql Copy SELECT pg_database . datname AS "database_name" , pg_size_pretty ( pg_database_size ( pg_database . datname ) ) AS size_in_mb FROM pg_database ORDER BY size_in_mb DESC ; Time Zone Management Check timezone setti...
