1 PSQL=psql -q -1 --set ON_ERROR_STOP=1 -d news
7 configdl: active newsgroups control.ctl
9 reset: stop preserve start
11 load: stop newsdb schema activesync start
14 wget -N ftp://ftp.isc.org/pub/usenet/CONFIG/$@.bz2
18 wget -N ftp://ftp.isc.org/pub/usenet/CONFIG/$@
22 createdb -O news -T template0 -E SQL_ASCII news
23 $(PSQL) -c 'alter database news set search_path to nntp,public'
24 $(PSQL) -c 'alter database news set client_min_messages to warning'
27 sudo su -c 'psql -1 --set ON_ERROR_STOP=1 -U news -d news -f preserve.sql' news
29 activesync: loadactive loadnewsgroups
32 cat active | DBI_DSN='dbi:Pg:dbname=news' perl convactive
35 loadnewsgroups: newsgroups
36 cat newsgroups |DBI_DSN='dbi:Pg:dbname=news' perl convnewsgroups
40 -test -f newsd.pid && kill `cat newsd.pid`
42 PERL5LIB=./Net-Server-NNTP/lib ./newsd conf_file=test.conf
45 -test -f newsd.pid && kill `cat newsd.pid`
47 PERL5LIB=./Net-Server-NNTP/lib ./newsd conf_file=t/test.conf
50 -test -f newsd.pid && kill `cat newsd.pid`
53 -test -f newsd.pid && kill `cat newsd.pid`
55 PERL5LIB=./Net-Server-NNTP/lib ./newsd conf_file=t/test.conf
58 -test -f newsd.pid && kill `cat newsd.pid`
61 (echo 'set role news;'; cat schema.sql) | $(PSQL)
64 sudo ./newsd log_level=3 server_type=Single
67 sudo ./newsd log_level=2
70 -sudo sh -c "kill `cat /var/run/news/newsd.pid`"
74 .PHONY: active newsgroups control.ctl configdl