cancel
Showing results for 
Search instead for 
Did you mean: 

Failed to migrate EDB Postgres (hosted on OpenShift Container Platform) to Amazon RDS

Journeyer

Failed to migrate EDB Postgres (hosted on OpenShift Container Platform) to Amazon RDS

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

1 REPLY 1
Highlighted
Community Manager

Re: Failed to migrate EDB Postgres (hosted on OpenShift Container Platform) to Amazon RDS

This post is duplicated and being handled on the thread located here: https://postgresrocks.enterprisedb.com/t5/Postgres-on-Amazon/Failed-to-migrate-EDB-Postgres-hosted-o...