PostgreSQL

From Request Tracker Wiki
Jump to navigation Jump to search

Download & Information

The PostgreSQL database is available from http://www.postgresql.org


Specific Error Messages


Database Authentication

Authentication errors can show errors such as:

WARNING: nonstandard use of \ in a string literal at character 47

HINT:  Use the escape string syntax for backslashes, e.g., E'\'.
FATAL:  password authentication failed for user "rt_user"

in the PostgreSQL log and errors in the apache log such as:

Connect Failed FATAL: password authentication failed for user "rt_user"\n at /usr/lib/perl5/vendor_perl/5.10.0/RT.pm line 204\n

One cause of this can be an upgrade situation where the RT_SiteConfig.pm has the old syntax such as:

$DatabasePassword = 'foobar';

which is no longer recognized, and needs to now be expressed like:

Set($DatabasePassword , 'foobar');