| 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: | Whole Thread | Raw Message | 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
>
| 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 |