pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedarchive_active file.
2+ messages / 2 participants
[nested] [flat]
* archive_active file.
@ 2020-09-29 17:40 Anthony, Craig Talmadge <craig@psu.edu>
2020-10-05 22:30 ` Re: archive_active file. David Steele <david@pgmasters.net>
0 siblings, 1 reply; 2+ messages in thread
From: Anthony, Craig Talmadge @ 2020-09-29 17:40 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
I recently built a postgresql 12 server and forgot to turn on WAL archiving. I modified my postgresql.conf file and stopped/started the server. After a day and many WAL files being generated archiving did not start until I found a suggestion to create and empty archive_active file in my archived WAL segments directory. When I did this archiving began. Does anyone know why archiving didn't start after the stop and restart and can anyone tell me that the archive_active file is a specific postgresql file or is it just that the archived WAL segments location has to have a file in it before archiving begins?
Thanks
Craig A.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: archive_active file.
2020-09-29 17:40 archive_active file. Anthony, Craig Talmadge <craig@psu.edu>
@ 2020-10-05 22:30 ` David Steele <david@pgmasters.net>
0 siblings, 0 replies; 2+ messages in thread
From: David Steele @ 2020-10-05 22:30 UTC (permalink / raw)
To: Anthony, Craig Talmadge <craig@psu.edu>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Hi Anthony,
On 9/29/20 1:40 PM, Anthony, Craig Talmadge wrote:
> I recently built a postgresql 12 server and forgot to turn on WAL
> archiving. I modified my postgresql.conf file and stopped/started the
> server. After a day and many WAL files being generated archiving did
> not start until I found a suggestion to create and empty archive_active
> file in my archived WAL segments directory. When I did this archiving
> began. Does anyone know why archiving didn't start after the stop and
> restart and can anyone tell me that the archive_active file is a
> specific postgresql file or is it just that the archived WAL segments
> location has to have a file in it before archiving begins?
More detail here would be good. What archive_command did you configure?
An archive_active file is not expected by core postgres so I suspect you
are either using an alternate distribution or an archive command that
requires this file.
Regards,
--
-David
david@pgmasters.net
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2020-10-05 22:30 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-09-29 17:40 archive_active file. Anthony, Craig Talmadge <craig@psu.edu>
2020-10-05 22:30 ` David Steele <david@pgmasters.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox