gonna try using pg_dumpall to make it easier to do a quick restore of everything without having to recreate the user and whatnot manually, let's see how it works out
need to use this instance more, but at least for now managed to move it to the main server instead of it sitting on the mini pc which hasn't been doing anything else too useful
@akko@lispi314 yeah, you probably ran pg_dump without setting the format, which by default is just a plain text sql file. pg_restore is used if you use the other formats like the "custom" one