PostgreSQL
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');