I'm installing Trac 1.0 on a new CentOS 6.4 server. I'm planning on using postgresql as the database backend.
General Trac Instructions are here:
Postgresql installation details for Trac are here:
I've successfully installed postgresql, and I've done the initialization:
service postgresql initdb
chkconfig postgresql on
service postgresql start
Now... I'm plenty experienced with MySQL but not postgresql. I need to create a database and a username/password which trac can use to connect. Trac is a python-based web application, it runs on Apache and will probably run under the "nobody" user.
Trac's instructions say
If you're using user trac without a password to connect through unix sockets to database trac and have only one project (hence no need for different schemas), your connections string would be postgres://trac:@/trac
That sounds pretty good, I want to set that up.
But I don't know how to administer a postgresql server, what the various commands are etc.
Can somebody give me the easy way out and tell me how to do this?