PostgreSQL

Contents:

• Tips
  • fix psql: FATAL: role “<USER>” does not exist error
  • List all databases
  • list user accounts
  • CREATE Database
  • Add or create a user account and grant permission for database
  • Get the Size of a Postgres Table
  • Quit from psql
  • Connect to postgres from bash
  • Allow localhost to connect to postgres without password checking
  • Postgres on Docker
  • Difference between Warm, hot standby and Streaming Replication:
  • Zero to PostgreSQL streaming replication in 10 mins
  • Understanding and controlling crash recovery
  • Synchronous Replication
  • When will PostgreSQL execute archive_command to archive wal files?
  • Binary Replication Tools
  • warm standby or log shipping
  • Streaming Replication
  • Introduction to Binary Replication
  • PITR
  • Warm Standby
  • Hot Standby
  • Streaming Replication
  • Safe way to check for PostgreSQL replication delay/lag
  • Does PostgreSQL 9.1 Streaming Replication catch up after a lag without WAL archiving?
  • archive_command
  • base backup
  • pg_basebackup
  • base backup
  • Postgres replica and docker
  • Backup Control Functions
  • PostgreSQL Streaming Replication
  • pg_basebackup vs pg_start_backup
  • Example of Standalone Hot Backups and recovery
  • Backup with pg_basebackup
  • Find Postgresql Version
  • Barman
  • pg_receivexlog
  • what are the pg_clog and pg_xlog directories ?
  • Getting WAL files from Barman with ‘get-wal’
  • verifying data consistency between two postgresql databases
  • How to check the replication delay in PostgreSQL?
  • Streaming replication slots in PostgreSQL 9.4
  • Continuous Archiving and Point-in-Time Recovery (PITR)
  • Point In Time Recovery From Backup using PostgreSQL Continuous Archving
  • Purpose of archiving in master?
  • Setting up file-based replication - deprecated
  • Setting up streaming replication
  • Difference between fsync and synchronous_commit ?
  • standby_mode
  • primary_conninfo
  • trigger_file
  • Testing a PostgreSQL slave/master cluster using Docker
  • Postgres streaming replication with docker
  • Show the value of a run-time parameter
  • Postgres DB Size Command
  • High Availability and Load Balancing
  • Replication
  • Multi-master replication
• Backups
  • Barman
  • Install pg_dump
  • How To Backup and Restore PostgreSQL Database Using pg_dump and psql
• Postgres-XL
• Nodes Concept
• Table distributing concept
• Shard limitation
• High Availability
• Download
• Setting up Postgres-XL cluster
  • Install Postgres-XL
  • Configure Postgres-XL
• Docker
• Ansible
• Django
• Links