Re: archive_command during database shutdown
| От | Sameer Kumar |
|---|---|
| Тема | Re: archive_command during database shutdown |
| Дата | |
| Msg-id | CADp-Sm5fmCjAJK9Jv19Gs9G+MVg4Lz276Q4DB6gK0MUKeJjQoQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | archive_command during database shutdown (Jeff Janes <jeff.janes@gmail.com>) |
| Ответы |
Re: archive_command during database shutdown
|
| Список | pgsql-general |
On Thu, 26 May 2016, 1:25 a.m. Jeff Janes, <jeff.janes@gmail.com> wrote:
I've recently wanted to run a different archive_command during
database shutdown than during normal operations. In particular, if
the normal archive process fails during normal operations, I want it
to be retried later (as it currently does). But if it fails during
shutdown, I want it to run a fallback archive_command.
What version of PostgreSQL are you using?
The only way I can see to accomplish this is to have the
archive_command try to connect back to the database and see if it gets
an error. That seems pretty ugly. Is there a better way?
What's your goal here?
During a shutdown, if you don't so much care about checkpoint and fsync of buffers to disk, you can do an immediate shutdown.
Cheers,
Jeff
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
--
Best Regards
Sameer Kumar | DB Solution Architect
ASHNIK PTE. LTD.
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
В списке pgsql-general по дате отправления: