Conversation

Notices

1. Embed this notice
   midway (midway@soapbox.midwaytrades.com)'s status on Saturday, 15-Jul-2023 11:26:53 JST midway

   • Alex Gleason
   Hey @alex
   
   So I'm trying to migrate my instance to another box. Install is easy enough, but then I try to migrate my database.
   
   I stop pleroma on the source
   I run a backup: sudo -Hu pleroma pg_dump -Fc pleroma > <file>
   
   Then I move the file over to the new box and try to restore it:
   
   sudo -Hu pleroma pg_restore -d pleroma -ve -j 4 pleroma.14jul23
   pg_restore: connecting to database for restore
   pg_restore: processing item 4163 ENCODING ENCODING
   pg_restore: processing item 4164 STDSTRINGS STDSTRINGS
   pg_restore: processing item 4165 SEARCHPATH SEARCHPATH
   pg_restore: processing item 4166 DATABASE pleroma
   pg_restore: processing item 4167 DATABASE PROPERTIES pleroma
   pg_restore: processing item 2 EXTENSION citext
   pg_restore: creating EXTENSION "citext"
   pg_restore: processing item 4168 COMMENT EXTENSION citext
   pg_restore: creating COMMENT "EXTENSION citext"
   pg_restore: while PROCESSING TOC:
   pg_restore: from TOC entry 4168; 0 0 COMMENT EXTENSION citext
   pg_restore: error: could not execute query: ERROR: must be owner of extension citext
   Command was: COMMENT ON EXTENSION citext IS 'data type for case-insensitive character strings';
   
   So I'm getting an error, but when I fire up pleroma on the new box and connect, my user isn't there which I presume is in the database.
   
   What am I missing? Thanks.
   • Embed this notice
     Alex Gleason (alex@gleasonator.com)'s status on Saturday, 15-Jul-2023 11:26:52 JST Alex Gleason

     in reply to
     @midway LMCGPTTFY https://chat.openai.com/share/49b2b507-fa3b-4b23-96af-8879a835cd29
   • Embed this notice
     Alex Gleason (alex@gleasonator.com)'s status on Saturday, 15-Jul-2023 11:31:54 JST Alex Gleason

     in reply to

     • Alex Gleason
     @midway The GPT 4 answer is a much easier way to the same conclusion: https://chat.openai.com/share/e1106453-58d1-444a-90d1-006f275527ac