every-5-seconds.sh

#!/bin/bash
while true
do
psql soms_production -f /var/lib/pgsql/update_soms.sql
sleep 5
done

update_soms.sql

INSERT INTO conversation_fs

SELECT id, service_date, service_id, resource_id, status, region, subject, district, office, personal, wild_queue,
source_id, start_time, end_time, name, passport_number, passport_series, objects_count, organization_name, ogrn, inn,
kpp, schedule_id, created_at, updated_at, external_id, duration, service_name, process_out, get_out

FROM dblink('dbname=suo_production', 'select  id, service_date, service_id, resource_id, status, region, subject,
district, office, personal, wild_queue, source_id, start_time, end_time, name, passport_number, passport_series,
objects_count, organization_name, ogrn, inn, kpp, schedule_id, created_at, updated_at, external_id, duration, service_name,
process_out, get_out from conversation_fs')

AS t(id integer, service_date timestamp without time zone, service_id integer, resource_id integer, status varchar, region varchar,
subject varchar, district varchar, office varchar, personal boolean, wild_queue boolean, source_id integer,
start_time timestamp without time zone, end_time timestamp without time zone, name varchar, passport_number varchar,
passport_series varchar, objects_count integer, organization_name varchar, ogrn bigint, inn bigint, kpp integer,
schedule_id integer, created_at timestamp without time zone, updated_at timestamp without time zone, external_id integer,
duration integer, service_name varchar, process_out integer, get_out integer)

WHERE t.id > (SELECT CASE WHEN MAX(id) IS NULL THEN 0 ELSE MAX(id) END FROM conversation_fs);