PostgreSQL

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

---