I am trying to migrate three databases to a new server (Linux centos 8 - pgsql 12.4)
So I am using "pg_dumpall" and target the old server - backups are getting created, then I am using psql to import the dump.
I noticed that in one db there are tables missing that have a custom schema name "RRJ_DES" - these are tables which are missing after importing the dump on the 12.4 Server. All other tables have "public" schema, and these are there. I am definitely using the superuser with all permissions when taking the dump.
Any idea? I am a bit new to postgres...