Timeline for PostgreSQL 16 pg_wal folder vs pg_wal\archive_status
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 11, 2024 at 21:00 | vote | accept | Student | ||
| Jan 11, 2024 at 20:59 | comment | added | Student | Appreciate your answers. Got the archive files up to data domain now. | |
| Jan 11, 2024 at 6:59 | comment | added | Laurenz Albe | I know little about Windows, but that sounds right. Even without being able to write to CIFS shares elsewhere, you must not archive it in the data directory, and certainly not in pg_wal. It is better to set archive_mode = off. | |
| Jan 10, 2024 at 20:14 | comment | added | Student | As for why I cannot write to UNC path; I think it's because my PostgreSQL service is running as Network Service and not an actual service account that has access to UNC path. Correct me if I'm wrong. | |
| Jan 10, 2024 at 20:13 | comment | added | Student | Thank you both for replying. @jjanes: I was not reading Oracle documentations and applying it to PostgreSQL. I applied Oracle terms / structures as I am learning PostgreSQL where I see similarities. As for the archive_command, I understand it needs to be out of the server, just in case the server crashes. However, I have not yet able to write it to UNC path \\<datafolder>\; and since this is a dev box, I'm temporarily archiving it to a location within pg_wal. | |
| Jan 10, 2024 at 7:30 | history | answered | Laurenz Albe | CC BY-SA 4.0 |