...
- http://wiki.postgresql.org/wiki/YUM_Installation
- http://www.postgresql.org/docs/8.3/static/runtime-config-file-locations.html
- http://www.postgresonline.com/journal/archives/45-An-Almost-Idiots-Guide-to-PostgreSQL-YUM.html
Initializing Database
I will advocate using the defaults /usr/local/pgsql/data or /var/lib/pgsql/data as described here:
If we diverge from default settings I want it to be for a good reason.
A good reason would be that we are using a SAN.
Since we are using the local file system, I think using a default location is fine.
As I understand it, this is easy to change later:
- http://www.postgresql.org/docs/8.3/static/runtime-config-file-locations.html
- http://archives.postgresql.org/pgsql-admin/2007-05/msg00104.php
Thoughts?
Security
This is my best guess - feel free to recommend alternatives.
The dataserver should be accessible only from the following:
...