Is it possible to migrate the EDB Postgres DB from on-prem(hosted on OpenShift Container Platform) migration to Amazon RDS?
Failed to migrate EDB Postgres to Amazon RDS because of unrecognized configuration parameter that are very specific to EDB . Here are the logs
[ec2-user@ip-x.x.x.x ~]$ psql -U username -h edb1.xxxxxxxx.ap-southeast-2.rds.amazonaws.com -p 5432 -d edb1 < s3-buckets/edb1.pgsql
Password for user enterprisedb:
SET
SET
SET
SET
SET
ERROR: unrecognized configuration parameter "edb_redwood_date"
ERROR: unrecognized configuration parameter "default_with_rowids"
set_config
------------
(1 row)
SET
SET
SET
SET
ERROR: unrecognized configuration parameter "edb_data_redaction"
ERROR: Extension "edb_wait_states" is not supported by Amazon RDS
DETAIL: Installing the extension "edb_wait_states" failed, because it is not on the list of extensions supported by Amazon RDS.
HINT: Amazon RDS allows users with rds_superuser role to install supported extensions. See: SHOW rds.extensions;
ERROR: extension "edb_wait_states" does not exist
ERROR: syntax error at or near "RETURN"
LINE 1: ...ON public.emp_comp(p_sal numeric, p_comm numeric) RETURN num...
^
ERROR: function public.emp_comp(numeric, numeric) does not exist
ERROR: syntax error at or near "AUTHID"
LINE 1: ...e timestamp without time zone, OUT p_sal numeric) AUTHID DEF...
^
ERROR: procedure public.emp_query(numeric, numeric, character varying) does not exist
ERROR: syntax error at or near "AUTHID"
LINE 1: ...TE OR REPLACE PROCEDURE public.emp_query_caller() AUTHID DEF...
^
ERROR: procedure public.emp_query_caller() does not exist
ERROR: syntax error at or near "RETURN"
LINE 1: ...lerk(p_ename character varying, p_deptno numeric) RETURN num...
^
ERROR: function public.hire_clerk(character varying, numeric) does not exist
ERROR: function "hire_salesman" already exists with same argument types
ALTER FUNCTION
ERROR: syntax error at or near "AUTHID"
LINE 1: CREATE OR REPLACE PROCEDURE public.list_emp() AUTHID DEFINER
^
ERROR: procedure public.list_emp() does not exist
ERROR: syntax error at or near "RETURN"
LINE 1: CREATE OR REPLACE FUNCTION public.new_empno() RETURN numeric...
^
ERROR: function public.new_empno() does not exist
ERROR: syntax error at or near "AUTHID"
LINE 1: ...LACE PROCEDURE public.select_emp(p_empno numeric) AUTHID DEF...
^
ERROR: procedure public.select_emp(numeric) does not exist
ERROR: permission denied for language c
ERROR: function public.sp_activate(character varying, oidvector, oidvector, integer, integer, interval) does not exist
ERROR: function public.sp_activate(character varying, oidvector, oidvector, integer, integer, interval) does not exist
ERROR: permission denied for language c
ERROR: function public.sp_active_traces() does not exist
ERROR: function public.sp_active_traces() does not exist
ERROR: permission denied for language c
ERROR: function public.sp_cleanup(text, boolean) does not exist
ERROR: function public.sp_cleanup(text, boolean) does not exist
ERROR: permission denied for language c
ERROR: function public.sp_deactivate(text) does not exist
ERROR: function public.sp_deactivate(text) does not exist
ERROR: permission denied for language c
ERROR: function public.sp_load_trace(text, boolean) does not exist
ERROR: function public.sp_load_trace(text, boolean) does not exist
ERROR: permission denied for language c
ERROR: function public.sp_profiler_version() does not exist
ERROR: function public.sp_profiler_version() does not exist
ERROR: permission denied for language c
ERROR: function public.sp_traces_list() does not exist
ERROR: function public.sp_traces_list() does not exist
SET
SET
ERROR: relation "dept" already exists
ALTER TABLE
ERROR: relation "emp" already exists
ALTER TABLE
ERROR: relation "emptest" already exists
ALTER TABLE
ERROR: relation "jobhist" already exists
ALTER TABLE
ERROR: relation "mytable1" already exists
ALTER TABLE
ERROR: relation "next_empno" already exists
ALTER TABLE
ERROR: relation "salesemp" already exists
ALTER TABLE
ERROR: syntax error at or near "PACKAGE"
LINE 1: CREATE OR REPLACE PACKAGE public.emp_admin IS
^
ERROR: syntax error at or near "FUNCTION"
LINE 1: FUNCTION update_emp_sal(p_empno numeric, p_raise numeric) RE...
^
ERROR: syntax error at or near "PROCEDURE"
LINE 1: PROCEDURE hire_emp(p_empno numeric, p_ename character varyin...
^
ERROR: syntax error at or near "PROCEDURE"
LINE 1: PROCEDURE fire_emp(p_empno numeric);
^
WARNING: there is no transaction in progress
COMMIT
ERROR: syntax error at or near "PACKAGE"
LINE 1: CREATE OR REPLACE PACKAGE BODY public.emp_admin IS
^
ERROR: syntax error at or near "SELECT"
LINE 2: SELECT dname INTO v_dname FROM dept WHERE deptno = p...
^
ERROR: syntax error at or near "RETURN"
LINE 1: RETURN v_dname;
^
ERROR: syntax error at or near "EXCEPTION"
LINE 1: EXCEPTION
^
ERROR: syntax error at or near "RETURN"
LINE 1: RETURN '';
^
WARNING: there is no transaction in progress
COMMIT
ERROR: syntax error at or near "FUNCTION"
LINE 1: FUNCTION update_emp_sal(p_empno numeric, p_raise numeric) RE...
^
ERROR: syntax error at or near "SELECT"
LINE 2: SELECT sal INTO v_sal FROM emp WHERE empno = p_empno...
^
ERROR: syntax error at or near "v_sal"
LINE 1: v_sal := v_sal + p_raise;
^
ERROR: relation "emp" does not exist
LINE 1: UPDATE emp SET sal = v_sal WHERE empno = p_empno;
^
ERROR: syntax error at or near "RETURN"
LINE 1: RETURN v_sal;
^
ERROR: syntax error at or near "EXCEPTION"
LINE 1: EXCEPTION
^
ERROR: syntax error at or near "RETURN"
LINE 1: RETURN -1;
^
ERROR: syntax error at or near "WHEN"
LINE 1: WHEN OTHERS THEN
^
ERROR: syntax error at or near "DBMS_OUTPUT"
LINE 1: DBMS_OUTPUT.PUT_LINE(SQLERRM);
^
ERROR: syntax error at or near "DBMS_OUTPUT"
LINE 1: DBMS_OUTPUT.PUT_LINE('The following is SQLCODE:');
^
ERROR: syntax error at or near "DBMS_OUTPUT"
LINE 1: DBMS_OUTPUT.PUT_LINE(SQLCODE);
^
ERROR: syntax error at or near "RETURN"
LINE 1: RETURN -1;
^
WARNING: there is no transaction in progress
COMMIT
ERROR: syntax error at or near "PROCEDURE"
LINE 1: PROCEDURE hire_emp(p_empno numeric, p_ename character varyin...
^
WARNING: there is no transaction in progress
COMMIT
ERROR: syntax error at or near "PROCEDURE"
LINE 1: PROCEDURE fire_emp(p_empno numeric) IS
^
WARNING: there is no transaction in progress
COMMIT
WARNING: there is no transaction in progress
COMMIT
ERROR: syntax error at or near "PACKAGE"
LINE 1: ALTER PACKAGE public.emp_admin OWNER TO edbuser;
^
ERROR: duplicate key value violates unique constraint "dept_dname_uq"
DETAIL: Key (dname)=(ACCOUNTING) already exists.
CONTEXT: COPY dept, line 1
ERROR: duplicate key value violates unique constraint "emp_pk"
DETAIL: Key (empno)=(7369) already exists.
CONTEXT: COPY emp, line 1
ERROR: duplicate key value violates unique constraint "emptest_pk"
DETAIL: Key (empno)=(7369) already exists.
CONTEXT: COPY emptest, line 1
ERROR: duplicate key value violates unique constraint "jobhist_pk"
DETAIL: Key (empno, startdate)=(7369, 1980-12-17 00:00:00) already exists.
CONTEXT: COPY jobhist, line 1
COPY 6
setval
--------
8000
(1 row)
ERROR: relation "dept_dname_uq" already exists
ERROR: multiple primary keys for table "dept" are not allowed
ERROR: multiple primary keys for table "emp" are not allowed
ERROR: multiple primary keys for table "emptest" are not allowed
ERROR: multiple primary keys for table "jobhist" are not allowed
ERROR: rule "salesemp_d" for relation "salesemp" already exists
ERROR: rule "salesemp_i" for relation "salesemp" already exists
ERROR: rule "salesemp_u" for relation "salesemp" already exists
ERROR: syntax error at or near "$trigger$DECLARE
sal_diff NUMBER;
BEGIN
IF INSERTING THEN
DBMS_OUTPUT.PUT_LINE('Inserting employee ' || :NEW.empno);
DBMS_OUTPUT.PUT_LINE('..New salary: ' || :NEW.sal);
END IF;
IF UPDATING THEN
sal_diff := :NEW.sal - :OLD.sal;
DBMS_OUTPUT.PUT_LINE('Updating employee ' || :OLD.empno);
DBMS_OUTPUT.PUT_LINE('..Old salary: ' || :OLD.sal);
DBMS_OUTPUT.PUT_LINE('..New salary: ' || :NEW.sal);
DBMS_OUTPUT.PUT_LINE('..Raise : ' || sal_diff);
END IF;
IF DELETING THEN
DBMS_OUTPUT.PUT_LINE('Deleting employee ' || :OLD.empno);
DBMS_OUTPUT.PUT_LINE('..Old salary: ' || :OLD.sal);
END IF;
END$trigger$"
LINE 1: ...T OR DELETE OR UPDATE ON public.emp FOR EACH ROW $trigger$D...
^
ERROR: syntax error at or near "$trigger$DECLARE
v_action VARCHAR2(24);
BEGIN
IF INSERTING THEN
v_action := ' added employee(s) on ';
ELSIF UPDATING THEN
v_action := ' updated employee(s) on ';
ELSIF DELETING THEN
v_action := ' deleted employee(s) on ';
END IF;
DBMS_OUTPUT.PUT_LINE('User ' || USER || v_action || TO_CHAR(SYSDATE,'YYYY-MM-DD'));
END$trigger$"
LINE 1: ...ELETE OR UPDATE ON public.emp FOR EACH STATEMENT $trigger$D...
^
ERROR: constraint "emp_ref_dept_fk" for relation "emp" already exists
ERROR: constraint "jobhist_ref_dept_fk" for relation "jobhist" already exists
ERROR: constraint "jobhist_ref_emp_fk" for relation "jobhist" already exists
ERROR: relation "pg_catalog.session_wait_history" does not exist
ERROR: relation "pg_catalog.session_waits" does not exist
ERROR: relation "pg_catalog.system_waits" does not exist
WARNING: no privileges were granted for "dept"
GRANT
WARNING: no privileges were granted for "emp"
GRANT
GRANT
WARNING: no privileges were granted for "jobhist"
GRANT
WARNING: no privileges were granted for "next_empno"
GRANT
WARNING: no privileges were granted for "salesemp"
GRANT
