From the course: PostgreSQL: Client Applications

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Create backups with pg_dump

Create backups with pg_dump - PostgreSQL Tutorial

From the course: PostgreSQL: Client Applications

Start my 1-month free trial Buy for my team

Create backups with pg_dump

“

- [Instructor] We've been focused primarily on the PSQL client application. And it really is the primary workhorse of these set of utilities. But there are a couple of additional tools that anyone that manages a Postgres SQL database needs to be familiar with. They are indispensable for, arguably, the most important database maintenance task. Creating regular backups and being able to restore those backups when needed. Let me start up a brand new PowerShell or terminal window and we'll take a look. First, we're going to use the PG_dump utility. This application is used to export backups of a single database from a PostGres server. In fact, when you use the PG admin graphical interface for Postgres and create a database backup using those dialog windows, the PG dump application is being executed in the background to actually perform those tasks. So it makes sense to effectively cut out the middleman and see how to work…

Contents