Backing up PostgreSQL users and groups (pg_dump and pg_dumpall)

preview_player
Показать описание
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.
  1. PostgresCourse.com
  2. postgres
  3. postgresql
  4. backup
  5. logical backup
  6. database
Рекомендации по теме
Backing up PostgreSQL 0:09:24

Backing up PostgreSQL users and groups (pg_dump and pg_dumpall)

PostgreSQL backup and 0:02:09

PostgreSQL backup and restore a database with pgAdmin 4

Schedule Automatic Backups 0:05:31

Schedule Automatic Backups for PostgreSQL with pgAgent in pgAdmin

backup restore postgreSQL 0:04:51

backup restore postgreSQL 15 database in pgadmin 4 postgreSQL tutorial explained

Backup in PostgreSQL 0:01:26

Backup in PostgreSQL

postgresql - how 0:04:53

postgresql - how to backup and restore database

Backup PostgreSQL 0:13:57

Backup PostgreSQL

How To Resolve 0:05:27

How To Resolve Or Fix Error 'Restoring backup on the server PostgreSQL 16' Process Failed ...

🔴 Final Year 1:21:21

🔴 Final Year CS Payroll System Project: Day 9 with Express, TypeScript, and Drizzle ORM

PostgreSQL 14 | 0:24:42

PostgreSQL 14 | Backup - pg_dump and pg_restore Part 4 #postgres #backup #RDMS #database

PostgreSQL Backup & 0:19:31

PostgreSQL Backup & Point-In-Time Recovery

Google Cloud Backup 0:04:59

Google Cloud Backup and DR - Adding and backing up PostgreSQL databases

How to backup 0:27:30

How to backup PostgreSQL (using wal-g)

How To Backup 0:11:52

How To Backup PostgreSQL Database With pg_dump And pg_dumpall From Server || Four Ways To Do Backup

76- Daily backup 0:09:37

76- Daily backup schedule using pg_dumpall

Avoid Password Authentication 0:01:48

Avoid Password Authentication Error When Backing Up Your Postgres Database

Incremental vs Differential 0:06:56

Incremental vs Differential Backup, & Full - Explained

PostgreSQL backup and 0:05:01

PostgreSQL backup and restore database with Pgadmin4

PostgreSQL Backup Types 0:09:22

PostgreSQL Backup Types and Tools with examples | Backup and restore in PostgreSQL | 2024 Update

Kevin Kempter: PostgreSQL 0:50:05

Kevin Kempter: PostgreSQL Backup and Recovery Methods

Fortify Your Data 0:31:12

Fortify Your Data Fortress: Master PostgreSQL Backup & Restore Techniques!

How to backup 0:05:00

How to backup and restore PostgreSQL on Kubernetes

PostgreSQL in 100 0:02:37

PostgreSQL in 100 Seconds

Backup a PostgreSQL 0:11:38

Backup a PostgreSQL Database - Ansible module postgresql_db

Комментарии
Автор

Really good, straight to the point and concise explanation of how to export a PostgreSQL DB!

KenSeedarnee
Автор

This was very helpful and calmly and clearly explained with high quality audio and video. Thank you SO much for that.

FrmanTV
Автор

Thanks, that's really helpful. Any plans to make a video covering how to create a backup from e.g a remote postgres running on AWS RDS onto a local backup machine?
I'm trying to understand how I could automate daily backups to my extra linux machine.

IMADETHISACCFORRAY
Автор

Buen video .. quiero sacar un backup y me sale el error ... Pg_dump: el esquema 2201 no existe... Portgresql-11.?

juancarlospastillo
Автор

So why use pg_dump at all if you can just use pg_dumpall without the -g parameter and have all the data and user objects in a single file?

wackogames
Автор

Well explained, thanks.
In some managed postgres DBs you can't run dumpall, because it needs super user permission.
How can I dump users in that case?

yehiamcp
Автор

So to recap: If I have a postgres instance with 1 self created DB and I want to export both the DB and all the users, I use pg_dumpall without the -g flag?
If I then import the dump file to a new postgres instance, will it overwrite the pre-existing default postgres schemes, i.e. information_schema, pg_catalog, pg_toast, public?

tornoutlaw
Автор

Very useful. Thanks. Do you offer PostgreSQL training?

vitache
Автор

Mine just refuses to produce the file on dump though. Frustrating af.

Hashterix
Автор

Hello Guys, I am an Oracle/SQL Server DBA. Currently I've a requirement for configuring postgresql database. Which am new to this environment and want to manage the database(Backup, Restore, Health Check, Alerts monitor). Kindly assist me on this

jayaprakashduraisamy