PostgreSQL Support Ready For Testing

[Max Kanat-Alexander]

	Hello! As of today's CVS version, Bugzilla's PostgreSQL support is
ready for beta testing. There are still some known bugs -- see the
blockers on bug 98304 for details.

	If you encounter any bugs while using Bugzilla on PostgreSQL, please
report them to bugzilla.mozilla.org and make them block bug 98304. Also
CC me on them.

	The steps for setting up a Bugzilla installation on PostgreSQL are very
simple:

	(0) Connect to the template1 database in PostgreSQL as a PostgreSQL
superuser. (That's usually the "postgres" user.)

	(1) Create a 'bugs' user:

	CREATE USER bugs PASSWORD 'password' CREATEDB;

	(2) Make sure that your pg_hba.conf allows md5 login from the local
machine, from the 'bugs' user:

	host all bugs 127.0.0.1 255.255.255.255 md5

	(3) Make sure that your postgresql.conf allows TCP/IP connections from
the local machine:

	tcpip_socket = true

	(4) Stop PostgreSQL, and then start it again.

	(5) Set up Bugzilla normally, editing localconfig and so forth per the
instructions in the Bugzilla Guide.

	Have fun!

	And of course, if anybody needs consulting support for their PostgreSQL
Bugzilla... I'm always available. :-D

	-Max
-- 
http://www.everythingsolved.com/
Everything Solved: Experts at Bugzilla... and everything else, too.