Name is used by another user !!

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

  1. gfroyle macrumors member

    Feb 8, 2004
    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?


  2. thewhitehart macrumors 6502a


    Jul 9, 2005
    The town without George Bailey
    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

    Feb 25, 2006
    Milton Keynes, UK
    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

    Feb 8, 2004
    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..



Share This Page