Postgres Pro
Downloads
Home   >   mailing lists

Restoring database from backup - Mailing list pgsql-general

From Rich Shepard
Subject Restoring database from backup
Date
Msg-id d97a8613-3b55-4a5b-887f-db7d2923c4ab@appl-ecosys.com
Whole thread Raw
Responses Re: Restoring database from backup
List pgsql-general
Tree view 
I made a careless error this morning and want to restore the database from
yesterday's backup, `bustrac-2024-12-12.sql'. If I run

psql -d bustrac -f bustrac-2024-12-12.sql

will this restore the database to yesterday's status without first
deleting/removing the FUBAR'd one?

TIA,

Rich

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Errors when restoring backup created by pg_dumpall
Next
From: Adrian Klaver
Date:
Subject: Re: Restoring database from backup