From the course: Database Foundations: Administration

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create a PostgreSQL backup

Create a PostgreSQL backup

From the course: Database Foundations: Administration

Start my 1-month free trial

Create a PostgreSQL backup

“

- [Instructor] The PostgreSQL platform uses a program called PG dump, for creating a database backup. It's usually executed on the command line, but graphical user interfaces, such as Azure Data Studio, often provide a workflow that'll help you through some of the many configuration options that PG dump supports. To get there, let's right click on the two trees database that's inside of the PostgreSQL server, and choose manage. Then on the toolbar, click on the backup button. That'll open up the backup database panel, here on the right side of the screen. At the top are two of the general options that are both required. We need to specify a backup type and an output path. The backup type has a few different options. The SQL file will create a plain text file that's easy to read, so I'm going to stick with that option. The alpha path defines where the file is going to be saved. Now there's one important thing to keep in mind…

Contents