[POSTGRE] pg_cron
1. 설치 cd $HOME/postgresql-15.5/contrib wget https://github.com/citusdata/pg_cron/archive/refs/tags/v1.6.2.tar.gz tar -xvzf v1.6.2.tar.gz cd pg_cron-1.6.2 && make && make install 2. 설정 $PGDATA/postgresql shared_preload_libraries = 'pg_stat_statements,passwordcheck,pg_store_plans,pg_cron' cron.database_name='testdb1' $PGDATA/pg_hba.conf , $HOME/.pgpass 둘 중 하나 설정해서 자동접속 가능하게 만들어야함local ..