From: Doug Thistlethwaite <doug@dupreeinc.com>
To: Peter Mount <peter@retep.org.uk>
Cc: Doug Thistlethwaite <doug@dupree3.dupreeinc.com>
Cc: pgsql-interface <pgsql-interfaces@postgreSQL.org>
Cc: doug.t@deltanet.com
Subject: Re: [INTERFACES] Connection from win95 to postgresql using JDBC andjdk1.2
Date: Fri, 23 Jul 1999 14:13:07 -0700
Message-ID: <3798DAE3.93528B14@dupreeinc.com> (raw)
References: <Pine.LNX.4.10.9907231806090.4429-100000@maidast.retep.org.uk>
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@retep.org.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: doug@dupreeinc.com, peter@retep.org.uk, doug@dupree3.dupreeinc.com, doug.t@deltanet.com
Subject: Re: [INTERFACES] Connection from win95 to postgresql using JDBC andjdk1.2
In-Reply-To: <3798DAE3.93528B14@dupreeinc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox