archive_active file.

From: "Anthony, Craig Talmadge" <craig(at)psu(dot)edu>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: archive_active file.
Date: 2020-09-29 17:40:15
Message-ID: MN2PR02MB6383FA2DDD323578E2B452ABA8320@MN2PR02MB6383.namprd02.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Erik Serrano 2020-09-29 19:45:46 Re: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces
Previous Message Keith 2020-09-29 14:54:31 Re: Upgrade 9.2 to 9.6 without modifying the location of the tablespaces