On Fri, 23 Jul 1999, Doug Thistlethwaite wrote:
> 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?
There's a hidden table called pg_shadow which contains the user names and
passwords, and a view called pg_user which lists the same thing (with *
replacing the password entries).
The ALTER USER statement updates pg_shadow, which then updates a flatfile
in the PGDATA directory (someone correct me if I'm wrong here, I'm pulling
this from memory), which is then used by the postmaster when the
connections are made.
This flat file is why ALTER USER should be used, not an UPDATE statement
on the pg_shadow table.
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
In response to
pgsql-interfaces by date
|Next:||From: Tom Lane||Date: 1999-07-24 15:27:16|
|Subject: Re: [INTERFACES] More VB |
|Previous:||From: Byron Nikolaidis||Date: 1999-07-24 02:58:24|
|Subject: Re: [INTERFACES] S1C00: Only SQL_POSITION/REFRESH is supported for