select Column1, Column2, count(*)
from yourTable
group by Column1, Column2
HAVING count(*) > 1		

delete from mytable where id in(select id from mytable where someconditon)		

## sudo -u USERNAME pg_dump -v DATABASE > d.psql