> On Apr 1, 2019, at 9:20 PM, Rene Romero Benavides <rene.romer...@gmail.com>
> wrote:
>
>
> On Mon, Apr 1, 2019 at 6:30 PM Rene Romero Benavides <rene.romer...@gmail.com
> <mailto:rene.romer...@gmail.com>> wrote:
>
> On Sat, Mar 30, 2019 at 5:03 PM Gmail <robjsarg...@gmail.com
> <mailto:robjsarg...@gmail.com>> wrote:
>
>
> > On Mar 30, 2019, at 10:54 AM, Gmail <robjsarg...@gmail.com
> > <mailto:robjsarg...@gmail.com>> wrote:
> >
> >
> >>>> On Mar 29, 2019, at 6:58 AM, Michael Paquier <mich...@paquier.xyz
> >>>> <mailto:mich...@paquier.xyz>> wrote:
> >>>
> >>> On Thu, Mar 28, 2019 at 09:53:16AM -0600, Rob Sargent wrote:
> >>> This is pg10 so it's pg_wal. ls -ltr
> >>>
> >>>
> >>> -rw-------. 1 postgres postgres 16777216 Mar 16 16:33
> >>> 0000000100000CEA000000B1
> >>> -rw-------. 1 postgres postgres 16777216 Mar 16 16:33
> >>> 0000000100000CEA000000B2
> >>>
> >>> ... 217 more on through to ...
> >>>
> >>> -rw-------. 1 postgres postgres 16777216 Mar 16 17:01
> >>> 0000000100000CEA000000E8
> >>> -rw-------. 1 postgres postgres 16777216 Mar 16 17:01
> >>> 0000000100000CEA000000E9
> >>> -rw-------. 1 postgres postgres 16777216 Mar 28 09:46
> >>> 0000000100000CEA0000000E
> > I’m now down to 208 Mar 16 WAL files so they are being processed (at least
> > deleted). I’ve taken a snapshot of the pg_wal dir such that I can see
> > which files get processed. It’s none of the files I’ve listed previously
>
> Two more have been cleaned up. 001C and 001D generated at 16:38 Mar 16
>
>
>
> Please share your complete postgresql.conf file and the results from this
> query:
> SELECT * FROM pg_settings;
> has someone in the past configured wal archiving?
> You've ran out of disk space as this log message you shared states:
> No space left on device
> what's the output of df -h
>
> --
> El genio es 1% inspiración y 99% transpiración.
> Thomas Alva Edison
> http://pglearn.blogspot.mx/ <http://pglearn.blogspot.mx/>
>
>
> BTW , how spread apart are checkpoints happening? do you have stats on that?
> maybe they're too spread apart and that's why WAL files cannot be recycled
> rapidly enough?
> --
> El genio es 1% inspiración y 99% transpiración.
> Thomas Alva Edison
> http://pglearn.blogspot.mx/ <http://pglearn.blogspot.mx/>
>
two attempts (one in-line, one with attachement) at sending postgresql.conf and
pg_settings report have been sent to a moderator.
