Search Postgresql Archives

Re: Begginers question

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

 





On 16 August 2017 at 16:16, Michael Paquier <michael.paquier@xxxxxxxxx> wrote:
On Wed, Aug 16, 2017 at 2:32 PM, Alex Samad <alex@xxxxxxxxxxxx> wrote:
> 1) why did it fill up this time and not previously
> I add this
> archive_command = '/bin/true'
> wal_keep_segments = 1000 # <<< I'm guessing its this
>
> 2) how do I fix up, can I just remove the files from the pg_xlog directory

Don't do that. those files are managed by Postgres so you may finish
with a corrupted cluster. Instead you should lower the value of

Too late, its okay its a learning experience.
 
wal_keep_segments, reload the server parameters, and then enforce two
checkpoints to force WAL segments to be recycled. Note that this

how do I force check points
 
depends also on the values of checkpoint_segments
(max_wal_size/min_wal_size in Postgres 9.5 and onwards).
--
Michael

thanks

[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 Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux