Conversation

Notices

1. Embed this notice
   on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ (lain@lain.com)'s status on Sunday, 12-Feb-2023 23:54:43 JST on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ

   • ilja
   • Sarvo
   • your new favourite fungus
   @ilja @sarvo @duponin i wonder if there's a way to tell pgdump to dump in a certain order (without changing the name)
   • Embed this notice
     ilja (ilja@ilja.space)'s status on Monday, 13-Feb-2023 00:07:05 JST ilja

     in reply to

     • ilja
     • Sarvo
     • your new favourite fungus
     @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.
     on-lain ✔ᵛᵉʳᶦᶠᶦᵉᵈ likes this.
   • Embed this notice
     ilja (ilja@ilja.space)'s status on Monday, 13-Feb-2023 00:07:09 JST ilja

     in reply to

     • Sarvo
     • your new favourite fungus

     @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