Received: from candle.pha.pa.us (maillist@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.9.3/8.9.3) with ESMTP id TAA55689; Wed, 1 Sep 1999 19:26:51 -0400 (EDT) (envelope-from maillist@candle.pha.pa.us) Received: (from maillist@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id TAA25916; Wed, 1 Sep 1999 19:23:28 -0400 (EDT) From: Bruce Momjian Message-Id: <199909012323.TAA25916@candle.pha.pa.us> Subject: Re: [SQL] entries in pg_shadow In-Reply-To: from Michael Richards at "Aug 28, 1999 09:40:29 pm" To: Michael Richards Date: Wed, 1 Sep 1999 19:23:28 -0400 (EDT) CC: pgsql-sql@postgreSQL.org, hackers@postgreSQL.org X-Mailer: ELM [version 2.4ME+ PL56 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit > 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@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026