User Tools

Site Tools


postgresql
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
smtp_use_tls = yes
smtp_tls_security_level = dane
smtp_dns_support_level = dnssec

</code>

postgresql.txt · Last modified: 2018/10/15 14:14 by Jan Forman