Conversation

Notices

1. LS (lain@lain.com)'s status on Sunday, 12-Feb-2023 23:54:24 JST LS

   • ilja :pumpkin_owo:
   • HW Y2K-CHECKED FUNGUS
   • Shrek
   @ilja @sarvo @duponin i wonder if there's a way to tell pgdump to dump in a certain order (without changing the name)
   • ilja :pumpkin_owo: (ilja@ilja.space)'s status on Monday, 13-Feb-2023 00:06:46 JST ilja :pumpkin_owo:

     in reply to

     • ilja :pumpkin_owo:
     • HW Y2K-CHECKED FUNGUS
     • Shrek
     @lain @duponin @sarvo I was also thinking for a while that maybe postgresql should be more smarter in dumping, but then I realised that this is really just a very edge-case thing, so I didn't bother filing a feature request for it.
     LS likes this.
   • ilja :pumpkin_owo: (ilja@ilja.space)'s status on Monday, 13-Feb-2023 00:06:48 JST ilja :pumpkin_owo:

     in reply to

     • HW Y2K-CHECKED FUNGUS
     • Shrek

     @lain @sarvo @duponin Not that I could find. What I did find is that you can pass a list with what you want to restore and in what order. But it still takes some extra steps and even with these steps added to the docs, people still just did a dump and restore like they were used to (and then understandably still complained that restoration goes super slow).

     To get the list

     pg_restore -l pleroma.pgdump > db.list

     Then find the line where the index is restored and move it. Then restore using the new list with

     sudo -Hu postgres pg_restore -L db.list -d pleroma -v -1 pleroma.pgdump