Re: [SQL] entries in pg_shadow

> Hi.
>
> The entries entered in pg_shadow haven't ever worked for me. I've tried a
> number of times without success. If I update a user in there and set a
> password for them:
> postgres=> select * from pg_shadow;
> usename |usesysid|usecreatedb|usetrace|usesuper|usecatupd|passwd|valuntil
> ---------+--------+-----------+--------+--------+---------+-------+----------------------------
> postgres | 100|t |t |t |t | |Sat Jan31 01:00:00 2037 EST
> user1 | 1001|f |t |f |t | |
> equipment| 1004|f |t |f |t | MYPASS|
> (3 rows)
>
> This example assumes I've set my password to 'MYPASS'.
> Now I change pg_hba.conf to have a:
> host equipment 123.123.123.123 255.255.0.0 password
>
> Assuming my IP is 123.123.123.123 and the database I need to connect to is
> called equipment and the user is of course equipment...
>
> I've restarted the server and...

You may need to restart the postmaster, or do a dummy change to a user.
There is a flat file that contains the pg_shadow contents that gets
updated with normal USER commands, but SQL commands don't update it. It
is on our TODO list.

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026