Embed Notice
HTML Code
Corresponding Notice
- Embed this noticeHey @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.