public inbox for [email protected]  

help / color / mirror / Atom feed

From: Adrian Klaver <[email protected]>
To: Rich Shepard <[email protected]>
To: [email protected]
Subject: Re: Restoring database from backup
Date: Fri, 13 Dec 2024 11:23:31 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>



On 12/13/24 11:18 AM, Rich Shepard wrote:
> On Fri, 13 Dec 2024, Adrian Klaver wrote:
> 
>> This needs more information:
>>
>> 1) Have you backed up your database at the current state?
> 
> Adrian,
> 
> No, the current state is FUBAR'd. The cron backup script runs each night at
> 11:15 p.m.
> 
>> 2) What command did you use to create bustrac-2024-12-12.sql?
> 
> !/usr/bin/bash
> #
> # This script pg_dump to save the database w/date stamp
> 
> cd /data1/database-backups/
> pg_dump -d bustrac -c -f bustrac-$(date +%Y-%m-%d).sql cd

Alright, from here:

https://www.postgresql.org/docs/current/app-pgdump.html

"-c
--clean

     Output commands to DROP all the dumped database objects prior to 
outputting the commands for creating them. This option is useful when 
the restore is to overwrite an existing database. If any of the objects 
do not exist in the destination database, ignorable error messages will 
be reported during restore, unless --if-exists is also specified.

     This option is ignored when emitting an archive (non-text) output 
file. For the archive formats, you can specify the option when you call 
pg_restore.
"

This means when you run the script with:

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

it will clean out the current corrupted objects and replace them with 
those in the backup file.


> 
> Thanks,
> 
> Rich
> 
> 

-- 
Adrian Klaver
[email protected]

view thread (4+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Restoring database from backup
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox