[Evergreen-dev] Postgres Database Mysery

[Brian Holda]

On my Evergreen Database server, in /var/lib/postgresql/

I have the following 4 directories:

1) 9.6.bak/ = 111GB, edits happening every minute
2) 10/ = 58GB, last edited a couple hours ago
3) 9.6/ = 45MB, last edited 1 year ago
4) backups/ = 2.2GB, last edited 2AM today

The stumper to me is the 9.6.bak. If we're using psql 10, and already have a backup directory updated daily, why are things actively writing to 9.6.bak/?

We need to free up some storage, and I was tempted to get rid of 9.6.bak, but don't want to without figuring out what is writing to it (and why).

If helpful, I find no instance of 9.6.bak in
ps -ef | grep postgres

But it did appear in
lsof +D /var/lib/postgresql/9.6.bak

Any clues?!

Thanks,
Brian


Brian Holda
Library Technology Manager
Hekman Library
Calvin University
(616) 526-8673

[cid:366e1c9b-3396-4be9-bd3e-7f981f95eb79]<https://library.calvin.edu/>


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.evergreen-ils.org/pipermail/evergreen-dev/attachments/20240710/f8c26e25/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Outlook-e1dwtvnk.png
Type: image/png
Size: 5783 bytes
Desc: Outlook-e1dwtvnk.png
URL: <http://list.evergreen-ils.org/pipermail/evergreen-dev/attachments/20240710/f8c26e25/attachment.png>