PostgreSQL DBA Scripts
- PostgreSQL: Script to convert User to Super User
- PostgreSQL: Bash Shell Script to execute psql command in UNIX / LINUX
- PostgreSQL: Script to find all Objects of a Particular User
- PostgreSQL: How to get the list of all Schemas of a database in PSQL?
- PostgreSQL: How to get the list of all privileges of a database in PSQL?
- PostgreSQL: How to get the list of all tables and all databases in PSQL?
- PostgreSQL: Script to check the status of Shared Buffer (Use pg_buffercache)
- PostgreSQL: Script to check the status of AutoVacuum for all Tables
- PostgreSQL: Find a list of active Temp tables with Size and User information
- PostgreSQL: Script to find the count of objects for each Database Schema
- PostgreSQL: Script to find Orphaned Sequence, not owned by any Column
- PostgreSQL: Shell script to copy table data from one server to another server
- PostgreSQL: Script to copy Table Data from one Schema to another Schema
- PostgreSQL: Script to search any Text from the Stored Function
- PostgreSQL: Script to find Version and Release Information
- PostgreSQL: Script to find size of all Databases of Server
- PostgreSQL: Script to find Index Size and Index Usage Statistics
- PostgreSQL: How to Install PostgreSQL 9.6 on Ubuntu 16.04?
- PostgreSQL: How to check Table Fragmentation using pgstattuple module
- PostgreSQL: Copy Database to another Server in Windows (pg_dump – backup & restore)
- PostgreSQL: Script to find total Live Tuples and Dead Tuples (Row) of a Table
- PostgreSQL: Script to find TOP 10 Long Running Queries using pg_stat_statements (Day 2/2)
- PostgreSQL: How to change the Database User Password in Linux
- PostgreSQL: Script to find all Default Values of the Columns
- PostgreSQL: Script to kill all idle sessions and connections of a Database
- PostgreSQL: How to Install PostgreSQL 9.4 on Ubuntu 14.04?
- PostgreSQL: Script to check a Fillfactor value for Tables and Indexes
- PostgreSQL: How to measure the size of a Table Row and Data Page?
- PostgreSQL: Populate DROP FUNCTION script with the type of Parameters
- PostgreSQL: Script to create a copy of the Existing Database
- PostgreSQL: Script to Stop all Connections and Force to Drop the Database
- PostgreSQL: Execute VACUUM FULL without Disk Space
- PostgreSQL: Important Parameters to enable Log for all Queries
- PostgreSQL: Function to truncate all Tables created by Particular User
- PostgreSQL: Script to Kill all Running Connections and Sessions of a Database
- PostgreSQL: Script to Create a Read-Only Database User
- PostgreSQL: Script to find Source and Destination of All Foreign Key Constraint
- PostgreSQL: Fast way to find the row count of a Table
- PostgreSQL: Script to find a Missing Indexes of the schema
- PostgreSQL: Script to find the unused and duplicate index
- PostgreSQL: Important Database Administrator Commands Part II (PSQL)
- PostgreSQL: Important Database Administrator Commands Part I
- PostgreSQL: Script to find which group roles are granted to the User
- PostgreSQL: Script to Find Table and Column without comment or description
- Script to find sessions that are blocking other sessions in PostgreSQL
- Script to find active sessions or connections in PostgreSQL
- How to find size of Database and Table in PostgreSQL
- Insert script for all Countries
