6. Postgres Administration - Restore database - dvdrental
Download and restore dvdrental database in postgres
#Create dvdrental database
create database dvdrental
#quit from postgres instance
\q
#Download dvdrental backup file
sudo curl -O https://www.postgresqltutorial.com/wp...
#Install unzip
sudo apt install unzip
#unzip dvdrental.zip
sudo unzip /home/postgres/dvdrental.zip
#Restore database
pg_restore --dbname-dvdrental --verbose /home/postgres/dvdrental.tar
#connect to postgres instance
psql
#Change the database context to dvdrental
\c dvdrental
#List out tables
\dt
#select one row from actor table
select * from actor limit 1;