Backing up PostgreSQL users and groups (pg_dump and pg_dumpall)

[@KenSeedarnee]

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

[@Fr33manTV]

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

[@juancarlospastillo7417]

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

[@wackogames]

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?

[@tornoutlaw]

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?

[@yehiamcp]

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?

[@Hashterix]

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

[@IMADETHISACCFORRAY]

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.

[@postgrescourse]

No immediate plans to make a video covering that topic. However, almost all the binaries installed with PostgreSQL are simply client applications. Most of them have a "-h" option. That allows you to connect the client, in this case pg_dump, to a remote host. So, if you want to backup from RDS to a local server, you can simply run pg_dump on your local server and use "-h myrds-instance1.123456789012.us-east-1.rds.amazonaws.com" to connect to the remote RDS instance. The backup files will be created on the local server. From there, simply use cron to schedule the backup. There are several great backup utilities for PostgreSQL. However, for simple SQL backups of smaller databases, the approach above is easy to implement.

[@sajeevguru7151]

Thanks do you viedo for pg restore ?

[@vitache1276]

Very useful. Thanks. Do you offer PostgreSQL training?

[@postgrescourse]

Sure do - www.postgrescourse.com

[@jayaprakashduraisamy2184]

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

[@joaovictormello546]

Gretae Video!

[@QuinnFavo]

Helpful! Thanks

[@AmolGautam]

thanks

[@braydenwerner197]

thanks :)