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

Create read-only

GRANT CONNECT ON DATABASE data TO plz;
GRANT USAGE ON SCHEMA public TO plz;
postgresql.txt · Last modified: 2018/12/03 14:52 by Jan Forman