Changes

From SME Server

610 bytes added , 09:54, 4 November 2007

no edit summary

Line 34: Line 34:

exit

−

Edit the file '''/etc/e-smith/templates-custom/var/lib/pgsql/data/postgresql.conf''' and change the following settings:

Edit the file '''/etc/e-smith/templates-custom/var/lib/pgsql/data/postgresql.conf''' remove # and change the following settings:

superuser_reserved_connections=2

Line 49: Line 49:

Edit the file '''/etc/e-smith/templates-custom/var/lib/pgsql/data/pg_hba.conf''' and change the following settings:

local all all md5

host all all 127.0.0.1/32 md5

host all all ::1/128 md5

and add at the end:

host all all 0.0.0.0 255.255.255.255 reject

Add a plus new white line at the end.

Expand template:

expand-template /var/lib/pgsql/data/pg_hba.conf

expand-template /var/lib/pgsql/data/postgresql.conf

Restart with new settings:

/etc/init.d/postgresql stop

/etc/init.d/postgresql start

and add the symlinks to start automatically:

ln -s /etc/init.d/postgresql /etc/rc.d/rc7.d/S56postgresql

ln -s /etc/init.d/postgresql /etc/rc.d/rc6.d/K03postgresql

985

edits

Postgresql (view source)