From: Jerry Sievers <jerry.sievers@comcast.net>
To: M Kiesewetter <mskiesewetter@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Question about pg_xlog
References: 
 <CANBd27KCApuRST0smXH6f0MhOz=c8FiKtj5bVnWyiYzeD8wvhQ@mail.gmail.com>
Date: Tue, 18 Apr 2017 10:05:23 -0500
In-Reply-To: 
 <CANBd27KCApuRST0smXH6f0MhOz=c8FiKtj5bVnWyiYzeD8wvhQ@mail.gmail.com>
	(M. Kiesewetter's message of "Tue, 18 Apr 2017 16:36:07 +0200")
Message-ID: <87tw5lpxho.fsf@jsievers.enova.com>
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (gnu/linux)
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

M Kiesewetter <mskiesewetter@gmail.com> writes:

> Hi everyone,
>
> I'm new to Postgresql and have a test environment with Postgresql
> 9.4.5 running on Linux.
> Today I noticed that the pg_xlog was filled up to 18 Gb.
> I have:=C2=A0
> - wal_level=3Dhot_standby=C2=A0
> -=C2=A0wal_keep_segments =3D 100
> - hot_standby =3D on
> archive_mode =3D on
>
> It's a test environment en I did a pg_resetxlogs() on the 6th of
> April.
> I know that I shouldn't use this, and that it's only a last resort.
> When I look in de pg_xlog directory I see xlog files that are kept
> sinds that time.
> When i look at the archive_status directory I see that all of the
> files have the suffix of .done.
> All the other xlogs from the time before the resetlogs are cleaned up
> as I expected.
> But I don't understand why the other xlogs aren't recycled.

I'd start by looking for dormant replication slots.

select * from pg_replication_slots;

HTH

> I am looking for ways to find out why my pg_xlog is filling up.
> - I checked the alertlog of the postgresql instance --> no errors
> - I checked the WAL file location to see if the xlogs are being
> archived --> they are present
>
> Are there more ways to find out why my pg_xlog is filling up?
> Is the pg_resetxlogs the reason why the older xlogs are not recycled?
>
> I Hope that someone can help me.
> Thanks in advance.
> Regards,
> Mariane
>
>
>

--=20
Jerry Sievers
e: jerry.sievers@comcast.net
p: 312.241.7800


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin