effective_io_concurrency = X
Can be raised for SSDs
for I in `/usr/bin/psql -d template1 -q -t -c "SELECT datname FROM pg_database WHERE datname NOT IN ('template0') ORDER BY datname;"`; do /usr/bin/pg_dump -F t ${I} | /usr/bin/lzop -1 > ${TEMPDIR}/${DATE}${I}.tar.lzo done
max_connections = 300 shared_buffers = 80MB
GRANT CONNECT ON DATABASE data TO plz; GRANT USAGE ON SCHEMA public TO plz;