Breaking News: Grepper is joining You.com. Read the official announcement!

How to Restore PostgreSQL Data using PSQL Command?

Vivacious Vulture answered on November 20, 2022 Popularity 3/10 Helpfulness 4/10

answer How to Restore PostgreSQL Data using PSQL Command?

How to Restore PostgreSQL Data using PSQL Command?

Comment

psql -U username -f backupfile.sql

Popularity 3/10 Helpfulness 4/10 Language sql

Source: hevodata.com

Tags: postgresql psql restore using whatever

Link to this answer
Share Copy Link

Contributed on May 05 2023

Vivacious Vulture

0 Answers Avg Quality 2/10

Closely Related Answers

postgresql restore from bak

Comment

pg_restore -h localhost -d Performace_Test -U postgres -p 5432 "D:\Database Backup\temp.bak"

Popularity 10/10 Helpfulness 5/10 Language sql

Source: stackoverflow.com

Tags: postgresql p

Link to this answer
Share Copy Link

Contributed on Nov 20 2022

Inquisitive Ibis

0 Answers Avg Quality 2/10

postgresql restore

Comment

# Physical Restore---------------------------
# stop the server 
systemctl stop postgresql
# Delete the current data directory
rm -rf /var/lib/postgresql/13/main
# Copy the backup directory to the PostgreSQL data directory
cp -r /var/backups/postgresql/main /var/lib/postgresql/13/
# Set the correct ownership and permissions on the files in the new data directory
chown -R postgres:postgres /var/lib/postgresql/13/main
chmod 700 /var/lib/postgresql/13/main
# Start the server
systemctl start postgresql

# Logical Restore----------------------------
# Create a new database to restore the backup:
createdb -U postgres mydatabase_new
# Restore the backup file to the new database:
psql -U postgres -d mydatabase_new -f mydatabase_backup.sql
# Verify that the data has been restored
psql -U postgres -d mydatabase_new
\dt
SELECT * FROM mytable;

# Point in time Restore-----------------------
# Create a new database to restore the backup
createdb -h localhost -U postgres -e mydatabase_new
# Restore the backup file to the new database
psql -h localhost -U postgres -d mydatabase_new -f mydatabase_backup.sql

# Differential Restore--------------------------
# restore the full backup
pg_restore --username=username --dbname=dbname --verbose full_backup.dump
# restore the differential backup
pg_restore --username=username --dbname=dbname --verbose diff_backup.dump

# Incremental Restore--------------------------------
# restore the full backup
pg_restore -U username -d dbname full_backup.sql
# restore the incremental backup
pg_basebackup -D /path/to/restored/database --incremental -X stream -P -F p -z -v -h localhost -U username --restore-command="psql -U username -d dbname -f %f"

Popularity 9/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: postgresql p

Link to this answer
Share Copy Link

Contributed on Mar 07 2023

Innocent Iguana

0 Answers Avg Quality 2/10

How to Restore PostgreSQL Data using PSQL Command?

Contents

More Related Answers

How to Restore PostgreSQL Data using PSQL Command?

Closely Related Answers

postgresql restore from bak

postgresql restore

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.