gvsrini

Create X.509 certificates

All passwords: changeit

openssl req -x509 -sha256 -days 3650 -newkey rsa:4096 -keyout rootCA.key -out rootCA.crt

Shared Secret string used to validate requests: B117F156FDFEE0AEF47AC2D2B9743057DFA1A75A999B76221AB3FC0A9862792E

	-- show running queries (pre 9.2)
	SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(clock_timestamp(), query_start), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

-delete from TRANSACTION_DETAILS_P where TR_SEQ_NO in(select TR_SEQ_NO from TRANSACTION_MASTER_P where ard_no='101101')
-delete from TRANSACTION_MASTER_P where ard_no='101101'
-delete from FAILED_TRANSACTIONS_TRAILER_P where TR_SEQ_NO in(select TR_SEQ_NO from FAILED_TRANSACTIONS_P where SHOP_NO	='101101')
-delete from FAILED_TRANSACTIONS_P where SHOP_NO	='101101'
-delete from STOCK_TRAILER_P where DN_SEQ_NO in(select DN_SEQ_NO from STOCK_HEADER_P where shop_no='101101')