Re: Backup and Restore (pg_dump & pg_restore) - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Backup and Restore (pg_dump & pg_restore)
Date
Msg-id 7c503445-2da0-db3c-5345-e814b6ce97f9@aklaver.com
Whole thread Raw
In response to Re: Backup and Restore (pg_dump & pg_restore)  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
On 4/21/19 2:20 PM, Ron wrote:

>> I see this sort of thing in monitoring systems e.g. environmental 
>> controls all the time. Things get flagged because they wander over set 
>> points intermittently. It is technically an error but unless they stay 
>> over the line it is just another data point.
> 
> Errors need to be fixed.  If the restore can proceed without harm, then 
> it's an Informational message.

That is a choice thing:

https://www.postgresql.org/docs/11/app-pgrestore.html

"
-e
--exit-on-error

     Exit if an error is encountered while sending SQL commands to the 
database. The default is to continue and to display a count of errors at 
the end of the restoration.
"



It is also one of those eye of the beholder things as evidenced by:

https://www.postgresql.org/docs/11/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT

Severity     Usage             syslog         eventlog
...
ERROR         Reports an error ...     WARNING     ERROR
...

Edited to keep on one line.


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: legrand legrand
Date:
Subject: Re: Display View Columns and Their Source Tables and Columns
Next
From: Laurenz Albe
Date:
Subject: Re: Display View Columns and Their Source Tables and Columns