dennisxkimo/syslogtopg repository overview

	--superuser  peer login
	psql
	--建立user
	create user syslog password 'sql';
	--建立database
	create database syslog owner syslog;
	--離開
	\q
	--登入syslog 請先確認你的 pg_hba.conf可讓syslog可以連線
	pqsl -h 127.0.0.1 -U syslog -d syslog -W
	--建立schema
	create schema syslog ;
	grant all on schema  syslog to  syslog;
	CREATE SEQUENCE syslog.seq_syslog_sn START 1 ;
	CREATE TABLE syslog.syslog (
			SN integer NOT NULL DEFAULT nextval('syslog.seq_syslog_sn'),
			DateTime timestamp default NULL,
			IP VARCHAR(50) NULL DEFAULT NULL,
			RAW_SYSLOG TEXT NULL,
			PRIMARY KEY (SN)
	)

	version: '3.1'

	services:
	  syslogtopg:
		hostname: syslogtopg
		container_name: syslogtopg
		image: dennisxkimo/syslogtopg
		restart: always
		logging:
		  driver: "json-file"
		  options:
		  max-size: "100m"
		environment:
		  PG_IP:  <youer_postgresql_db_ip_address or youer_postgresql_docker_hostname >
		  PG_PORT: <youer_postgresql_db_port>
		  PG_USR: syslog
		  PG_DB: syslog
		  UDP_PORT: 514
		  LANG: en_US.UTF-8
		  LC_ALL: en_US.UTF-8
		  LC_CTYPE: en_US.UTF-8
		  TZ: Asia/Taipei
		ports:
		  - 514:514/udp