2022-06-25 00:35:14.873 WIB [1] LOG:  could not open usermap file "/var/lib/postgresql/data/pg_ident.conf": No such file or directory
2022-06-25 00:35:14.901 WIB [27] LOG:  database system was shut down at 2022-06-25 00:34:57 WIB
2022-06-25 00:35:14.938 WIB [1] LOG:  database system is ready to accept connections
2022-06-25 00:38:21.835 WIB [45] ERROR:  cannot drop the currently open database
2022-06-25 00:38:21.835 WIB [45] STATEMENT:  DROP DATABASE pddikti;
	
2022-06-25 00:38:21.846 WIB [45] ERROR:  option "locale" not recognized at character 69
2022-06-25 00:38:21.846 WIB [45] STATEMENT:  CREATE DATABASE pddikti WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE = 'Indonesian_Indonesia.1252';
	
	
	
2022-06-25 00:38:22.026 WIB [46] ERROR:  schema "public" already exists
2022-06-25 00:38:22.026 WIB [46] STATEMENT:  CREATE SCHEMA public;
	
	
	
2022-06-25 00:40:01.610 WIB [46] ERROR:  role "NeoPostgres" does not exist
2022-06-25 00:40:01.610 WIB [46] STATEMENT:  REVOKE ALL ON SCHEMA public FROM "NeoPostgres";
	REVOKE ALL ON SCHEMA public FROM PUBLIC;
	GRANT ALL ON SCHEMA public TO "N3wf33der";
	GRANT ALL ON SCHEMA public TO PUBLIC;
	
	
	
2022-06-25 00:43:23.402 WIB [65] ERROR:  database "pddikti_sandbox" does not exist
2022-06-25 00:43:23.402 WIB [65] STATEMENT:  DROP DATABASE pddikti_sandbox;
	
2022-06-25 00:43:23.414 WIB [65] ERROR:  option "locale" not recognized at character 77
2022-06-25 00:43:23.414 WIB [65] STATEMENT:  CREATE DATABASE pddikti_sandbox WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE = 'Indonesian_Indonesia.1252';
	
	
	
2022-06-25 00:43:23.448 WIB [66] FATAL:  database "pddikti_sandbox" does not exist
2022-06-25 00:43:23.457 WIB [65] LOG:  could not receive data from client: Connection reset by peer
2022-06-25 00:44:01.540 WIB [70] ERROR:  cannot drop the currently open database
2022-06-25 00:44:01.540 WIB [70] STATEMENT:  DROP DATABASE pddikti_sandbox;
	
2022-06-25 00:44:01.548 WIB [70] ERROR:  option "locale" not recognized at character 77
2022-06-25 00:44:01.548 WIB [70] STATEMENT:  CREATE DATABASE pddikti_sandbox WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE = 'Indonesian_Indonesia.1252';
	
	
	
2022-06-25 00:44:01.718 WIB [71] ERROR:  schema "public" already exists
2022-06-25 00:44:01.718 WIB [71] STATEMENT:  CREATE SCHEMA public;
	
	
	
2022-06-25 00:48:43.288 WIB [95] FATAL:  database "template0" is not currently accepting connections
2022-06-25 00:48:43.366 WIB [96] FATAL:  database "template0" is not currently accepting connections
2022-06-25 00:48:43.435 WIB [97] FATAL:  database "template0" is not currently accepting connections
2022-06-25 00:48:43.629 WIB [98] FATAL:  database "template0" is not currently accepting connections
2022-06-25 00:48:43.695 WIB [99] FATAL:  database "template0" is not currently accepting connections
2022-06-25 00:48:43.887 WIB [100] FATAL:  database "template0" is not currently accepting connections
2022-06-25 00:49:47.059 WIB [109] FATAL:  database "template0" is not currently accepting connections
2022-06-25 00:57:49.278 WIB [126] ERROR:  option "encoding" not recognized at character 24
2022-06-25 00:57:49.278 WIB [126] STATEMENT:  alter DATABASE pddikti ENCODING='UTF8' LOCALE='Indonesian_Indonesia.1252'
2022-06-25 00:58:43.273 WIB [147] FATAL:  database "template0" is not currently accepting connections
2022-06-25 00:59:06.760 WIB [154] FATAL:  database "template0" is not currently accepting connections
2022-06-25 00:59:28.074 WIB [163] FATAL:  database "template0" is not currently accepting connections
2022-06-25 01:00:20.316 WIB [170] ERROR:  schema "public" already exists
2022-06-25 01:00:20.316 WIB [170] STATEMENT:  CREATE SCHEMA public;
2022-06-25 01:00:43.003 WIB [170] LOG:  could not receive data from client: Connection reset by peer
2022-06-25 01:01:04.149 WIB [175] ERROR:  schema "man_akses" already exists
2022-06-25 01:01:04.149 WIB [175] STATEMENT:  CREATE SCHEMA man_akses;
2022-06-25 01:01:04.195 WIB [175] ERROR:  schema "ref" already exists
2022-06-25 01:01:04.195 WIB [175] STATEMENT:  CREATE SCHEMA ref;
2022-06-25 01:01:04.212 WIB [175] ERROR:  schema "sarpras" already exists
2022-06-25 01:01:04.212 WIB [175] STATEMENT:  CREATE SCHEMA sarpras;
2022-06-25 01:01:04.219 WIB [175] ERROR:  schema "siak" already exists
2022-06-25 01:01:04.219 WIB [175] STATEMENT:  CREATE SCHEMA siak;
2022-06-25 01:01:04.227 WIB [175] ERROR:  schema "sync" already exists
2022-06-25 01:01:04.227 WIB [175] STATEMENT:  CREATE SCHEMA sync;
2022-06-25 01:01:04.435 WIB [175] ERROR:  relation "aplikasi" already exists
2022-06-25 01:01:04.435 WIB [175] STATEMENT:  CREATE TABLE man_akses.aplikasi (
	    id_aplikasi uuid NOT NULL,
	    id_organisasi uuid,
	    nm_aplikasi character varying(100) NOT NULL,
	    ket_aplikasi character varying(500),
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:04.445 WIB [175] ERROR:  relation "log_otentikasi" already exists
2022-06-25 01:01:04.445 WIB [175] STATEMENT:  CREATE TABLE man_akses.log_otentikasi (
	    token_sesi uuid NOT NULL,
	    id_pengguna uuid NOT NULL,
	    create_time timestamp(6) without time zone NOT NULL,
	    last_activity timestamp(6) without time zone DEFAULT '2016-08-14 20:45:31.059'::timestamp without time zone,
	    log_off timestamp(6) without time zone,
	    a_time_out numeric(1,0) DEFAULT 0 NOT NULL,
	    alamat_ip character varying(50),
	    a_sesi_aktif numeric(1,0) NOT NULL
	);
2022-06-25 01:01:04.458 WIB [175] ERROR:  relation "log_otorisasi" already exists
2022-06-25 01:01:04.458 WIB [175] STATEMENT:  CREATE TABLE man_akses.log_otorisasi (
	    token_sesi uuid NOT NULL,
	    id_role_pengguna uuid NOT NULL,
	    create_time timestamp(6) without time zone NOT NULL,
	    last_activity timestamp(6) without time zone DEFAULT '2016-08-14 20:45:31.059'::timestamp without time zone,
	    log_off timestamp(6) without time zone,
	    a_time_out numeric(1,0) DEFAULT 0 NOT NULL,
	    alamat_ip character varying(50),
	    a_sesi_aktif numeric(1,0) NOT NULL
	);
2022-06-25 01:01:04.468 WIB [175] ERROR:  relation "log_pengguna" already exists
2022-06-25 01:01:04.468 WIB [175] STATEMENT:  CREATE TABLE man_akses.log_pengguna (
	    id_pengguna uuid NOT NULL,
	    id_aplikasi uuid NOT NULL,
	    count_login numeric(8,0) DEFAULT 0 NOT NULL,
	    last_login timestamp(6) without time zone,
	    alamat_ip character varying(50),
	    ket character varying(128),
	    last_logout timestamp(6) without time zone,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    soft_delete numeric(1,0) NOT NULL,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    id_updater uuid NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL,
	    tgl_create timestamp(6) without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL
	);
2022-06-25 01:01:04.479 WIB [175] ERROR:  relation "menu" already exists
2022-06-25 01:01:04.479 WIB [175] STATEMENT:  CREATE TABLE man_akses.menu (
	    id_menu uuid NOT NULL,
	    id_aplikasi uuid NOT NULL,
	    nm_menu character varying(100) NOT NULL,
	    nm_file character varying(100),
	    urutan_menu integer NOT NULL,
	    a_aktif numeric(1,0) NOT NULL,
	    a_tampil numeric(1,0) NOT NULL,
	    icon character varying(100),
	    level_menu numeric(3,0),
	    id_group_menu uuid,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:04.488 WIB [175] ERROR:  relation "menu_role" already exists
2022-06-25 01:01:04.488 WIB [175] STATEMENT:  CREATE TABLE man_akses.menu_role (
	    id_menu uuid NOT NULL,
	    id_peran integer NOT NULL,
	    akses_menu character varying(50),
	    a_boleh_insert numeric(1,0),
	    a_boleh_delete numeric(1,0),
	    a_boleh_update numeric(1,0),
	    a_boleh_sanggah numeric(1,0),
	    approval_menu numeric(1,0) DEFAULT 0 NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:04.496 WIB [175] ERROR:  relation "pengguna" already exists
2022-06-25 01:01:04.496 WIB [175] STATEMENT:  CREATE TABLE man_akses.pengguna (
	    id_pengguna uuid NOT NULL,
	    username character varying(60) NOT NULL,
	    password character varying(50) NOT NULL,
	    nm_pengguna character varying(200) NOT NULL,
	    tempat_lahir character varying(60),
	    tgl_lahir date,
	    jenis_kelamin character(1) NOT NULL,
	    alamat character varying(255),
	    ym character varying(60),
	    skype character varying(20),
	    no_tel character varying(20),
	    no_hp character varying(20),
	    approval_pengguna numeric(1,0) DEFAULT 0 NOT NULL,
	    a_aktif numeric(1,0) DEFAULT 1 NOT NULL,
	    tgl_ganti_pwd date,
	    id_sdm_pengguna uuid,
	    id_pd_pengguna uuid,
	    id_wil character(8) NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    soft_delete numeric(1,0) NOT NULL,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    id_updater uuid NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL,
	    token_reg character varying(100),
	    jabatan character varying(80),
	    tgl_create timestamp(6) without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    CONSTRAINT ckc_jenis_kelamin_pengguna CHECK ((jenis_kelamin = ANY (ARRAY['L'::bpchar, 'P'::bpchar, '*'::bpchar])))
	);
2022-06-25 01:01:04.504 WIB [175] ERROR:  relation "peran" already exists
2022-06-25 01:01:04.504 WIB [175] STATEMENT:  CREATE TABLE man_akses.peran (
	    id_peran integer NOT NULL,
	    nm_peran character varying(50) NOT NULL,
	    a_perlu_sk numeric(1,0) DEFAULT 0 NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:04.512 WIB [175] ERROR:  relation "role_pengguna" already exists
2022-06-25 01:01:04.512 WIB [175] STATEMENT:  CREATE TABLE man_akses.role_pengguna (
	    id_role_pengguna uuid NOT NULL,
	    id_organisasi uuid NOT NULL,
	    id_pengguna uuid NOT NULL,
	    id_peran integer NOT NULL,
	    sk_penugasan character varying(80),
	    tgl_sk_penugasan date,
	    approval_peran numeric(1,0) DEFAULT 0 NOT NULL,
	    tgl_kadaluwarsa date,
	    last_active timestamp(6) without time zone,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    soft_delete numeric(1,0) NOT NULL,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    id_updater uuid NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL,
	    tgl_create timestamp(6) without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL
	);
2022-06-25 01:01:04.520 WIB [175] ERROR:  relation "server_aplikasi" already exists
2022-06-25 01:01:04.520 WIB [175] STATEMENT:  CREATE TABLE man_akses.server_aplikasi (
	    id_aplikasi uuid NOT NULL,
	    id_lemb_iptek uuid NOT NULL,
	    base_url character varying(256) NOT NULL,
	    cas_url character varying(256),
	    ws_url character varying(256),
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    soft_delete numeric(1,0) NOT NULL,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    id_updater uuid NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL,
	    tgl_create timestamp(6) without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL
	);
2022-06-25 01:01:04.552 WIB [175] ERROR:  relation "unit_organisasi" already exists
2022-06-25 01:01:04.552 WIB [175] STATEMENT:  CREATE TABLE man_akses.unit_organisasi (
	    id_organisasi uuid NOT NULL,
	    nm_lemb character varying(100) NOT NULL,
	    jln character varying(255),
	    rt numeric(3,0),
	    rw numeric(3,0),
	    nm_dsn character varying(60),
	    ds_kel character varying(60) NOT NULL,
	    kode_pos character(5),
	    lintang numeric(11,7),
	    bujur numeric(11,7),
	    no_tel character varying(20),
	    no_fax character varying(20),
	    email character varying(60),
	    website character varying(256),
	    id_jns_lemb numeric(5,0) NOT NULL,
	    id_wil character(8) NOT NULL,
	    id_induk_organisasi uuid,
	    level_organisasi numeric(3,0),
	    id_lembaga_asal uuid NOT NULL,
	    a_aktif numeric(1,0) NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    soft_delete numeric(1,0) NOT NULL,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    id_updater uuid NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL,
	    tgl_create timestamp(6) without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    kd_kl character(3),
	    kd_satker character varying(20)
	);
2022-06-25 01:01:04.561 WIB [175] ERROR:  relation "versi_db" already exists
2022-06-25 01:01:04.561 WIB [175] STATEMENT:  CREATE TABLE man_akses.versi_db (
	    id_versi numeric(1,0) DEFAULT 1 NOT NULL,
	    versi character varying(20) DEFAULT '3.52'::character varying NOT NULL,
	    tgl_update date NOT NULL,
	    CONSTRAINT ckc_id_versi_versi_db CHECK (((id_versi >= (1)::numeric) AND (id_versi <= (1)::numeric)))
	);
2022-06-25 01:01:06.910 WIB [175] ERROR:  relation "semester" already exists
2022-06-25 01:01:06.910 WIB [175] STATEMENT:  CREATE TABLE ref.semester (
	    id_smt character(5) NOT NULL,
	    id_thn_ajaran numeric(4,0) NOT NULL,
	    nm_smt character varying(50) NOT NULL,
	    smt numeric(1,0) NOT NULL,
	    a_periode_aktif numeric(1,0) NOT NULL,
	    tgl_mulai date NOT NULL,
	    tgl_selesai date NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL,
	    CONSTRAINT ckc_smt_semester CHECK ((smt = ANY (ARRAY[(1)::numeric, (2)::numeric, (3)::numeric])))
	);
2022-06-25 01:01:06.918 WIB [175] ERROR:  relation "instalasi" already exists
2022-06-25 01:01:06.918 WIB [175] STATEMENT:  CREATE TABLE sync.instalasi (
	    id_instalasi uuid NOT NULL,
	    id_organisasi uuid NOT NULL,
	    id_lemb_iptek uuid,
	    id_wil character(8),
	    id_sp uuid,
	    jns_instalasi character(1) DEFAULT '1'::bpchar NOT NULL,
	    a_link_aktif numeric(1,0) DEFAULT 1 NOT NULL,
	    ket_link character varying(100),
	    CONSTRAINT ckc_jns_instalasi_instalas CHECK ((jns_instalasi = ANY (ARRAY['1'::bpchar, '2'::bpchar, '3'::bpchar, '4'::bpchar])))
	);
2022-06-25 01:01:11.929 WIB [175] ERROR:  relation "agama" already exists
2022-06-25 01:01:11.929 WIB [175] STATEMENT:  CREATE TABLE ref.agama (
	    id_agama smallint NOT NULL,
	    nm_agama character varying(50) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:11.938 WIB [175] ERROR:  relation "akses_net" already exists
2022-06-25 01:01:11.938 WIB [175] STATEMENT:  CREATE TABLE ref.akses_net (
	    id_akses_net smallint NOT NULL,
	    nm_akses_net character varying(50) NOT NULL,
	    media numeric(1,0) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL,
	    CONSTRAINT ckc_media_akses_ne CHECK ((media = ANY (ARRAY[(1)::numeric, (2)::numeric, (3)::numeric, (4)::numeric, (5)::numeric, (9)::numeric])))
	);
2022-06-25 01:01:11.946 WIB [175] ERROR:  relation "alat_transport" already exists
2022-06-25 01:01:11.946 WIB [175] STATEMENT:  CREATE TABLE ref.alat_transport (
	    id_alat_transport numeric(2,0) NOT NULL,
	    nm_alat_transport character varying(50) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:11.953 WIB [175] ERROR:  relation "bentuk_lembaga" already exists
2022-06-25 01:01:11.953 WIB [175] STATEMENT:  CREATE TABLE ref.bentuk_lembaga (
	    id_bentuk_lemb numeric(4,0) NOT NULL,
	    nm_bentuk_lemb character varying(100) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:11.965 WIB [175] ERROR:  relation "bentuk_pendidikan" already exists
2022-06-25 01:01:11.965 WIB [175] STATEMENT:  CREATE TABLE ref.bentuk_pendidikan (
	    id_bp smallint NOT NULL,
	    nm_bp character varying(50) NOT NULL,
	    a_jenj_paud numeric(1,0) NOT NULL,
	    a_jenj_tk numeric(1,0) NOT NULL,
	    a_jenj_sd numeric(1,0) NOT NULL,
	    a_jenj_smp numeric(1,0) NOT NULL,
	    a_jenj_sma numeric(1,0) NOT NULL,
	    a_jenj_tinggi numeric(1,0) NOT NULL,
	    dir_bina character varying(40),
	    a_aktif numeric(1,0) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:11.975 WIB [175] ERROR:  relation "bidang_fokus_iptek" already exists
2022-06-25 01:01:11.975 WIB [175] STATEMENT:  CREATE TABLE ref.bidang_fokus_iptek (
	    id_bidang_fokus uuid NOT NULL,
	    id_tahun_anggaran numeric(4,0) NOT NULL,
	    nm_bidang_fokus character varying(300) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:11.984 WIB [175] ERROR:  relation "bidang_studi" already exists
2022-06-25 01:01:11.984 WIB [175] STATEMENT:  CREATE TABLE ref.bidang_studi (
	    id_bid_studi integer NOT NULL,
	    id_induk_bidang_studi integer,
	    kode_bid_studi character varying(22),
	    nm_bid_studi character varying(100) NOT NULL,
	    a_kel numeric(1,0) NOT NULL,
	    a_jenj_paud numeric(1,0) NOT NULL,
	    a_jenj_tk numeric(1,0) NOT NULL,
	    a_jenj_sd numeric(1,0) NOT NULL,
	    a_jenj_smp numeric(1,0) NOT NULL,
	    a_jenj_sma numeric(1,0) NOT NULL,
	    a_jenj_tinggi numeric(1,0) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:11.993 WIB [175] ERROR:  relation "bidang_usaha" already exists
2022-06-25 01:01:11.993 WIB [175] STATEMENT:  CREATE TABLE ref.bidang_usaha (
	    id_bu character(10) NOT NULL,
	    nm_bu character varying(50) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.002 WIB [175] ERROR:  relation "dictionary" already exists
2022-06-25 01:01:12.002 WIB [175] STATEMENT:  CREATE TABLE ref.dictionary (
	    pk character varying(100) NOT NULL,
	    val character varying(100),
	    tb character varying(100) NOT NULL,
	    alias character varying(100)
	);
2022-06-25 01:01:12.010 WIB [175] ERROR:  relation "errortype" already exists
2022-06-25 01:01:12.010 WIB [175] STATEMENT:  CREATE TABLE ref.errortype (
	    id_err_type integer NOT NULL,
	    kategori_error integer,
	    ket character varying(255),
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.021 WIB [175] ERROR:  relation "eselon" already exists
2022-06-25 01:01:12.021 WIB [175] STATEMENT:  CREATE TABLE ref.eselon (
	    id_eselon numeric(4,0) NOT NULL,
	    nm_eselon character varying(100) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.030 WIB [175] ERROR:  relation "fokus_skim" already exists
2022-06-25 01:01:12.030 WIB [175] STATEMENT:  CREATE TABLE ref.fokus_skim (
	    id_skim uuid NOT NULL,
	    id_bidang_fokus uuid NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.038 WIB [175] ERROR:  relation "fungsi_lab" already exists
2022-06-25 01:01:12.038 WIB [175] STATEMENT:  CREATE TABLE ref.fungsi_lab (
	    id_fungsi_lab character(1) NOT NULL,
	    nm_fungsi_lab character varying(100) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.053 WIB [175] ERROR:  relation "gelar_akademik" already exists
2022-06-25 01:01:12.053 WIB [175] STATEMENT:  CREATE TABLE ref.gelar_akademik (
	    id_gelar_akad integer NOT NULL,
	    singkat_gelar character varying(20) NOT NULL,
	    nm_gelar_akad character varying(80) NOT NULL,
	    posisi_gelar numeric(1,0) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL,
	    CONSTRAINT ckc_posisi_gelar_gelar_ak CHECK ((posisi_gelar = ANY (ARRAY[(1)::numeric, (2)::numeric])))
	);
2022-06-25 01:01:12.063 WIB [175] ERROR:  relation "grade_lemb_iptek" already exists
2022-06-25 01:01:12.063 WIB [175] STATEMENT:  CREATE TABLE ref.grade_lemb_iptek (
	    id_grade_lemb_iptek numeric(4,0) NOT NULL,
	    nm_grade_lemb_iptek character varying(100) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.071 WIB [175] ERROR:  relation "ikatan_kerja_sdm" already exists
2022-06-25 01:01:12.071 WIB [175] STATEMENT:  CREATE TABLE ref.ikatan_kerja_sdm (
	    id_ikatan_kerja character(1) NOT NULL,
	    nm_ikatan_kerja character varying(50) NOT NULL,
	    ket_ikatan_kerja character varying(150) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.079 WIB [175] ERROR:  relation "jab_tgs" already exists
2022-06-25 01:01:12.079 WIB [175] STATEMENT:  CREATE TABLE ref.jab_tgs (
	    id_jab_tgs numeric(5,0) NOT NULL,
	    id_kel_prof numeric(5,0) NOT NULL,
	    nm_jab_tgs character varying(50) NOT NULL,
	    a_jab_utama_sek numeric(1,0) DEFAULT 0 NOT NULL,
	    a_jab_utama_pt numeric(1,0) DEFAULT 0 NOT NULL,
	    a_jab_utama_lpnk numeric(1,0) DEFAULT 0 NOT NULL,
	    a_jab_utama_lpk numeric(1,0) DEFAULT 0 NOT NULL,
	    jml_jam_diakui numeric(2,0),
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.087 WIB [175] ERROR:  relation "jabfung" already exists
2022-06-25 01:01:12.087 WIB [175] STATEMENT:  CREATE TABLE ref.jabfung (
	    id_jabfung numeric(5,0) NOT NULL,
	    id_kel_prof numeric(5,0) NOT NULL,
	    nm_jabfung character varying(50) NOT NULL,
	    angka_kredit numeric(7,2),
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.095 WIB [175] ERROR:  relation "jalur_masuk" already exists
2022-06-25 01:01:12.095 WIB [175] STATEMENT:  CREATE TABLE ref.jalur_masuk (
	    id_jalur_masuk numeric(4,0) NOT NULL,
	    id_jenj_didik numeric(2,0),
	    nm_jalur_masuk character varying(60) NOT NULL,
	    ket_jalur_masuk character varying(200),
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.103 WIB [175] ERROR:  relation "jenis_akt_mhs" already exists
2022-06-25 01:01:12.103 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_akt_mhs (
	    id_jns_akt_mhs numeric(2,0) NOT NULL,
	    nm_jns_akt_mhs character varying(50) NOT NULL,
	    ket_jns_akt_mhs character varying(100),
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL,
	    a_kegiatan_kampus_merdeka numeric(1,0) DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.112 WIB [175] ERROR:  relation "jenis_bahan_ajar" already exists
2022-06-25 01:01:12.112 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_bahan_ajar (
	    id_jns_bhn_ajar integer NOT NULL,
	    nm_jns_bhn_ajar character varying(100) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.125 WIB [175] ERROR:  relation "jenis_bantuan" already exists
2022-06-25 01:01:12.125 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_bantuan (
	    id_jns_bantu integer NOT NULL,
	    nm_jns_bantu character varying(80),
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.133 WIB [175] ERROR:  relation "jenis_beasiswa" already exists
2022-06-25 01:01:12.133 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_beasiswa (
	    id_jns_beasiswa integer NOT NULL,
	    id_sumber_dana numeric(4,0) NOT NULL,
	    nm_jns_beasiswa character varying(50) NOT NULL,
	    u_pd numeric(1,0) DEFAULT 1 NOT NULL,
	    u_ptk numeric(1,0) DEFAULT 1 NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.141 WIB [175] ERROR:  relation "jenis_bina_iptek" already exists
2022-06-25 01:01:12.141 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_bina_iptek (
	    id_jns_bina_iptek numeric(4,0) NOT NULL,
	    nm_jns_bina_iptek character varying(100) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.149 WIB [175] ERROR:  relation "jenis_diklat" already exists
2022-06-25 01:01:12.149 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_diklat (
	    id_jns_diklat integer NOT NULL,
	    nm_jns_diklat character varying(50) NOT NULL,
	    u_dosen numeric(1,0) NOT NULL,
	    u_guru numeric(1,0) NOT NULL,
	    u_tendik numeric(1,0) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.157 WIB [175] ERROR:  relation "jenis_evaluasi" already exists
2022-06-25 01:01:12.157 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_evaluasi (
	    id_jns_eval smallint NOT NULL,
	    nm_jns_eval character varying(50) NOT NULL,
	    ket_jns_eval character varying(100),
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.164 WIB [175] ERROR:  relation "jenis_gugus" already exists
2022-06-25 01:01:12.164 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_gugus (
	    id_jns_gugus numeric(3,0) NOT NULL,
	    nm_jns_gugus character varying(50) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.174 WIB [175] ERROR:  relation "jenis_hapus_buku" already exists
2022-06-25 01:01:12.174 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_hapus_buku (
	    id_hapus_buku character(1) NOT NULL,
	    ket_hapus_buku character varying(80) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.183 WIB [175] ERROR:  relation "jenis_indeks_kutipan" already exists
2022-06-25 01:01:12.183 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_indeks_kutipan (
	    id_jns_indeks_kutip numeric(3,0) NOT NULL,
	    nm_jns_indeks_kutip character varying(50) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.191 WIB [175] ERROR:  relation "jenis_keluar" already exists
2022-06-25 01:01:12.191 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_keluar (
	    id_jns_keluar character(1) NOT NULL,
	    ket_keluar character varying(40) NOT NULL,
	    a_pd numeric(1,0) NOT NULL,
	    a_ptk numeric(1,0) NOT NULL,
	    a_sdm_iptek numeric(1,0) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.199 WIB [175] ERROR:  relation "jenis_kepanitiaan" already exists
2022-06-25 01:01:12.199 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_kepanitiaan (
	    id_jns_panitia integer NOT NULL,
	    nm_jns_panitia character varying(100) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.224 WIB [175] ERROR:  relation "jenis_kesejahteraan" already exists
2022-06-25 01:01:12.224 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_kesejahteraan (
	    id_jns_sejahtera integer NOT NULL,
	    nm_jns_sejahtera character varying(50) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.237 WIB [175] ERROR:  relation "jenis_lembaga" already exists
2022-06-25 01:01:12.237 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_lembaga (
	    id_jns_lemb numeric(5,0) NOT NULL,
	    nm_jns_lemb character varying(100) NOT NULL,
	    a_sp numeric(1,0) NOT NULL,
	    a_lemb_akred numeric(1,0) NOT NULL,
	    a_pengelola_pendidikan numeric(1,0) NOT NULL,
	    a_sms numeric(1,0) NOT NULL,
	    a_tmpt_pengawas numeric(1,0) NOT NULL,
	    a_lemb_iptek numeric(1,0) NOT NULL,
	    a_smi numeric(1,0) DEFAULT 0 NOT NULL,
	    sort integer,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.251 WIB [175] ERROR:  relation "jenis_media_pub" already exists
2022-06-25 01:01:12.251 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_media_pub (
	    id_jns_media numeric(2,0) NOT NULL,
	    nm_jns_media character varying(80) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.259 WIB [175] ERROR:  relation "jenis_pendaftaran" already exists
2022-06-25 01:01:12.259 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_pendaftaran (
	    id_jns_daftar numeric(2,0) NOT NULL,
	    nm_jns_daftar character varying(50) NOT NULL,
	    u_daftar_sekolah numeric(1,0) NOT NULL,
	    u_daftar_rombel numeric(1,0) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.268 WIB [175] ERROR:  relation "jenis_penelitian" already exists
2022-06-25 01:01:12.268 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_penelitian (
	    id_jns_lit numeric(4,0) NOT NULL,
	    nm_jns_lit character varying(100) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT date_trunc('second'::text, now()) NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT date_trunc('second'::text, now()) NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.276 WIB [175] ERROR:  relation "jenis_penghargaan" already exists
2022-06-25 01:01:12.276 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_penghargaan (
	    id_jns_penghargaan integer NOT NULL,
	    nm_jns_penghargaan character varying(160) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL,
	    u_sdm numeric(1,0) DEFAULT 0 NOT NULL,
	    u_lembaga numeric(1,0) DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.286 WIB [175] ERROR:  relation "jenis_prasarana" already exists
2022-06-25 01:01:12.286 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_prasarana (
	    id_jns_prasarana integer NOT NULL,
	    nm_jns_prasarana character varying(250) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.294 WIB [175] ERROR:  relation "jenis_prestasi" already exists
2022-06-25 01:01:12.294 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_prestasi (
	    id_jns_prestasi integer NOT NULL,
	    nm_jns_prestasi character varying(160) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.302 WIB [175] ERROR:  relation "jenis_publikasi" already exists
2022-06-25 01:01:12.302 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_publikasi (
	    id_jns_pub integer NOT NULL,
	    nm_jns_pub character varying(100) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL,
	    a_pub_prestasi numeric(1,0)
	);
2022-06-25 01:01:12.321 WIB [175] ERROR:  relation "jenis_sarana" already exists
2022-06-25 01:01:12.321 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_sarana (
	    id_jns_sarana integer NOT NULL,
	    nm_jns_sarana character varying(60) NOT NULL,
	    kel character varying(50),
	    a_penempatan numeric(1,0) NOT NULL,
	    ket character varying(128),
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.337 WIB [175] ERROR:  relation "jenis_sdm" already exists
2022-06-25 01:01:12.337 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_sdm (
	    id_jns_sdm numeric(2,0) NOT NULL,
	    nm_jns_sdm character varying(50) NOT NULL,
	    id_kel_prof numeric(5,0) NOT NULL,
	    a_guru_kelas numeric(1,0) DEFAULT 0 NOT NULL,
	    a_guru_mapel numeric(1,0) DEFAULT 0 NOT NULL,
	    a_guru_bk numeric(1,0) DEFAULT 0 NOT NULL,
	    a_guru_inklusi numeric(1,0) DEFAULT 0 NOT NULL,
	    a_pengawas_sp numeric(1,0) DEFAULT 0 NOT NULL,
	    a_pengawas_plb numeric(1,0) DEFAULT 0 NOT NULL,
	    a_pengawas_mapel numeric(1,0) DEFAULT 0 NOT NULL,
	    a_pengawas_bid numeric(1,0) DEFAULT 0 NOT NULL,
	    a_tas numeric(1,0) DEFAULT 0 NOT NULL,
	    a_formal numeric(1,0) NOT NULL,
	    a_dosen numeric(1,0) NOT NULL,
	    a_peneliti numeric(1,0) NOT NULL,
	    a_perekayasa numeric(1,0) NOT NULL,
	    a_pranata_1 numeric(1,0) DEFAULT 0 NOT NULL,
	    a_pranata_2 numeric(1,0) DEFAULT 0 NOT NULL,
	    a_pranata_3 numeric(1,0) DEFAULT 0 NOT NULL,
	    a_pranata_4 numeric(1,0) DEFAULT 0 NOT NULL,
	    a_pranata_5 numeric(1,0) DEFAULT 0 NOT NULL,
	    a_pranata_6 numeric(1,0) DEFAULT 0 NOT NULL,
	    a_pranata_7 numeric(1,0) DEFAULT 0 NOT NULL,
	    a_pranata_8 numeric(1,0) DEFAULT 0 NOT NULL,
	    a_pranata_9 numeric(1,0) DEFAULT 0 NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.353 WIB [175] ERROR:  relation "jenis_sert" already exists
2022-06-25 01:01:12.353 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_sert (
	    id_jns_sert numeric(3,0) NOT NULL,
	    nm_jns_sert character varying(50) NOT NULL,
	    u_prof_guru numeric(1,0) NOT NULL,
	    u_kepsek numeric(1,0) NOT NULL,
	    u_laboran numeric(1,0) NOT NULL,
	    u_prof_dosen numeric(1,0) DEFAULT 0 NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL,
	    u_lembaga numeric(1,0) DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.370 WIB [175] ERROR:  relation "jenis_smi" already exists
2022-06-25 01:01:12.370 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_smi (
	    id_jns_smi character(1) NOT NULL,
	    nm_jns_smi character varying(200) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.381 WIB [175] ERROR:  relation "jenis_sms" already exists
2022-06-25 01:01:12.381 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_sms (
	    id_jns_sms numeric(2,0) NOT NULL,
	    nm_jns_sms character varying(50) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.397 WIB [175] ERROR:  relation "jenis_subst" already exists
2022-06-25 01:01:12.397 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_subst (
	    id_jns_subst character(5) NOT NULL,
	    nm_jns_subst character varying(50) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.412 WIB [175] ERROR:  relation "jenis_tes" already exists
2022-06-25 01:01:12.412 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_tes (
	    id_jns_tes numeric(3,0) NOT NULL,
	    nm_jns_tes character varying(50) NOT NULL,
	    ket character varying(80),
	    nilai_maks numeric(6,2) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.420 WIB [175] ERROR:  relation "jenis_tinggal" already exists
2022-06-25 01:01:12.420 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_tinggal (
	    id_jns_tinggal numeric(2,0) NOT NULL,
	    nm_jns_tinggal character varying(50) NOT NULL,
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:12.430 WIB [175] ERROR:  relation "jenis_tunjangan" already exists
2022-06-25 01:01:12.430 WIB [175] STATEMENT:  CREATE TABLE ref.jenis_tunjangan (
	    id_jns_tunj integer NOT NULL,
	    nm_jns_tunj character varying(50),
	    create_date timestamp(6) without time zone DEFAULT now() NOT NULL,
	    last_update timestamp(6) without time zone DEFAULT now() NOT NULL,
	    expired_date timestamp(6) without time zone,
	    last_sync timestamp(6) without time zone DEFAULT '1901-01-01 00:00:00'::timestamp without time zone NOT NULL,
	    csf bigint DEFAULT 0 NOT NULL
	);
2022-06-25 01:01:14.200 WIB [175] LOG:  could not receive data from client: Connection reset by peer
2022-06-25 01:01:20.315 WIB [180] FATAL:  database "template0" is not currently accepting connections
2022-06-25 01:01:29.152 WIB [187] FATAL:  database "template0" is not currently accepting connections
2022-06-25 01:02:15.430 WIB [173] LOG:  could not receive data from client: Connection reset by peer
2022-06-25 01:02:15.430 WIB [190] LOG:  could not receive data from client: Connection reset by peer
2022-06-25 01:02:15.431 WIB [164] LOG:  could not receive data from client: Connection reset by peer
2022-06-25 01:02:15.432 WIB [158] LOG:  could not receive data from client: Connection reset by peer
2022-06-25 01:09:36.015 WIB [233] FATAL:  database "N3wf33der" does not exist
2022-06-25 01:10:24.895 WIB [237] ERROR:  column "condition_timing" does not exist at character 39
2022-06-25 01:10:24.895 WIB [237] STATEMENT:  
	    SELECT
	      trigger_name,
	      condition_timing as timing,
	      event_manipulation as manipulation,
	      action_statement as action,
	      action_condition as condition
	    FROM information_schema.triggers
	    WHERE event_object_schema = $1
	    AND event_object_table = $2
	  
2022-06-25 01:10:43.855 WIB [242] ERROR:  column "condition_timing" does not exist at character 39
2022-06-25 01:10:43.855 WIB [242] STATEMENT:  
	    SELECT
	      trigger_name,
	      condition_timing as timing,
	      event_manipulation as manipulation,
	      action_statement as action,
	      action_condition as condition
	    FROM information_schema.triggers
	    WHERE event_object_schema = $1
	    AND event_object_table = $2
	  
2022-06-25 01:11:05.005 WIB [246] ERROR:  column "condition_timing" does not exist at character 39
2022-06-25 01:11:05.005 WIB [246] STATEMENT:  
	    SELECT
	      trigger_name,
	      condition_timing as timing,
	      event_manipulation as manipulation,
	      action_statement as action,
	      action_condition as condition
	    FROM information_schema.triggers
	    WHERE event_object_schema = $1
	    AND event_object_table = $2
	  
2022-06-25 01:11:18.426 WIB [249] ERROR:  column "condition_timing" does not exist at character 39
2022-06-25 01:11:18.426 WIB [249] STATEMENT:  
	    SELECT
	      trigger_name,
	      condition_timing as timing,
	      event_manipulation as manipulation,
	      action_statement as action,
	      action_condition as condition
	    FROM information_schema.triggers
	    WHERE event_object_schema = $1
	    AND event_object_table = $2
	  
2022-06-25 01:11:36.890 WIB [250] ERROR:  column "condition_timing" does not exist at character 39
2022-06-25 01:11:36.890 WIB [250] STATEMENT:  
	    SELECT
	      trigger_name,
	      condition_timing as timing,
	      event_manipulation as manipulation,
	      action_statement as action,
	      action_condition as condition
	    FROM information_schema.triggers
	    WHERE event_object_schema = $1
	    AND event_object_table = $2
	  
2022-06-25 01:11:39.586 WIB [246] ERROR:  column "condition_timing" does not exist at character 39
2022-06-25 01:11:39.586 WIB [246] STATEMENT:  
	    SELECT
	      trigger_name,
	      condition_timing as timing,
	      event_manipulation as manipulation,
	      action_statement as action,
	      action_condition as condition
	    FROM information_schema.triggers
	    WHERE event_object_schema = $1
	    AND event_object_table = $2
	  
2022-06-25 01:13:12.064 WIB [209] LOG:  could not receive data from client: Connection reset by peer
2022-06-25 01:15:24.975 WIB [275] ERROR:  cannot drop the currently open database
2022-06-25 01:15:24.975 WIB [275] STATEMENT:  DROP DATABASE pddikti;
	
2022-06-25 01:15:24.993 WIB [275] ERROR:  option "locale" not recognized at character 69
2022-06-25 01:15:24.993 WIB [275] STATEMENT:  CREATE DATABASE pddikti WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE = 'Indonesian_Indonesia.1252';
	
	
	
2022-06-25 01:18:02.993 WIB [289] ERROR:  column "condition_timing" does not exist at character 39
2022-06-25 01:18:02.993 WIB [289] STATEMENT:  
	    SELECT
	      trigger_name,
	      condition_timing as timing,
	      event_manipulation as manipulation,
	      action_statement as action,
	      action_condition as condition
	    FROM information_schema.triggers
	    WHERE event_object_schema = $1
	    AND event_object_table = $2
	  
2022-06-25 01:19:40.548 WIB [302] ERROR:  cannot drop the currently open database
2022-06-25 01:19:40.548 WIB [302] STATEMENT:  DROP DATABASE pddikti_sandbox;
	
2022-06-25 01:19:40.559 WIB [302] ERROR:  option "locale" not recognized at character 77
2022-06-25 01:19:40.559 WIB [302] STATEMENT:  CREATE DATABASE pddikti_sandbox WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE = 'Indonesian_Indonesia.1252';
	
	
	
2022-06-25 01:29:47.006 WIB [369] ERROR:  column "condition_timing" does not exist at character 39
2022-06-25 01:29:47.006 WIB [369] STATEMENT:  
	    SELECT
	      trigger_name,
	      condition_timing as timing,
	      event_manipulation as manipulation,
	      action_statement as action,
	      action_condition as condition
	    FROM information_schema.triggers
	    WHERE event_object_schema = $1
	    AND event_object_table = $2
	  
2022-06-25 01:33:22.942 WIB [1] LOG:  received fast shutdown request
2022-06-25 01:33:22.967 WIB [1] LOG:  aborting any active transactions
2022-06-25 01:33:22.971 WIB [1] LOG:  background worker "logical replication launcher" (PID 33) exited with exit code 1
2022-06-25 01:33:22.971 WIB [28] LOG:  shutting down
2022-06-25 01:33:23.340 WIB [1] LOG:  database system is shut down
