postgres -D /usr/local/pgsql/data some_database
vacuum full;

OR
If vacuum full is not possible, 
vacuumdb -a -z

psql -l

CREATE DATABASE d1 WITH OWNER=some_user ENCODING='UTF8' ; 

select * from pg_stat_activity;