From: | David Steele <david(at)pgmasters(dot)net> |
---|---|
To: | "Anthony, Craig Talmadge" <craig(at)psu(dot)edu>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: archive_active file. |
Date: | 2020-10-05 22:30:29 |
Message-ID: | 2226e1d4-979f-3e2a-7225-cd2efa5ae5e7@pgmasters.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)pgmasters(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Naveen Kumar | 2020-10-06 05:55:27 | How to return multiple rows by stored procedure in postgresql |
Previous Message | Holger Jakobs | 2020-10-05 20:00:14 | Re: not able to install pgadmin4 on RHEL8 |