Re: HELP!!! The WAL Archive is taking up all space

From: FattahRozzaq <ssoorruu(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: HELP!!! The WAL Archive is taking up all space
Date: 2015-12-10 00:38:51
Message-ID: CAKnA-A1oqYft4scSOmv6==z+Uk5boVoZ3F_z3f5_2sAKDPDn5g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Quick information,

After I realize, the line "archive_command=/bin/true" is a bad
decision, I have revert it back.
Now I'm really confused and panic.
I don't know what to do, and I don't really understand the postgresql.conf
I'm a network engineer, I should handle the network and also
postgresql database.
Oh man, the office is so good but this part is sucks :((

--
On 10/12/2015, FattahRozzaq <ssoorruu(at)gmail(dot)com> wrote:
> Hi John,
>
> I really don't know why I should keep the wal archives.
> I implement streaming replication into 1 server (standby server).
> I'm really newbie to PostgreSQL but the boss pushed me to handle it
> and implement it in production f*&%*$%%$#%$#&# (forgive me)
> They don't hire a database expert, I don't know why.
>
> Hi Alan,
> I have no problem with pg_xlog size which is only 67GB.
> My issue is with the archive folder size.
> I've read in this blog:
> http://blog.endpoint.com/2014/09/pgxlog-disk-space-problem-on-postgres.html
> And I change the archive_command into: archive_command = '/bin/true'
> Is it a bad decision?
>
> Hi Adrian,
> Thank you very much for the suggestion. is pgarchivecleanup harmful?
> Do you have a pgarchivecleanup example for my case?
> How to run a dry-run?
>
>
> Thank you,
> Fattah
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2015-12-10 00:46:33 Re: HELP!!! The WAL Archive is taking up all space
Previous Message FattahRozzaq 2015-12-10 00:27:17 Re: HELP!!! The WAL Archive is taking up all space