Hello,
We are trying to migrate our KONG DB from stateful set to AWS RDS.
We used pg_dump to take a backup and pg_restore to restore the schema and data to AWS RDS. While running the restore, the following errors/warnings show up in the logs.
pg_restore: while PROCESSING TOC:
pg_restore: from TOC entry 3; 2615 2200 SCHEMA public kong
pg_restore: error: could not execute query: ERROR: schema “public” already exists
Command was: CREATE SCHEMA public;
pg_restore: from TOC entry 2594; 0 0 COMMENT EXTENSION plpgsql
pg_restore: error: could not execute query: ERROR: must be owner of extension plpgsql
Command was: COMMENT ON EXTENSION plpgsql IS ‘PL/pgSQL procedural language’;
pg_restore: from TOC entry 232; 1255 16412 FUNCTION delete_expired_cluster_events() kong
pg_restore: error: could not execute query: ERROR: improper qualified name (too many dotted names):
Command was: ALTER FUNCTION public.delete_expired_cluster_events() OWNER TO kong;
pg_restore: from TOC entry 245; 1255 16670 FUNCTION sync_tags() kong
pg_restore: error: could not execute query: ERROR: improper qualified name (too many dotted names):
Command was: ALTER FUNCTION public.sync_tags() OWNER TO kong;
pg_restore: warning: errors ignored on restore: 4
Should we be worried about these? Also is there a tested way of performing this migration that is known to work? Any help is appreciated.