PostgresCourse.com
PostgresCourse.com
  • Видео 8
  • Просмотров 102 663
Backing up PostgreSQL users and groups (pg_dump and pg_dumpall)
The pg_dump utility is the first utility most Postgres users encounter when creating a backup. However, because the pg_dump utility is used to backup a single Postgres database, users and groups aren't included in the backup contents.
The solution to this issue is to first do a pg_dumpall using the -g option, which will backup global objects ... users and groups. This video demonstrates how to accomplish the backup of Postgres users and groups using pg_dumpall.
Просмотров: 21 646

Видео

Introduction to pg_stat_statements
Просмотров 4,9 тыс.4 года назад
This is quick tutorial to get up and running with pg_stat_statements, a PostgreSQL extension that provides statistics about database table perfomance.
Installing newer versions of PostgreSQL on RedHat/CentOS
Просмотров 8154 года назад
By default, Linux operating systems like RedHat or CentOS don't offer the latest versions of PostgreSQL for installation. This video shows how to get more recent packages for installation.
Debug PostgreSQL startup problems
Просмотров 1,5 тыс.6 лет назад
Simple approach towards getting rapid feedback about startup issues by invoking the postgres server executable directly.
Logical Replication with PostgreSQL 10
Просмотров 34 тыс.6 лет назад
A quick start tutorial to demonstrate the native logical replication feature in PostgreSQL 10.
Dump query results from PostgreSQL to file
Просмотров 4,5 тыс.8 лет назад
Quick tutorial on how to dump data from PostgreSQL
Upgrade PostgreSQL 9.4.x to 9.5
Просмотров 10 тыс.8 лет назад
Step-by-step tutorial showing how to do a manual major version upgrade of PostgreSQL.
Logging into PostgreSQL without password
Просмотров 25 тыс.8 лет назад
This video is a quick tutorial showing how to log in to the psql interactive terminal using: 1) The PGPASSWORD environment variable 2) The .pgpass file 3) The pg_hba.conf configuration file