Re: [INTERFACES] Connection from win95 to postgresql using JDBC andjdk1.2

Peter,

Glad you have your system back up and running! :)

I have already tried this and I received the same results as I did
without the line (Auth failure).

Your previous message stated that:

> I'm now used 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.
>

How do I load my original passwords into this hidden system file? I
added the password for doug using the following command:

pg_passwd /var/postgres/passwd

<Enter User Name> Doug
<Enter User Password> db

I did not see anything in the docs 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.

Thanks,

Doug

Peter Mount wrote:

> On Fri, 23 Jul 1999, Doug Thistlethwaite wrote:
>
> [snip]
> > host doug 207.155.49.102 255.255.255.255 password
> > /var/postgres/passwd
>
> Try it without anything after the password keyword, ie
>
> host doug 207.155.49.102 255.255.255.255 password
>
> --
> Peter T Mount peter(at)retep(dot)org(dot)uk
> Main Homepage: http://www.retep.org.uk
> PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
> Java PDF Generator: http://www.retep.org.uk/pdf