Conversation
Notices
-
Embed this notice
midway (midway@soapbox.midwaytrades.com)'s status on Saturday, 15-Jul-2023 11:26:53 JST midway
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
@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
@midway The GPT 4 answer is a much easier way to the same conclusion: https://chat.openai.com/share/e1106453-58d1-444a-90d1-006f275527ac In conversation permalink Attachments
-
Embed this notice