Search Postgresql Archives

Re: prevent WAL replication to fill filesystem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




Le 8 septembre 2021 06:07:15 GMT+02:00, Ninad Shah <nshah.postgres@xxxxxxxxx> a écrit :
>These suggestions are appropriate. However, if you are ready to lose your
>replica to keep production running, there are a couple of methods.
>
>1) Set archive_command to "/bin/true"
>2) rename .ready files in archive_status to .done.

You do not need to rename files in archive_status, especially after setting /bin/true. The normal production, if running, will soon enough clean everything, quickly.

A good advice is to never do writes in pg_wal yoursef (mv, rm, edit, etc).






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux