Peter, <p>Glad you have your system back up and running! :) <p>I have already tried this and I received the same
resultsas I did without the line (Auth failure). <p>Your previous message stated that: <blockquote type="CITE"><pre>I'm
nowused to the more recent backends, which use the "ALTER USER" sql
statement, and the passwords are now stored in a hidden system table,
which is why my examples above don't have a file name in them.</pre></blockquote><p><br />How do I load my original
passwordsinto this hidden system file? I added the password for doug using the following command: <p>pg_passwd
/var/postgres/passwd<p><Enter User Name> Doug <br /><Enter User Password> db <p>I did not see anything in
thedocs about setting passwords into the system table. Is there a different way to enter passwords now for postgres
access? The system password for user 'doug' is not 'db' like I set it in the pg_passwd command. <p>Thanks, <p>Doug
<p>PeterMount wrote: <blockquote type="CITE">On Fri, 23 Jul 1999, Doug Thistlethwaite wrote: <p>[snip] <br />>
host doug 207.155.49.102 255.255.255.255 password <br />> /var/postgres/passwd <p>Try it without
anythingafter the password keyword, ie <p>host doug 207.155.49.102 255.255.255.255 password <p>-- <br /> Peter T
Mountpeter@retep.org.uk <br /> Main Homepage: <a href="http://www.retep.org.uk">http://www.retep.org.uk</a><br
/>PostgreSQLJDBC Faq: <a href="http://www.retep.org.uk/postgres">http://www.retep.org.uk/postgres</a><br /> Java PDF
Generator:<a href="http://www.retep.org.uk/pdf">http://www.retep.org.uk/pdf</a></blockquote>