Clean Postgres shutdown

From: Yambu <hyambu(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Clean Postgres shutdown
Date: 2021-01-19 10:10:02
Message-ID: CALhHtcAGLdoh5EOtO=rK8kxuz39FuU6CMuhQCd=xaXGz4ZM7yw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello

Is there a clean way to shutdown postgres which completes transactions and
does not abort them.

I ran #systemctl stop postgresql-10

2021-01-18 14:31:28.600 GMT [10594] LOG: received fast shutdown request
2021-01-18 14:31:28.603 GMT [10594] LOG: aborting any active transactions
2021-01-18 14:31:28.607 GMT [10594] LOG: worker process: logical
replication launcher (PID 10604) exited with exit code 1
2021-01-18 14:31:28.613 GMT [10598] LOG: shutting down
2021-01-18 14:31:28.634 GMT [23850] FATAL: the database system is shutting
down
2021-01-18 14:31:29.119 GMT [10594] LOG: database system is shut down

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Anjul Tyagi 2021-01-19 10:21:27 Table Partitioning
Previous Message Amine Tengilimoglu 2021-01-19 10:02:55 Re: planned switch over master/slave