https://rt-wiki.bestpractical.com/index.php?action=history&feed=atom&title=PostgreSQLPostgreSQL - Revision history2026-08-22T18:15:21ZRevision history for this page on the wikiMediaWiki 1.41.1https://rt-wiki.bestpractical.com/index.php?title=PostgreSQL&diff=2627&oldid=prevAdmin: 2 revisions imported2016-04-06T20:20:29Z<p>2 revisions imported</p>
<p><b>New page</b></p><div>= Download &amp; Information =<br />
<br />
The [[PostgreSQL]] database is available from http://www.postgresql.org<br />
<br />
----<br />
<br />
= Specific Error Messages =<br />
<br />
----<br />
<br />
== Database Authentication ==<br />
<br />
Authentication errors can show errors such as:<br />
<br />
WARNING: nonstandard use of \\ in a string literal at character 47<br />
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.<br />
FATAL: password authentication failed for user "rt_user"<br />
<br />
<br />
in the [[PostgreSQL]] log and errors in the apache log such as:<br />
<br />
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<br />
<br />
<br />
One cause of this can be an upgrade situation where the [[RT SiteConfig|RT_SiteConfig]].pm has the old syntax such as:<br />
<br />
$DatabasePassword = 'foobar';<br />
<br />
<br />
which is no longer recognized, and needs to now be expressed like:<br />
<br />
Set($DatabasePassword , 'foobar');<br />
<br />
----</div>Admin