Name is used by another user !!

Discussion in 'macOS' started by gfroyle, Aug 26, 2006.

  1. gfroyle macrumors member

    Joined:
    Feb 8, 2004
    #1
    I just installed PostgreSQL on my Mac (G4, 10.4.7) and as part of the installation I need to add a new user to own the server process. Usually this user is called "postgres".

    So I went to System Preferences / Accounts and clicked on the + sign and entered the details, including the name "postgres" for the Short Name.

    But then the dialog reappeared with a red error message right underneath the Short Name box (and a little red arrow pointing to it) saying "Name is used by another user".

    But it isn't being used by another user; I only have three accounts on the computer and none of the other names are "postgres".

    I would like to use that username if possible because lots of sample code, examples and third-party client programs assume that the user is called "postgres" and I'd rather not have to work through source code, configuration files etc and replace it with another name every time I try out a new tool...

    Any clues?

    Thanks

    Gordon
     
  2. thewhitehart macrumors 6502a

    thewhitehart

    Joined:
    Jul 9, 2005
    Location:
    The town without George Bailey
    #2
    Did you check out the Netinfo Manager app? Perhaps there is a user with that name?
     
  3. Max on Macs macrumors 6502

    Max on Macs

    Joined:
    Feb 25, 2006
    Location:
    Milton Keynes, UK
    #3
    Well...Most servers I've installed created a user themselves if they wanted one. Maybe Postegres smartened up and done the same.
     
  4. gfroyle thread starter macrumors member

    Joined:
    Feb 8, 2004
    #4
    Thanks for that... I didn't know about that app before.

    I checked it out and indeed there is an existing user called postgres.

    It has obviously been set up by something related to PostgreSQL because the "realname" is given as PostreSQL Database Server.

    I wonder if that means I can just "chown" the data directory (where Postgres stores the actual data files) to postgres and all will be dandy.

    I'll give it a go..

    Cheers

    Gordon
     

Share This Page