<div>
<div class="content wysiwyg-content">
Hi all, 
 
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: 
<a href="http://trac.edgewall.org/wiki/TracInstall" rel="ugc">http://trac.edgewall.org/wiki/TracInstall</a> 
 
Postgresql installation details for Trac are here: 
<a href="http://trac.edgewall.org/wiki/DatabaseBackend#Postgresql" rel="ugc">http://trac.edgewall.org/wiki/DatabaseBackend#Postgresql</a> 
 
I've successfully installed postgresql, and I've done the initialization: 
 
&nbsp; &nbsp;service postgresql initdb 
&nbsp; &nbsp;chkconfig postgresql on 
&nbsp; &nbsp;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 &quot;nobody&quot; user. 
 
Trac's instructions say 

<blockquote>
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
</blockquote>
 
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?
</div>
</div>

Hi all,

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:
http://trac.edgewall.org/wiki/TracInstall

Postgresql installation details for Trac are here:
http://trac.edgewall.org/wiki/DatabaseBackend#Postgresql

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?

Setting up postgresql to talk to Trac

PostgreSQL is an object-relational database management system with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications. PostgreSQL implements the majority of the SQL2011 standard, is ACID-compliant and transactional using multiversion concurrency control (MVCC), and handles complex SQL queries using many indexing methods that are not available in other databases. It is cross-platform and runs on many operating systems including Linux, FreeBSD, OS X, Solaris, and Microsoft Windows.

PostgreSQL

The Apache HTTP Server is a secure, efficient and extensible server that provides HTTP services in sync with the current HTTP standards. Typically Apache is run on a Unix-like operating system, but it is available for a wide variety of operating systems, including Linux, Novell NetWare, Mac OS-X and Windows. Released under the Apache License, Apache is open-source software.

Apache Web Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.