Re: Users which aren't users?

    Problem resolved;
    It seemed to be due to some difference in the encrypted password file to pg_shadow.
    I altered the password in this file and all's well again.
    Thanks very much for your help -- it's really appriciated.

    Luke

On Fri, 24 Aug 2001 10:54:04 +0100
"Oliver Elphick" <olly@lfix.co.uk> wrote:

> Luke Tudor wrote:
>   >Hi,
>   >
>   >I am having slight problems adding users to my database. This problem has on
>       >ly recently occured since our systems were upgraded to Solaris 8 -- mayb
>       >e this is part of the problem?.
>   >
>   >If I try to create a user using:
>   >    "CREATE USER ttc WITH PASSWORD enter"
>   >
>   >the user appears in the pg_shadow table (and pg_pwd file). What I don't unde
>       >rstand is why the user does not appear to be able to login to the databa
>       >se if the information has been writtern into this table.
>
> What have you got in pg_hba.conf?
>
> --
> Oliver Elphick                                Oliver.Elphick@lfix.co.uk
> Isle of Wight                              http://www.lfix.co.uk/oliver
> PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
> GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
>                  ========================================
>      "I saw in the night visions, and, behold, one like the
>       Son of man came with the clouds of heaven, and came to
>       the Ancient of days, and they brought him near before
>       him. And there was given him dominion, and glory, and
>       a kingdom, that all people, nations, and languages,
>       should serve him; his dominion is an everlasting
>       dominion, which shall not pass away, and his kingdom
>       that which shall not be destroyed."
>                                     Daniel 7:13,14
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>


--

Best Regards,
Luke.

_______________________________________________________________________
Mr L. T. Tudor, Remote Sensing Group   Ph,Fx: +44 (0)1752 633151,633101
CCMS Plymouth Marine Laboratory,       E-mail: ltt@ccms.ac.uk
Prospect Place, Plymouth PL1 3DH, UK   Web site: www.npm.ac.uk/rsdas/
_______________________________________________________________________