PostgreSQL从日志表中删除旧logging

我有一个存储我的RADIUS连接信息的PostgreSQL数据库。 我想要做的只是存储一个月的日志。 我将如何创build一个SQL语句，我可以从cron运行，将删除和行超过一个月？

表格中date的格式。 该date取自acctstoptime栏。 date格式2010-01-27 16：02：17-05

有问题的表的格式。 – 表：radacct

CREATE TABLE radacct ( radacctid bigserial NOT NULL, acctsessionid character varying(32) NOT NULL, acctuniqueid character varying(32) NOT NULL, username character varying(253), groupname character varying(253), realm character varying(64), nasipaddress inet NOT NULL, nasportid character varying(15), nasporttype character varying(32), acctstarttime timestamp with time zone, acctstoptime timestamp with time zone, acctsessiontime bigint, acctauthentic character varying(32), connectinfo_start character varying(50), connectinfo_stop character varying(50), acctinputoctets bigint, acctoutputoctets bigint, calledstationid character varying(50), callingstationid character varying(50), acctterminatecause character varying(32), servicetype character varying(32), xascendsessionsvrkey character varying(10), framedprotocol character varying(32), framedipaddress inet, acctstartdelay integer, acctstopdelay integer, freesidestatus character varying(32), CONSTRAINT radacct_pkey PRIMARY KEY (radacctid) ) WITH (OIDS=FALSE); ALTER TABLE radacct OWNER TO radius; -- Index: freesidestatus CREATE INDEX freesidestatus ON radacct USING btree (freesidestatus); -- Index: radacct_active_user_idx CREATE INDEX radacct_active_user_idx ON radacct USING btree (username, nasipaddress, acctsessionid) WHERE acctstoptime IS NULL; -- Index: radacct_start_user_idx CREATE INDEX radacct_start_user_idx ON radacct USING btree (acctstarttime, username); 

• WSS_Content包含？
• 如何更改连接到Oracle数据库的最大数量？
• 数据库myDb不可访问。 （ObjectExplorer）
• Postgresql表下降需要很长时间
• 数据大小的sql server限制

 DELETE FROM radacct WHERE acctstoptime < (now() - '30 days'::interval); 

 REINDEX TABLE radacct;