Restore Postgres DB

#1

Hey,

I recently look a backup of a DB in render.com. I would like to restore that to a database now, how would I do this?

#2

Hi Nayan,

Thanks for reaching out.

An example restoring a backup is covered in the Render PostgreSQL Backups documentation:

# first unzip the backup filegzip -d $backup_file# then restore this backup to your database using its external connection string available in the dashboard.psql $external_connection_string -f $backup_file

Please let us know if you have any more questions.

Kind regards

Alan