Error while Installing Pega personal edition 7.2.2
Hi Everyone,
While installing PE7.2 , I am getting following error. Please help me fix this.
Targets:Initialization,Database Server Installation,Data Load,Configuration,PRPC Launching
Buildfile: C:\PegaPE\115008_PE72\.\pegaGuiInstallerTemp2\build.xml
Initialization:
     [echo] Beginning installation of PRPC 7.2 Personal Edition -- this process should take about 5-10 minutes ...
    [unzip] Expanding: C:\PegaPE\115008_PE72\pegaGuiInstallerTemp2\PersonalEdition.zip into C:\PRPCPersonalEdition
    [unzip] Unable to expand to file C:\PRPCPersonalEdition\pgsql\bin\ssleay32.dll
    [unzip] Unable to expand to file C:\PRPCPersonalEdition\pgsql\bin\postgres.exe
    [unzip] Unable to expand to file C:\PRPCPersonalEdition\pgsql\bin\libeay32.dll
    [unzip] Unable to expand to file C:\PRPCPersonalEdition\pgsql\bin\libintl-8.dll
    [unzip] Unable to expand to file C:\PRPCPersonalEdition\pgsql\bin\libxml2.dll
     [echo] Configuring Tomcat (Setting Java Home and Catalina Home)...
  [replace] Replaced 0 occurrences in 0 files.
  [replace] Replaced 1 occurrences in 1 files.
  [replace] Replaced 2 occurrences in 1 files.
  [replace] Replaced 1 occurrences in 1 files.
Database Server Installation:
     [exec] The files belonging to this database system will be owned by user "mk_pe".
     [exec] This user must also own the server process.
Hi Everyone,
While installing PE7.2 , I am getting following error. Please help me fix this.
Targets:Initialization,Database Server Installation,Data Load,Configuration,PRPC Launching
Buildfile: C:\PegaPE\115008_PE72\.\pegaGuiInstallerTemp2\build.xml
Initialization:
     [echo] Beginning installation of PRPC 7.2 Personal Edition -- this process should take about 5-10 minutes ...
    [unzip] Expanding: C:\PegaPE\115008_PE72\pegaGuiInstallerTemp2\PersonalEdition.zip into C:\PRPCPersonalEdition
    [unzip] Unable to expand to file C:\PRPCPersonalEdition\pgsql\bin\ssleay32.dll
    [unzip] Unable to expand to file C:\PRPCPersonalEdition\pgsql\bin\postgres.exe
    [unzip] Unable to expand to file C:\PRPCPersonalEdition\pgsql\bin\libeay32.dll
    [unzip] Unable to expand to file C:\PRPCPersonalEdition\pgsql\bin\libintl-8.dll
    [unzip] Unable to expand to file C:\PRPCPersonalEdition\pgsql\bin\libxml2.dll
     [echo] Configuring Tomcat (Setting Java Home and Catalina Home)...
  [replace] Replaced 0 occurrences in 0 files.
  [replace] Replaced 1 occurrences in 1 files.
  [replace] Replaced 2 occurrences in 1 files.
  [replace] Replaced 1 occurrences in 1 files.
Database Server Installation:
     [exec] The files belonging to this database system will be owned by user "mk_pe".
     [exec] This user must also own the server process.
     [exec] The database cluster will be initialized with locale "English_India.1252".
     [exec] The default database encoding has accordingly been set to "WIN1252".
     [exec] initdb: directory "C:/PRPCPersonalEdition/pgsql/data" exists but is not empty
     [exec] The default text search configuration will be set to "english".
     [exec] If you want to create a new database system, either remove or empty
     [exec] Data page checksums are disabled.
     [exec] the directory "C:/PRPCPersonalEdition/pgsql/data" or run initdb
[exec] with an argument other than "C:/PRPCPersonalEdition/pgsql/data".
     [echo] Waiting for Postgres to start...
     [echo] Connected to Database.
     [exec] ALTER ROLE
     [exec] psql:C:/PRPCPersonalEdition/scripts/SetupDBandUser.sql:3: ERROR:  database "pega" already exists
     [exec] ALTER ROLE
Data Load:
     [echo] Waiting for Postgres to restart...
Unable to connect to database -- will retry in 1 second...
     [echo] Connected to Database.
     [echo] Loading database with PRPC...
     [exec] pg_restore: connecting to database for restore
     [exec] pg_restore: processing item 3678 ENCODING ENCODING
     [exec] pg_restore: processing item 3679 STDSTRINGS STDSTRINGS
     [exec] pg_restore: processing item 7 SCHEMA sqlj
     [exec] pg_restore: creating SCHEMA sqlj
     [exec] pg_restore: [archiver (db)] Error while PROCESSING TOC:
     [exec] pg_restore: [archiver (db)] Error from TOC entry 7; 2615 18421 SCHEMA sqlj postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  schema "sqlj" already exists
     [exec]     Command was: CREATE SCHEMA sqlj;
     [exec] pg_restore: processing item 403 FUNCTION java_call_handler()
     [exec] pg_restore: creating FUNCTION java_call_handler()
     [exec] pg_restore: [archiver (db)] Error from TOC entry 403; 1255 18422 FUNCTION java_call_handler() postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  function "java_call_handler" already exists with same argument types
     [exec]     Command was: CREATE FUNCTION java_call_handler() RETURNS language_handler
     [exec]     LANGUAGE c
     [exec]     AS 'pljava', 'java_call_handler';
     [exec] pg_restore: processing item 1396 PROCEDURAL LANGUAGE java
     [exec] pg_restore: creating PROCEDURAL LANGUAGE java
     [exec] pg_restore: [archiver (db)] Error from TOC entry 1396; 2612 18423 PROCEDURAL LANGUAGE java postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  language "java" already exists
     [exec]     Command was: CREATE TRUSTED PROCEDURAL LANGUAGE java HANDLER java_call_handler;
     [exec] pg_restore: processing item 404 FUNCTION javau_call_handler()
     [exec] pg_restore: creating FUNCTION javau_call_handler()
     [exec] pg_restore: [archiver (db)] Error from TOC entry 404; 1255 18424 FUNCTION javau_call_handler() postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  function "javau_call_handler" already exists with same argument types
     [exec]     Command was: CREATE FUNCTION javau_call_handler() RETURNS language_handler
     [exec]     LANGUAGE c
     [exec]     AS 'pljava', 'javau_call_handler';
     [exec] pg_restore: processing item 1397 PROCEDURAL LANGUAGE javau
     [exec] pg_restore: creating PROCEDURAL LANGUAGE javau
     [exec] pg_restore: [archiver (db)] Error from TOC entry 1397; 2612 18425 PROCEDURAL LANGUAGE javau postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  language "javau" already exists
     [exec]     Command was: CREATE PROCEDURAL LANGUAGE javau HANDLER javau_call_handler;
     [exec] pg_restore: processing item 412 FUNCTION add_type_mapping(character varying, character varying)
     [exec] pg_restore: creating FUNCTION add_type_mapping(character varying, character varying)
     [exec] pg_restore: [archiver (db)] Error from TOC entry 412; 1255 18497 FUNCTION add_type_mapping(character varying, character varying) postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  function "add_type_mapping" already exists with same argument types
     [exec]     Command was: CREATE FUNCTION add_type_mapping(character varying, character varying) RETURNS void
     [exec]     LANGUAGE java SECURITY DEFINER
     [exec]     A...
     [exec] pg_restore: processing item 413 FUNCTION drop_type_mapping(character varying)
     [exec] pg_restore: creating FUNCTION drop_type_mapping(character varying)
     [exec] pg_restore: [archiver (db)] Error from TOC entry 413; 1255 18498 FUNCTION drop_type_mapping(character varying) postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  function "drop_type_mapping" already exists with same argument types
     [exec]     Command was: CREATE FUNCTION drop_type_mapping(character varying) RETURNS void
     [exec]     LANGUAGE java SECURITY DEFINER
     [exec]     AS $$org.postgresql...
     [exec] pg_restore: processing item 411 FUNCTION get_classpath(character varying)
     [exec] pg_restore: creating FUNCTION get_classpath(character varying)
     [exec] pg_restore: [archiver (db)] Error from TOC entry 411; 1255 18496 FUNCTION get_classpath(character varying) postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  function "get_classpath" already exists with same argument types
     [exec]     Command was: CREATE FUNCTION get_classpath(character varying) RETURNS character varying
     [exec]     LANGUAGE java STABLE SECURITY DEFINER
     [exec]     AS ...
     [exec] pg_restore: processing item 408 FUNCTION install_jar(bytea, character varying, boolean)
     [exec] pg_restore: creating FUNCTION install_jar(bytea, character varying, boolean)
     [exec] pg_restore: [archiver (db)] Error from TOC entry 408; 1255 18493 FUNCTION install_jar(bytea, character varying, boolean) postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  function "install_jar" already exists with same argument types
     [exec]     Command was: CREATE FUNCTION install_jar(bytea, character varying, boolean) RETURNS void
     [exec]     LANGUAGE java SECURITY DEFINER
     [exec]     AS $$org....
     [exec] pg_restore: processing item 405 FUNCTION install_jar(character varying, character varying, boolean)
     [exec] pg_restore: creating FUNCTION install_jar(character varying, character varying, boolean)
     [exec] pg_restore: [archiver (db)] Error from TOC entry 405; 1255 18490 FUNCTION install_jar(character varying, character varying, boolean) postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  function "install_jar" already exists with same argument types
     [exec]     Command was: CREATE FUNCTION install_jar(character varying, character varying, boolean) RETURNS void
     [exec]     LANGUAGE java SECURITY DEFINER
     [exec]  ...
     [exec] pg_restore: processing item 407 FUNCTION remove_jar(character varying, boolean)
     [exec] pg_restore: creating FUNCTION remove_jar(character varying, boolean)
     [exec] pg_restore: [archiver (db)] Error from TOC entry 407; 1255 18492 FUNCTION remove_jar(character varying, boolean) postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  function "remove_jar" already exists with same argument types
     [exec]     Command was: CREATE FUNCTION remove_jar(character varying, boolean) RETURNS void
     [exec]     LANGUAGE java SECURITY DEFINER
     [exec]     AS $$org.postgres...
     [exec] pg_restore: processing item 409 FUNCTION replace_jar(bytea, character varying, boolean)
     [exec] pg_restore: creating FUNCTION replace_jar(bytea, character varying, boolean)
     [exec] pg_restore: [archiver (db)] Error from TOC entry 409; 1255 18494 FUNCTION replace_jar(bytea, character varying, boolean) postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  function "replace_jar" already exists with same argument types
     [exec]     Command was: CREATE FUNCTION replace_jar(bytea, character varying, boolean) RETURNS void
     [exec]     LANGUAGE java SECURITY DEFINER
     [exec]     AS $$org....
     [exec] pg_restore: processing item 406 FUNCTION replace_jar(character varying, character varying, boolean)
     [exec] pg_restore: creating FUNCTION replace_jar(character varying, character varying, boolean)
     [exec] pg_restore: [archiver (db)] Error from TOC entry 406; 1255 18491 FUNCTION replace_jar(character varying, character varying, boolean) postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  function "replace_jar" already exists with same argument types
     [exec]     Command was: CREATE FUNCTION replace_jar(character varying, character varying, boolean) RETURNS void
     [exec]     LANGUAGE java SECURITY DEFINER
     [exec]  ...
     [exec] pg_restore: processing item 410 FUNCTION set_classpath(character varying, character varying)
     [exec] pg_restore: creating FUNCTION set_classpath(character varying, character varying)
     [exec] pg_restore: [archiver (db)] Error from TOC entry 410; 1255 18495 FUNCTION set_classpath(character varying, character varying) postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  function "set_classpath" already exists with same argument types
     [exec]     Command was: CREATE FUNCTION set_classpath(character varying, character varying) RETURNS void
     [exec]     LANGUAGE java SECURITY DEFINER
     [exec]     AS $...
     [exec] pg_restore: processing item 179 TABLE classpath_entry
     [exec] pg_restore: creating TABLE classpath_entry
     [exec] pg_restore: [archiver (db)] Error from TOC entry 179; 1259 18472 TABLE classpath_entry postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  relation "classpath_entry" already exists
     [exec]     Command was: CREATE TABLE classpath_entry (
     [exec]     schemaname character varying(30) NOT NULL,
     [exec]     ordinal smallint NOT NULL,
     [exec]     jarid integ...
     [exec] pg_restore: processing item 178 TABLE jar_descriptor
     [exec] pg_restore: creating TABLE jar_descriptor
     [exec] pg_restore: [archiver (db)] Error from TOC entry 178; 1259 18457 TABLE jar_descriptor postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  relation "jar_descriptor" already exists
     [exec]     Command was: CREATE TABLE jar_descriptor (
     [exec]     jarid integer NOT NULL,
     [exec]     ordinal smallint NOT NULL,
     [exec]     entryid integer NOT NULL
     [exec] );
     [exec] pg_restore: processing item 177 TABLE jar_entry
     [exec] pg_restore: creating TABLE jar_entry
     [exec] pg_restore: [archiver (db)] Error from TOC entry 177; 1259 18441 TABLE jar_entry postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  relation "jar_entry" already exists
     [exec]     Command was: CREATE TABLE jar_entry (
     [exec]     entryid integer NOT NULL,
     [exec]     entryname character varying(200) NOT NULL,
     [exec]     jarid integer NOT ...
     [exec] pg_restore: processing item 176 SEQUENCE jar_entry_entryid_seq
     [exec] pg_restore: creating SEQUENCE jar_entry_entryid_seq
     [exec] pg_restore: [archiver (db)] Error from TOC entry 176; 1259 18439 SEQUENCE jar_entry_entryid_seq postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  relation "jar_entry_entryid_seq" already exists
     [exec]     Command was: CREATE SEQUENCE jar_entry_entryid_seq
     [exec]     START WITH 1
     [exec]     INCREMENT BY 1
     [exec]     NO MINVALUE
     [exec]     NO MAXVALUE
     [exec]     CACHE 1;
     [exec] pg_restore: processing item 3680 SEQUENCE OWNED BY jar_entry_entryid_seq
     [exec] pg_restore: creating SEQUENCE OWNED BY jar_entry_entryid_seq
     [exec] pg_restore: processing item 175 TABLE jar_repository
     [exec] pg_restore: creating TABLE jar_repository
     [exec] pg_restore: [archiver (db)] Error from TOC entry 175; 1259 18428 TABLE jar_repository postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  relation "jar_repository" already exists
     [exec]     Command was: CREATE TABLE jar_repository (
     [exec]     jarid integer NOT NULL,
     [exec]     jarname character varying(100) NOT NULL,
     [exec]     jarorigin charact...
     [exec] pg_restore: processing item 174 SEQUENCE jar_repository_jarid_seq
     [exec] pg_restore: creating SEQUENCE jar_repository_jarid_seq
     [exec] pg_restore: [archiver (db)] Error from TOC entry 174; 1259 18426 SEQUENCE jar_repository_jarid_seq postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  relation "jar_repository_jarid_seq" already exists
     [exec]     Command was: CREATE SEQUENCE jar_repository_jarid_seq
     [exec]     START WITH 1
     [exec]     INCREMENT BY 1
     [exec]     NO MINVALUE
     [exec]     NO MAXVALUE
     [exec]     CACHE 1;
     [exec] pg_restore: processing item 3681 SEQUENCE OWNED BY jar_repository_jarid_seq
     [exec] pg_restore: creating SEQUENCE OWNED BY jar_repository_jarid_seq
     [exec] pg_restore: processing item 181 TABLE typemap_entry
     [exec] pg_restore: creating TABLE typemap_entry
     [exec] pg_restore: [archiver (db)] Error from TOC entry 181; 1259 18484 TABLE typemap_entry postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  relation "typemap_entry" already exists
     [exec]     Command was: CREATE TABLE typemap_entry (
     [exec]     mapid integer NOT NULL,
     [exec]     javaname character varying(200) NOT NULL,
     [exec]     sqlname name NOT ...
     [exec] pg_restore: processing item 180 SEQUENCE typemap_entry_mapid_seq
     [exec] pg_restore: creating SEQUENCE typemap_entry_mapid_seq
     [exec] pg_restore: [archiver (db)] Error from TOC entry 180; 1259 18482 SEQUENCE typemap_entry_mapid_seq postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  relation "typemap_entry_mapid_seq" already exists
     [exec]     Command was: CREATE SEQUENCE typemap_entry_mapid_seq
     [exec]     START WITH 1
     [exec]     INCREMENT BY 1
     [exec]     NO MINVALUE
     [exec]     NO MAXVALUE
     [exec]     CACHE 1;
     [exec] pg_restore: processing item 3682 SEQUENCE OWNED BY typemap_entry_mapid_seq
     [exec] pg_restore: creating SEQUENCE OWNED BY typemap_entry_mapid_seq
     [exec] pg_restore: processing item 3533 DEFAULT entryid
     [exec] pg_restore: creating DEFAULT entryid
     [exec] pg_restore: processing item 3532 DEFAULT jarid
     [exec] pg_restore: creating DEFAULT jarid
     [exec] pg_restore: processing item 3534 DEFAULT mapid
     [exec] pg_restore: creating DEFAULT mapid
     [exec] pg_restore: entering main parallel loop
     [exec] pg_restore: launching item 3673 TABLE DATA classpath_entry
     [exec] pg_restore: launching item 3672 TABLE DATA jar_descriptor
     [exec] pg_restore: launching item 3671 TABLE DATA jar_entry
     [exec] pg_restore: launching item 3683 SEQUENCE SET jar_entry_entryid_seq
     [exec] pg_restore: processing data for table "classpath_entry"
     [exec] pg_restore: executing SEQUENCE SET jar_entry_entryid_seq
     [exec] pg_restore: processing data for table "jar_descriptor"
     [exec] pg_restore: finished item 3672 TABLE DATA jar_descriptor
     [exec] pg_restore: launching item 3669 TABLE DATA jar_repository
     [exec] pg_restore: processing data for table "jar_repository"
     [exec] pg_restore: finished item 3683 SEQUENCE SET jar_entry_entryid_seq
     [exec] pg_restore: launching item 3684 SEQUENCE SET jar_repository_jarid_seq
     [exec] pg_restore: executing SEQUENCE SET jar_repository_jarid_seq
     [exec] pg_restore: finished item 3684 SEQUENCE SET jar_repository_jarid_seq
     [exec] pg_restore: launching item 3675 TABLE DATA typemap_entry
     [exec] pg_restore: processing data for table "typemap_entry"
     [exec] pg_restore: finished item 3675 TABLE DATA typemap_entry
     [exec] pg_restore: launching item 3685 SEQUENCE SET typemap_entry_mapid_seq
     [exec] pg_restore: executing SEQUENCE SET typemap_entry_mapid_seq
     [exec] pg_restore: finished item 3685 SEQUENCE SET typemap_entry_mapid_seq
     [exec] pg_restore: launching item 3544 CONSTRAINT jar_descriptor_pkey
     [exec] pg_restore: creating CONSTRAINT jar_descriptor_pkey
     [exec] pg_restore: processing data for table "jar_entry"
     [exec] pg_restore: [archiver (db)] Error from TOC entry 3544; 2606 18461 CONSTRAINT jar_descriptor_pkey postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  multiple primary keys for table "jar_descriptor" are not allowed
     [exec]     Command was: ALTER TABLE ONLY jar_descriptor
     [exec]     ADD CONSTRAINT jar_descriptor_pkey PRIMARY KEY (jarid, ordinal);
     [exec] pg_restore: finished item 3544 CONSTRAINT jar_descriptor_pkey
     [exec] pg_restore: launching item 3548 CONSTRAINT typemap_entry_pkey
     [exec] pg_restore: creating CONSTRAINT typemap_entry_pkey
     [exec] pg_restore: [archiver (db)] Error from TOC entry 3548; 2606 18489 CONSTRAINT typemap_entry_pkey postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  multiple primary keys for table "typemap_entry" are not allowed
     [exec]     Command was: ALTER TABLE ONLY typemap_entry
     [exec]     ADD CONSTRAINT typemap_entry_pkey PRIMARY KEY (mapid);
     [exec] pg_restore: finished item 3548 CONSTRAINT typemap_entry_pkey
     [exec] pg_restore: [archiver (db)] pg_restore: [archiver (db)] Error from TOC entry 3673; 0 18472 TABLE DATA classpath_entry postgres
     [exec] Error from TOC entry 3669; 0 18428 TABLE DATA jar_repository postgres
     [exec] pg_restore: [archiver (db)] COPY failed for table "classpath_entry": ERROR:  duplicate key value violates unique constraint "classpath_entry_pkey"
     [exec] DETAIL:  Key (schemaname, ordinal)=(personaledition, 1) already exists.
     [exec] CONTEXT:  COPY classpath_entry, line 1
     [exec] pg_restore: [archiver (db)] COPY failed for table "jar_repository": ERROR:  duplicate key value violates unique constraint "jar_repository_jarname_key"
     [exec] DETAIL:  Key (jarname)=(personaleditionPRREADSTREAM) already exists.
     [exec] CONTEXT:  COPY jar_repository, line 1
     [exec] pg_restore: finished item 3673 TABLE DATA classpath_entry
     [exec] pg_restore: launching item 3546 CONSTRAINT classpath_entry_pkey
     [exec] pg_restore: finished item 3669 TABLE DATA jar_repository
     [exec] pg_restore: launching item 3536 CONSTRAINT jar_repository_jarname_key
     [exec] pg_restore: creating CONSTRAINT jar_repository_jarname_key
     [exec] pg_restore: creating CONSTRAINT classpath_entry_pkey
     [exec] pg_restore: [archiver (db)] Error from TOC entry 3536; 2606 18438 CONSTRAINT jar_repository_jarname_key postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  relation "jar_repository_jarname_key" already exists
     [exec]     Command was: ALTER TABLE ONLY jar_repository
     [exec]     ADD CONSTRAINT jar_repository_jarname_key UNIQUE (jarname);
     [exec] pg_restore: [archiver (db)] Error from TOC entry 3546; 2606 18476 CONSTRAINT classpath_entry_pkey postgres
     [exec] pg_restore: pg_restore: [archiver (db)] finished item 3536 CONSTRAINT jar_repository_jarname_key
     [exec] pg_restore: could not execute query: ERROR:  multiple primary keys for table "classpath_entry" are not allowed
     [exec]     Command was: ALTER TABLE ONLY classpath_entry
     [exec]     ADD CONSTRAINT classpath_entry_pkey PRIMARY KEY (schemaname, ordinal);
     [exec] launching item 3538 CONSTRAINT jar_repository_pkey
     [exec] pg_restore: finished item 3546 CONSTRAINT classpath_entry_pkey
     [exec] pg_restore: creating CONSTRAINT jar_repository_pkey
     [exec] pg_restore: [archiver (db)] Error from TOC entry 3538; 2606 18436 CONSTRAINT jar_repository_pkey postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  multiple primary keys for table "jar_repository" are not allowed
     [exec]     Command was: ALTER TABLE ONLY jar_repository
     [exec]     ADD CONSTRAINT jar_repository_pkey PRIMARY KEY (jarid);
     [exec] pg_restore: finished item 3538 CONSTRAINT jar_repository_pkey
     [exec] pg_restore: launching item 3552 FK CONSTRAINT classpath_entry_jarid_fkey
     [exec] pg_restore: creating FK CONSTRAINT classpath_entry_jarid_fkey
     [exec] pg_restore: [archiver (db)] Error from TOC entry 3552; 2606 18477 FK CONSTRAINT classpath_entry_jarid_fkey postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  constraint "classpath_entry_jarid_fkey" for relation "classpath_entry" already exists
     [exec]     Command was: ALTER TABLE ONLY classpath_entry
     [exec]     ADD CONSTRAINT classpath_entry_jarid_fkey FOREIGN KEY (jarid) REFERENCES jar_repository...
     [exec] pg_restore: finished item 3552 FK CONSTRAINT classpath_entry_jarid_fkey
     [exec] pg_restore: launching item 3550 FK CONSTRAINT jar_descriptor_jarid_fkey
     [exec] pg_restore: creating FK CONSTRAINT jar_descriptor_jarid_fkey
     [exec] pg_restore: [archiver (db)] Error from TOC entry 3550; 2606 18462 FK CONSTRAINT jar_descriptor_jarid_fkey postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  constraint "jar_descriptor_jarid_fkey" for relation "jar_descriptor" already exists
     [exec]     Command was: ALTER TABLE ONLY jar_descriptor
     [exec]     ADD CONSTRAINT jar_descriptor_jarid_fkey FOREIGN KEY (jarid) REFERENCES jar_repository(j...
     [exec] pg_restore: finished item 3550 FK CONSTRAINT jar_descriptor_jarid_fkey
     [exec] pg_restore: [archiver (db)] Error from TOC entry 3671; 0 18441 TABLE DATA jar_entry postgres
     [exec] pg_restore: [archiver (db)] COPY failed for table "jar_entry": ERROR:  duplicate key value violates unique constraint "jar_entry_jarid_entryname_key"
     [exec] DETAIL:  Key (jarid, entryname)=(1, com/pega/pegarules/data/udf/directstreamreader/BasicEnvironmentAdapter.class) already exists.
     [exec] CONTEXT:  COPY jar_entry, line 1
     [exec] pg_restore: finished item 3671 TABLE DATA jar_entry
     [exec] pg_restore: launching item 3540 CONSTRAINT jar_entry_jarid_entryname_key
     [exec] pg_restore: creating CONSTRAINT jar_entry_jarid_entryname_key
     [exec] pg_restore: [archiver (db)] Error from TOC entry 3540; 2606 18451 CONSTRAINT jar_entry_jarid_entryname_key postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  relation "jar_entry_jarid_entryname_key" already exists
     [exec]     Command was: ALTER TABLE ONLY jar_entry
     [exec]     ADD CONSTRAINT jar_entry_jarid_entryname_key UNIQUE (jarid, entryname);
     [exec] pg_restore: finished item 3540 CONSTRAINT jar_entry_jarid_entryname_key
     [exec] pg_restore: launching item 3542 CONSTRAINT jar_entry_pkey
     [exec] pg_restore: creating CONSTRAINT jar_entry_pkey
     [exec] pg_restore: [archiver (db)] Error from TOC entry 3542; 2606 18449 CONSTRAINT jar_entry_pkey postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  multiple primary keys for table "jar_entry" are not allowed
     [exec]     Command was: ALTER TABLE ONLY jar_entry
     [exec]     ADD CONSTRAINT jar_entry_pkey PRIMARY KEY (entryid);
     [exec] pg_restore: finished item 3542 CONSTRAINT jar_entry_pkey
     [exec] pg_restore: launching item 3549 FK CONSTRAINT jar_entry_jarid_fkey
     [exec] pg_restore: creating FK CONSTRAINT jar_entry_jarid_fkey
     [exec] pg_restore: [archiver (db)] Error from TOC entry 3549; 2606 18452 FK CONSTRAINT jar_entry_jarid_fkey postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  constraint "jar_entry_jarid_fkey" for relation "jar_entry" already exists
     [exec]     Command was: ALTER TABLE ONLY jar_entry
     [exec]     ADD CONSTRAINT jar_entry_jarid_fkey FOREIGN KEY (jarid) REFERENCES jar_repository(jarid) ON D...
     [exec] pg_restore: finished item 3549 FK CONSTRAINT jar_entry_jarid_fkey
     [exec] pg_restore: launching item 3551 FK CONSTRAINT jar_descriptor_entryid_fkey
     [exec] pg_restore: creating FK CONSTRAINT jar_descriptor_entryid_fkey
     [exec] pg_restore: [archiver (db)] Error from TOC entry 3551; 2606 18467 FK CONSTRAINT jar_descriptor_entryid_fkey postgres
     [exec] pg_restore: [archiver (db)] could not execute query: ERROR:  constraint "jar_descriptor_entryid_fkey" for relation "jar_descriptor" already exists
     [exec]     Command was: ALTER TABLE ONLY jar_descriptor
     [exec]     ADD CONSTRAINT jar_descriptor_entryid_fkey FOREIGN KEY (entryid) REFERENCES jar_entry(en...
     [exec] pg_restore: finished item 3551 FK CONSTRAINT jar_descriptor_entryid_fkey
     [exec] pg_restore: finished main parallel loop
     [exec] pg_restore: setting owner and privileges for SCHEMA sqlj
     [exec] pg_restore: setting owner and privileges for FUNCTION java_call_handler()
     [exec] pg_restore: setting owner and privileges for PROCEDURAL LANGUAGE java
     [exec] pg_restore: setting owner and privileges for FUNCTION javau_call_handler()
     [exec] pg_restore: setting owner and privileges for PROCEDURAL LANGUAGE javau
     [exec] pg_restore: setting owner and privileges for FUNCTION add_type_mapping(character varying, character varying)
     [exec] pg_restore: setting owner and privileges for FUNCTION drop_type_mapping(character varying)
     [exec] pg_restore: setting owner and privileges for FUNCTION get_classpath(character varying)
     [exec] pg_restore: setting owner and privileges for FUNCTION install_jar(bytea, character varying, boolean)
     [exec] pg_restore: setting owner and privileges for FUNCTION install_jar(character varying, character varying, boolean)
     [exec] pg_restore: setting owner and privileges for FUNCTION remove_jar(character varying, boolean)
     [exec] pg_restore: setting owner and privileges for FUNCTION replace_jar(bytea, character varying, boolean)
     [exec] pg_restore: setting owner and privileges for FUNCTION replace_jar(character varying, character varying, boolean)
     [exec] pg_restore: setting owner and privileges for FUNCTION set_classpath(character varying, character varying)
     [exec] pg_restore: setting owner and privileges for TABLE classpath_entry
     [exec] pg_restore: setting owner and privileges for TABLE jar_descriptor
     [exec] pg_restore: setting owner and privileges for TABLE jar_entry
     [exec] pg_restore: setting owner and privileges for SEQUENCE jar_entry_entryid_seq
     [exec] pg_restore: setting owner and privileges for SEQUENCE OWNED BY jar_entry_entryid_seq
     [exec] pg_restore: setting owner and privileges for TABLE jar_repository
     [exec] pg_restore: setting owner and privileges for SEQUENCE jar_repository_jarid_seq
     [exec] pg_restore: setting owner and privileges for SEQUENCE OWNED BY jar_repository_jarid_seq
     [exec] pg_restore: setting owner and privileges for TABLE typemap_entry
     [exec] pg_restore: setting owner and privileges for SEQUENCE typemap_entry_mapid_seq
     [exec] pg_restore: setting owner and privileges for SEQUENCE OWNED BY typemap_entry_mapid_seq
     [exec] pg_restore: setting owner and privileges for DEFAULT entryid
     [exec] pg_restore: setting owner and privileges for DEFAULT jarid
     [exec] pg_restore: setting owner and privileges for DEFAULT mapid
     [exec] pg_restore: setting owner and privileges for TABLE DATA classpath_entry
     [exec] pg_restore: setting owner and privileges for TABLE DATA jar_descriptor
     [exec] pg_restore: setting owner and privileges for TABLE DATA jar_entry
     [exec] pg_restore: setting owner and privileges for SEQUENCE SET jar_entry_entryid_seq
     [exec] pg_restore: setting owner and privileges for TABLE DATA jar_repository
     [exec] pg_restore: setting owner and privileges for SEQUENCE SET jar_repository_jarid_seq
     [exec] pg_restore: setting owner and privileges for TABLE DATA typemap_entry
     [exec] pg_restore: setting owner and privileges for SEQUENCE SET typemap_entry_mapid_seq
     [exec] pg_restore: setting owner and privileges for CONSTRAINT classpath_entry_pkey
     [exec] pg_restore: setting owner and privileges for CONSTRAINT jar_descriptor_pkey
     [exec] pg_restore: setting owner and privileges for CONSTRAINT jar_entry_jarid_entryname_key
     [exec] pg_restore: setting owner and privileges for CONSTRAINT jar_entry_pkey
     [exec] pg_restore: setting owner and privileges for CONSTRAINT jar_repository_jarname_key
     [exec] pg_restore: setting owner and privileges for CONSTRAINT jar_repository_pkey
     [exec] pg_restore: setting owner and privileges for CONSTRAINT typemap_entry_pkey
     [exec] pg_restore: setting owner and privileges for FK CONSTRAINT classpath_entry_jarid_fkey
     [exec] pg_restore: setting owner and privileges for FK CONSTRAINT jar_descriptor_entryid_fkey
     [exec] pg_restore: setting owner and privileges for FK CONSTRAINT jar_descriptor_jarid_fkey
     [exec] pg_restore: setting owner and privileges for FK CONSTRAINT jar_entry_jarid_fkey
     [exec] WARNING: errors ignored on restore: 50
 
            
    