ick Otten
> Sent: Thursday, March 2, 2017 08:19
> To: Dinesh Chandra 12108
> Cc: pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] How Can I check PostgreSQL backup is successfully or
> not ?
>
> This reminds me - I have had a case where the exit code for pg_dump w
<rottenwindf...@gmail.com>; Dinesh Chandra 12108
<dinesh.chan...@cyient.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] How Can I check PostgreSQL backup is successfully or not
?
It'd be so nice to have some checks to guarantee the backup is trustworthy.
Restoring th
Subject: Re: [PERFORM] How Can I check PostgreSQL backup is successfully or not
?
This reminds me - I have had a case where the exit code for pg_dump was
successful, but the backup was still corrupted on disk. By all means check the
exit code, but I strong encourage a second validation
]
Sent: 02 March, 2017 6:45 PM
To: Dinesh Chandra 12108 <dinesh.chan...@cyient.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] How Can I check PostgreSQL backup is successfully or not
?
This reminds me - I have had a case where the exit code for pg_dump was
succ
gt;; Dinesh Chandra 12108 <
> dinesh.chan...@cyient.com>; pgsql-performance@postgresql.org;
> pgsql-performance-ow...@postgresql.org
> Subject: Re: [PERFORM] How Can I check PostgreSQL backup is successfully
> or not ?
>
> On 2017-02-27 14:29, John Gorman wrote:
> > Even
]
Sent: 27 February, 2017 7:31 PM
To: John Gorman <jgor...@eldocomp.com>
Cc: Rick Otten <rottenwindf...@gmail.com>; Dinesh Chandra 12108
<dinesh.chan...@cyient.com>; pgsql-performance@postgresql.org;
pgsql-performance-ow...@postgresql.org
Subject: Re: [PERFORM] How Can I
ttenwindf...@gmail.com>; Dinesh Chandra 12108
<dinesh.chan...@cyient.com>; pgsql-performance@postgresql.org;
pgsql-performance-ow...@postgresql.org
Subject: Re: [PERFORM] How Can I check PostgreSQL backup is successfully or not
?
On 2017-02-27 14:29, John Gorman wrote:
> Even though i
sql-performance-ow...@postgresql.org
[mailto:pgsql-performance-ow...@postgresql.org] ON BEHALF OF Rick
Otten
SENT: Monday, February 27, 2017 3:36 AM
TO: Dinesh Chandra 12108
CC: pgsql-performance@postgresql.org
SUBJECT: Re: [PERFORM] How Can I check PostgreSQL backup is
successfully or not ?
Altho
org
[mailto:pgsql-performance-ow...@postgresql.org] On Behalf Of Rick Otten
Sent: Monday, February 27, 2017 3:36 AM
To: Dinesh Chandra 12108
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] How Can I check PostgreSQL backup is successfully or not
?
Although it doesn't really tell if the pg_d
Although it doesn't really tell if the pg_dump was successful (you'll need
to do a full restore to be sure), I generate an archive list. If that
fails, the backup clearly wasn't successful, and if it succeeds, odds are
pretty good that it worked:
-- bash code snippet --
archiveList=`pg_restore
Hi,
We are taking daily full backup of PostgreSQL database using PG_DUMP which is
automatic scheduled through Cronjobs.
How can I check my yesterday backup is successfully or not?
Is there any query or view by which I can check it?
Regards,
Dinesh Chandra
|Database administrator
11 matches
Mail list logo