PostgreSQL
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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');