课程: Database Foundations: Administration

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

Create a PostgreSQL backup

Create a PostgreSQL backup

课程: Database Foundations: Administration

开始一个月试用 购买团队方案

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…

内容