Post AVNomdrpz558kJfeFM by Twelve@fosstodon.org
 (DIR) More posts by Twelve@fosstodon.org
 (DIR) Post #AVNoBQCbpMK9eNdeC0 by stanford@social.arclight.pro
       2023-05-06T15:58:24Z
       
       0 likes, 0 repeats
       
       How is it possible that a posgres DB is unable to write data on the disk but still runs flawlessly without throwing any errors? :blobcatthinkingglare:​Well, except for the fact that once you restart it, all the data is lost.. :blobcatverysad:​
       
 (DIR) Post #AVNomdrpz558kJfeFM by Twelve@fosstodon.org
       2023-05-06T16:05:08Z
       
       0 likes, 0 repeats
       
       @stanford thats how its been for me too. Sadly I don't know how to fix it. It does seem that restarting the system it is ok with?
       
 (DIR) Post #AVNqjtD0gjUJMmOCMy by stanford@social.arclight.pro
       2023-05-06T16:27:02Z
       
       0 likes, 0 repeats
       
       @Twelve Today, I did some maintenance and needed to restart the server for it.After the restart, the data of the last 2 weeks were lost.I do daily backups of the whole VM, so I tried to restore the backup, but I've got the same issue here too.After some investigation, I've discovered that there was something wrong the rights of the filesystem, so postgres was unable to write data to the disk.But I really don't understand why Postgres never complained about that... I somehow expect a database software to have some sort of error if it is unable to write new database entries to the disk..
       
 (DIR) Post #AVNr0XAtrazpx5L5MG by Twelve@fosstodon.org
       2023-05-06T16:30:06Z
       
       0 likes, 0 repeats
       
       @stanford id imagen too it will spue an error for beeing unable to save anything. But this does remind me I should probobly do some server maintence