pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedArchive cleanup
7+ messages / 5 participants
[nested] [flat]
* Archive cleanup
@ 2021-07-04 19:36 pgdba pgdba <postgresdba12@outlook.com>
2021-07-06 15:20 ` Re: Archive cleanup Jeff Janes <jeff.janes@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: pgdba pgdba @ 2021-07-04 19:36 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Hi,
My wal is copy in archive directory but archive directory always used more disk how to Automaticly cleanup my archive directory for oldest backup file
Ex:
pg_archivecleanup -d /home/transaction/inst5/transactionlog 000000010000000F00000026.backup
Thanks
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Archive cleanup
2021-07-04 19:36 Archive cleanup pgdba pgdba <postgresdba12@outlook.com>
@ 2021-07-06 15:20 ` Jeff Janes <jeff.janes@gmail.com>
0 siblings, 0 replies; 7+ messages in thread
From: Jeff Janes @ 2021-07-06 15:20 UTC (permalink / raw)
To: pgdba pgdba <postgresdba12@outlook.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
On Sun, Jul 4, 2021 at 3:37 PM pgdba pgdba <postgresdba12@outlook.com>
wrote:
> Hi,
> My wal is copy in archive directory but archive directory always used more
> disk how to Automaticly cleanup my archive directory for oldest backup file
> Ex:
> pg_archivecleanup -d /home/transaction/inst5/transactionlog
> 000000010000000F00000026.backup
>
Whatever deletes your .backup file such that a different one becomes the
oldest one should handle that. What is it that does that?
Cheers,
Jeff
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Archive cleanup
@ 2023-08-04 09:03 Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-08-04 13:48 ` Re: Archive cleanup Jeff Janes <jeff.janes@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Rajesh Kumar @ 2023-08-04 09:03 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hi friends,
Anybody let me know how to automate the archive clean up in postgres.
Regards,
Kumar
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Archive cleanup
2023-08-04 09:03 Archive cleanup Rajesh Kumar <rajeshkumar.dba09@gmail.com>
@ 2023-08-04 13:48 ` Jeff Janes <jeff.janes@gmail.com>
2023-08-06 00:36 ` Re: Archive cleanup Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-08-07 14:28 ` Re: Archive cleanup Stephen Frost <sfrost@snowman.net>
0 siblings, 2 replies; 7+ messages in thread
From: Jeff Janes @ 2023-08-04 13:48 UTC (permalink / raw)
To: Rajesh Kumar <rajeshkumar.dba09@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
On Fri, Aug 4, 2023 at 5:04 AM Rajesh Kumar <rajeshkumar.dba09@gmail.com>
wrote:
> Hi friends,
>
> Anybody let me know how to automate the archive clean up in postgres.
>
If the only reason you have an archive is so a standby can get the WAL,
then you can just use a slot instead. If you don't have an archive, you
don't need to clean it up.
If you are using the archive for something else, you would need to tell us
what that is. Otherwise, you are just asking "how long is a piece of
string"?
Cheers,
Jeff
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Archive cleanup
2023-08-04 09:03 Archive cleanup Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-08-04 13:48 ` Re: Archive cleanup Jeff Janes <jeff.janes@gmail.com>
@ 2023-08-06 00:36 ` Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-08-06 00:44 ` Re: Archive cleanup Ron <ronljohnsonjr@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: Rajesh Kumar @ 2023-08-06 00:36 UTC (permalink / raw)
To: Jeff Janes <jeff.janes@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
Archive is must for point in time recovery right?
On Fri, 4 Aug 2023 at 06:48, Jeff Janes <jeff.janes@gmail.com> wrote:
> On Fri, Aug 4, 2023 at 5:04 AM Rajesh Kumar <rajeshkumar.dba09@gmail.com>
> wrote:
>
>> Hi friends,
>>
>> Anybody let me know how to automate the archive clean up in postgres.
>>
>
> If the only reason you have an archive is so a standby can get the WAL,
> then you can just use a slot instead. If you don't have an archive, you
> don't need to clean it up.
>
> If you are using the archive for something else, you would need to tell us
> what that is. Otherwise, you are just asking "how long is a piece of
> string"?
>
> Cheers,
>
> Jeff
>
>>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Archive cleanup
2023-08-04 09:03 Archive cleanup Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-08-04 13:48 ` Re: Archive cleanup Jeff Janes <jeff.janes@gmail.com>
2023-08-06 00:36 ` Re: Archive cleanup Rajesh Kumar <rajeshkumar.dba09@gmail.com>
@ 2023-08-06 00:44 ` Ron <ronljohnsonjr@gmail.com>
0 siblings, 0 replies; 7+ messages in thread
From: Ron @ 2023-08-06 00:44 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Use PgBackRest, and make your life a *lot* easier.
On 8/5/23 19:36, Rajesh Kumar wrote:
> Archive is must for point in time recovery right?
>
> On Fri, 4 Aug 2023 at 06:48, Jeff Janes <jeff.janes@gmail.com> wrote:
>
> On Fri, Aug 4, 2023 at 5:04 AM Rajesh Kumar
> <rajeshkumar.dba09@gmail.com> wrote:
>
> Hi friends,
>
> Anybody let me know how to automate the archive clean up in postgres.
>
>
> If the only reason you have an archive is so a standby can get the
> WAL, then you can just use a slot instead. If you don't have an
> archive, you don't need to clean it up.
>
> If you are using the archive for something else, you would need to
> tell us what that is. Otherwise, you are just asking "how long is a
> piece of string"?
>
> Cheers,
>
> Jeff
>
--
Born in Arizona, moved to Babylonia.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Archive cleanup
2023-08-04 09:03 Archive cleanup Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-08-04 13:48 ` Re: Archive cleanup Jeff Janes <jeff.janes@gmail.com>
@ 2023-08-07 14:28 ` Stephen Frost <sfrost@snowman.net>
1 sibling, 0 replies; 7+ messages in thread
From: Stephen Frost @ 2023-08-07 14:28 UTC (permalink / raw)
To: Jeff Janes <jeff.janes@gmail.com>; Rajesh Kumar <rajeshkumar.dba09@gmail.com>; Ron <ronljohnsonjr@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
Greetings,
* Jeff Janes (jeff.janes@gmail.com) wrote:
> On Fri, Aug 4, 2023 at 5:04 AM Rajesh Kumar <rajeshkumar.dba09@gmail.com>
> wrote:
> > Anybody let me know how to automate the archive clean up in postgres.
>
> If the only reason you have an archive is so a standby can get the WAL,
> then you can just use a slot instead. If you don't have an archive, you
> don't need to clean it up.
No, archives are critical for online backups and PITR, not just so that
you can make sure the standby is able to catch up (but that's a very
nice additional bit that archives provide).
* Rajesh Kumar (rajeshkumar.dba09@gmail.com) wrote:
> Archive is must for point in time recovery right?
Yes.
* Ron (ronljohnsonjr@gmail.com) wrote:
> Use PgBackRest, and make your life a *lot* easier.
Agreed.
Thanks,
Stephen
Attachments:
[application/pgp-signature] signature.asc (832B, ../../ZND%2Fl7xnBsxdJfwp@tamriel.snowman.net/2-signature.asc)
download
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2023-08-07 14:28 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-07-04 19:36 Archive cleanup pgdba pgdba <postgresdba12@outlook.com>
2021-07-06 15:20 ` Jeff Janes <jeff.janes@gmail.com>
2023-08-04 09:03 Archive cleanup Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-08-04 13:48 ` Jeff Janes <jeff.janes@gmail.com>
2023-08-06 00:36 ` Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-08-06 00:44 ` Ron <ronljohnsonjr@gmail.com>
2023-08-07 14:28 ` Stephen Frost <sfrost@snowman.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox