[Updated] How To Setup a Conquer Private Server

pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "pkey_Servers_ServerName"
CONTEXT: COPY Servers, line 1: "Conquer Online Emulator 69.208.160.90"
pg_restore: restoring data for table "Settings"
pg_restore: restoring data for table "Shops"
pg_restore: [archiver (db)] Error from TOC entry 1711; 0 16603 TABLE DATA Shops conquer
pg_restore: [archiver (db)] COPY failed: ERROR: duplicate key value violates unique constraint "Shops_pkey"
CONTEXT: COPY Shops, line 1: "3 0 1000000~1000010~1000020~1000030~1001000~1001010~10 01020~1002000~1002010~1002020~1060020~1001030~..."
pg_restore: restoring data for table "items"
pg_restore: [archiver (db)] Error from TOC entry 1712; 0 16608 TABLE DATA items conquer
pg_restore: [archiver (db)] COPY failed: ERROR: invalid byte sequence for encoding "UTF8": 0xc1e9
HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".
CONTEXT: COPY items, line 9684
pg_restore: restoring data for table "news"
pg_restore: creating CONSTRAINT Maps_pkey
pg_restore: [archiver (db)] Error from TOC entry 1682; 2606 16619 CONSTRAINT Maps_pkey conquer
pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "Maps" are not allowed
Command was: ALTER TABLE ONLY "Maps"
ADD CONSTRAINT "Maps_pkey" PRIMARY KEY ("Map_Number");
pg_restore: creating CONSTRAINT MobID
pg_restore: [archiver (db)] Error from TOC entry 1688; 2606 16621 CONSTRAINT MobID conquer
pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "Monsters" are not allowed
Command was: ALTER TABLE ONLY "Monsters"
ADD CONSTRAINT "MobID" PRIMARY KEY (id);
pg_restore: creating CONSTRAINT Mob_ID
pg_restore: [archiver (db)] Error from TOC entry 1684; 2606 16623 CONSTRAINT Mob_ID conquer
pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "Monster" are not allowed
Command was: ALTER TABLE ONLY "Monster"
ADD CONSTRAINT "Mob_ID" PRIMARY KEY (id);
pg_restore: creating CONSTRAINT MonsterSpawns_pkey
pg_restore: [archiver (db)] Error from TOC entry 1686; 2606 16625 CONSTRAINT MonsterSpawns_pkey conquer
pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "MonsterSpawns" are not allowed
Command was: ALTER TABLE ONLY "MonsterSpawns"
ADD CONSTRAINT "MonsterSpawns_pkey" PRIMARY KEY ("UniID");
pg_restore: creating CONSTRAINT NPCs
pg_restore: [archiver (db)] Error from TOC entry 1690; 2606 16627 CONSTRAINT NPCs conquer
pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "NPC_Spawns" are not allowed
Command was: ALTER TABLE ONLY "NPC_Spawns"
ADD CONSTRAINT "NPCs" PRIMARY KEY ("ID_1");
pg_restore: creating CONSTRAINT Shops_pkey
pg_restore: [archiver (db)] Error from TOC entry 1698; 2606 16629 CONSTRAINT Shops_pkey conquer
pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "Shops" are not allowed
Command was: ALTER TABLE ONLY "Shops"
ADD CONSTRAINT "Shops_pkey" PRIMARY KEY ("ShopID", "Items", "Type");
pg_restore: creating CONSTRAINT pkey_Account_AccountID
pg_restore: [archiver (db)] Error from TOC entry 1674; 2606 16631 CONSTRAINT pkey_Account_AccountID conquer
pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "Account" are not allowed
Command was: ALTER TABLE ONLY "Account"
ADD CONSTRAINT "pkey_Account_AccountID" PRIMARY KEY ("AccountID");
pg_restore: creating CONSTRAINT pkey_Characters_CharacterID
pg_restore: [archiver (db)] Error from TOC entry 1676; 2606 16633 CONSTRAINT pkey_Characters_CharacterID conquer
pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "Characters" are not allowed
Command was: ALTER TABLE ONLY "Characters"
ADD CONSTRAINT "pkey_Characters_CharacterID" PRIMARY KEY ("CharacterID");
pg_restore: creating CONSTRAINT pkey_DefaultStats_LevelClass
pg_restore: [archiver (db)] Error from TOC entry 1680; 2606 16635 CONSTRAINT pkey_DefaultStats_LevelClass conquer
pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "DefaultStats" are not allowed
Command was: ALTER TABLE ONLY "DefaultStats"
ADD CONSTRAINT "pkey_DefaultStats_LevelClass" PRIMARY KEY ("Class", "Level");
pg_restore: creating CONSTRAINT pkey_Portals_Name
pg_restore: [archiver (db)] Error from TOC entry 1692; 2606 16637 CONSTRAINT pkey_Portals_Name conquer
pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "Portals" are not allowed
Command was: ALTER TABLE ONLY "Portals"
ADD CONSTRAINT "pkey_Portals_Name" PRIMARY KEY ("Name");
pg_restore: creating CONSTRAINT pkey_Servers_ServerName
pg_restore: [archiver (db)] Error from TOC entry 1694; 2606 16639 CONSTRAINT pkey_Servers_ServerName conquer
pg_restore: [archiver (db)] could not execute query: ERROR: multiple primary keys for table "Servers" are not allowed
Command was: ALTER TABLE ONLY "Servers"
ADD CONSTRAINT "pkey_Servers_ServerName" PRIMARY KEY ("ServerName");
pg_restore: creating CONSTRAINT pkey_Settings_Name
pg_restore: [archiver (db)] Error from TOC entry 1696; 2606 16641 CONSTRAINT pkey_Settings_Name conquer
pg_restore: [archiver (db)] could not execute query: ERROR: relation "pkey_Settings_Name" already exists
Command was: ALTER TABLE ONLY "Settings"
ADD CONSTRAINT "pkey_Settings_Name" UNIQUE ("Name");
pg_restore: creating CONSTRAINT ukey_Characters_Name
pg_restore: [archiver (db)] Error from TOC entry 1678; 2606 16643 CONSTRAINT ukey_Characters_Name conquer
pg_restore: [archiver (db)] could not execute query: ERROR: relation "ukey_Characters_Name" already exists
Command was: ALTER TABLE ONLY "Characters"
ADD CONSTRAINT "ukey_Characters_Name" UNIQUE ("Name");
pg_restore: creating INDEX ix_Account_AccountID
pg_restore: [archiver (db)] Error from TOC entry 1672; 1259 16644 INDEX ix_Account_AccountID conquer
pg_restore: [archiver (db)] could not execute query: ERROR: relation "ix_Account_AccountID" already exists
Command was: CREATE UNIQUE INDEX "ix_Account_AccountID" ON "Account" USING btree ("AccountID");
pg_restore: creating FK CONSTRAINT fkey_Characters_Account
pg_restore: [archiver (db)] Error from TOC entry 1699; 2606 16645 FK CONSTRAINT fkey_Characters_Account conquer
pg_restore: [archiver (db)] could not execute query: ERROR: constraint "fkey_Characters_Account" for relation "Characters" already exists
Command was: ALTER TABLE ONLY "Characters"
ADD CONSTRAINT "fkey_Characters_Account" FOREIGN KEY ("Account") REFERENCES "Account"("Acc...
pg_restore: setting owner and privileges for SCHEMA public
pg_restore: setting owner and privileges for COMMENT SCHEMA public
pg_restore: setting owner and privileges for ACL public
pg_restore: [archiver (db)] Error from TOC entry 1717; 0 0 ACL public conquer
pg_restore: [archiver (db)] could not execute query: ERROR: role "conquer" does not exist
Command was: REVOKE ALL ON SCHEMA public FROM conquer;
pg_restore: [archiver (db)] could not execute query: ERROR: role "conquer" does not exist
Command was: GRANT ALL ON SCHEMA public TO conquer;
pg_restore: setting owner and privileges for TABLE Account
pg_restore: setting owner and privileges for COMMENT COLUMN "Account"."LogonAction"
pg_restore: setting owner and privileges for SEQUENCE Characters_CharacterID_seq
pg_restore: setting owner and privileges for TABLE Characters
pg_restore: setting owner and privileges for TABLE DefaultStats
pg_restore: setting owner and privileges for TABLE Maps
pg_restore: setting owner and privileges for TABLE Monster
pg_restore: setting owner and privileges for TABLE MonsterSpawns
pg_restore: setting owner and privileges for TABLE Monsters
pg_restore: setting owner and privileges for TABLE NPC_Spawns
pg_restore: setting owner and privileges for TABLE Portals
pg_restore: setting owner and privileges for TABLE Servers
pg_restore: setting owner and privileges for TABLE Settings
pg_restore: setting owner and privileges for TABLE Shops
pg_restore: setting owner and privileges for TABLE items
pg_restore: setting owner and privileges for TABLE news
pg_restore: setting owner and privileges for SEQUENCE news_seq
pg_restore: setting owner and privileges for CONSTRAINT Maps_pkey
pg_restore: setting owner and privileges for CONSTRAINT MobID
pg_restore: setting owner and privileges for CONSTRAINT Mob_ID
pg_restore: setting owner and privileges for CONSTRAINT MonsterSpawns_pkey
pg_restore: setting owner and privileges for CONSTRAINT NPCs
pg_restore: setting owner and privileges for CONSTRAINT Shops_pkey
pg_restore: setting owner and privileges for CONSTRAINT pkey_Account_AccountID
pg_restore: setting owner and privileges for CONSTRAINT pkey_Characters_CharacterID
pg_restore: setting owner and privileges for CONSTRAINT pkey_DefaultStats_LevelClass
pg_restore: setting owner and privileges for CONSTRAINT pkey_Portals_Name
pg_restore: setting owner and privileges for CONSTRAINT pkey_Servers_ServerName
pg_restore: setting owner and privileges for CONSTRAINT pkey_Settings_Name
pg_restore: setting owner and privileges for CONSTRAINT ukey_Characters_Name
pg_restore: setting owner and privileges for INDEX ix_Account_AccountID
pg_restore: setting owner and privileges for FK CONSTRAINT fkey_Characters_Account
WARNING: errors ignored on restore: 61

Process returned exit code 1.