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

postgresql restore

Innocent Iguana answered on November 20, 2022 Popularity 9/10 Helpfulness 4/10

answer postgresql restore

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 restore sql

Link to this answer
Share Copy Link

Contributed on Mar 07 2023

Innocent Iguana

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 9/10 Helpfulness 4/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 backup database

Comment

psql anyparts < anyparts.psql

Popularity 9/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: backup ba

Link to this answer
Share Copy Link

Contributed on Jun 23 2023

Uninterested Unicorn

0 Answers Avg Quality 2/10

postgresql restore

Contents

More Related Answers

postgresql restore

Closely Related Answers

postgresql restore from bak

postgresql restore backup database

Grepper

Documentation

Social

Legal

Contact

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