Post B634C1JywpZi4MAMRE by cjd@pkteerium.xyz
 (DIR) More posts by cjd@pkteerium.xyz
 (DIR) Post #B632jcEWWzoeCJVMGG by Zergling_man@sacred.harpy.faith
       0 likes, 0 repeats
       
       pg_dump will, by default, give up on error, and has no option to tell it to ignore and continue.pg_restore will, by default, continue and display a count of errors at the end of the restoration, and has a flag to make it exit immediately instead.
       
 (DIR) Post #B634C1JywpZi4MAMRE by cjd@pkteerium.xyz
       0 likes, 0 repeats
       
       `zfs snapshot` is instant and can be run without stopping the database :]
       
 (DIR) Post #B634C1TuLvVyZ8oHuS by Zergling_man@sacred.harpy.faith
       0 likes, 0 repeats
       
       @cjd This doesn't help when the db is broken.
       
 (DIR) Post #B634CifllhYKWNgrrs by rozenglass@fedi.dreamscape.link
       1 likes, 0 repeats
       
       @Zergling_man@sacred.harpy.faith @cjd@pkteerium.xyz so is lvcreate --snapshot if you're okay with the near doubled IOPS temporarily while you take your backup off the mounted consistent snapshot using any normal backup software.
       
 (DIR) Post #B634nLR57qBzATHhlg by cjd@pkteerium.xyz
       1 likes, 0 repeats
       
       Oh yeaaaaahhhhh, broken postgres is the funnest thing ever.I used to have a postgres in a folder that was mounted ... and I mounted it while it was running, that made for some really fun problems.
       
 (DIR) Post #B635cOiChjTa66dZMu by Zergling_man@sacred.harpy.faith
       0 likes, 0 repeats
       
       @cjd I did what is probably roughly the same thing; I shut it down, moved the folder so I could do an upgrade, systemd did systemd shit and pg started writing to new files, and everything has been a little screwed since.oban_peers has some read error that is different to the error coming out of the users table. I am pretty sure I don't need oban_peers, I'm pretty sure I don't need 6mil oban_jobs either.users table can read ap_id on all rows, but can't read all fields on all rows. Even if I figure out which column it's in (tedious), if it's a necessary column (as if any aren't), I still have to figure out which row is causing the problem ........ which I can do by just select * from users order_by something limit binary_search;...