Re: [NOVICE] Issues shutting down PostgreSQL 10 cleanly - Mailing list pgsql-novice

From Simon Riggs
Subject Re: [NOVICE] Issues shutting down PostgreSQL 10 cleanly
Date
Msg-id CANP8+j+V0YdpHrajLm9TmHMVb6Lq=f6nE5pU=X-v0RnjbUPb+Q@mail.gmail.com
Whole thread Raw
In response to [NOVICE] Issues shutting down PostgreSQL 10 cleanly  (Stephen Froehlich <s.froehlich@cablelabs.com>)
List pgsql-novice
On 23 October 2017 at 15:23, Stephen Froehlich
<s.froehlich@cablelabs.com> wrote:
> I am in the midst of heavy, large write operations on a new database this is
> currently around 23 billion lines.
>
> My max_wal_size is 256 GB and my checkpoint_timeout is 12 hours. (Smaller
> values were hindering the writes.) Note: this is on Ubuntu 16.04 LTS.
>
> I am having trouble shutting down postgres cleanly – how can I fix that?

The time to shutdown will be longer than normal with those settings.

--
Simon Riggs                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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

pgsql-novice by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: [NOVICE] Issues shutting down PostgreSQL 10 cleanly
Next
From: Laurenz Albe
Date:
Subject: Re: [NOVICE] New Version Errors