From the course: PostgreSQL Essential Training
Join today to access over 24,400 courses taught by industry experts.
Backup and restore a database - PostgreSQL Tutorial
From the course: PostgreSQL Essential Training
Backup and restore a database
- [Instructor] The Postgres server does a lot of work to help you manage your data, but it can't do much to prevent hardware failures or natural disasters. Eventually, a hard drive will die or your computer will crash and cause catastrophic damage to your database. You need to be prepared for that eventuality by having a backup strategy in place that makes sure that your data is safe. To create a backup of your Postgres database, right click on the database in the browser tree, I'll choose the kinetico database here, and then click Backup. The first thing we need to do is choose a file location where the backup will get saved. I'll click this folder to browse out to my system and I'm just going to place a copy of this on my desktop. I'll give it the file name kinetico april backup. You can give this file whatever file extension you'd like but comment extensions are either .SQL or .backup. It really doesn't matter what you…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
