Thread: Adding users?
Boy do I feel dumb. I just installed Postgres.app and pgAdmin3.app on my Mac (El Capitan). I’ve searched everywhere in the program and the docs and I can’t find out how to simply add a user. Help, please.
On 22/02/16 13:41, Rob Lewis wrote: > Boy do I feel dumb. > > I just installed Postgres.app and pgAdmin3.app on my Mac (El Capitan). > > I’ve searched everywhere in the program and the docs and I can’t find out how to simply add a user. Help, please. > Use pgadmin to make a connection to a server on the local machine. Once the connection is active, right click on the server label. You should see a "New Object" option, with three alternates, a tablespace, group role and login role. Read up on what these do, but login role might be what you need. It needs to be a local server, the same option does not appear for a remote server, at least on my machine.
You can make roles on remote servers but you'd need the roles that allow you create roles. If you don't have permission tocreate roles, you won't see the option to do so. ----- Original Message ----- From: "Colin Beckingham" <colbec@kingston.net> To: pgadmin-support@postgresql.org Sent: Monday, February 22, 2016 1:54:16 PM Subject: Re: [pgadmin-support] Adding users? On 22/02/16 13:41, Rob Lewis wrote: > Boy do I feel dumb. > > I just installed Postgres.app and pgAdmin3.app on my Mac (El Capitan). > > I’ve searched everywhere in the program and the docs and I can’t find out how to simply add a user. Help, please. > Use pgadmin to make a connection to a server on the local machine. Once the connection is active, right click on the server label. You should see a "New Object" option, with three alternates, a tablespace, group role and login role. Read up on what these do, but login role might be what you need. It needs to be a local server, the same option does not appear for a remote server, at least on my machine. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Thanks, got that done. Now “Login Roles” shows three entries: “postgres”, my Mac account short name, and the one I just created.
Next question: how do I actually use this new role to log into the server? When I give the “Connect” command, all I get is a prompt to enter the password for user “postgres”. I can’t find any way to switch to a different user account.
This is waaaaaay different from phpMyAdmin!
On Feb 22, 2016, at 10:54 , Colin Beckingham <colbec@kingston.net> wrote:On 22/02/16 13:41, Rob Lewis wrote:Boy do I feel dumb.Use pgadmin to make a connection to a server on the local machine.
I just installed Postgres.app and pgAdmin3.app on my Mac (El Capitan).
I’ve searched everywhere in the program and the docs and I can’t find out how to simply add a user. Help, please.
Once the connection is active, right click on the server label.
You should see a "New Object" option, with three alternates, a tablespace, group role and login role.
Read up on what these do, but login role might be what you need.
It needs to be a local server, the same option does not appear for a remote server, at least on my machine.
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
It is at that! You need to make a new connection, and that will give you the option to specify your new username. Use the "plug" icon or"File" > "Add server" to make a new connection. ----- Original Message ----- From: "Rob Lewis" <groblewis@mac.com> To: "Colin Beckingham" <colbec@kingston.net> Cc: pgadmin-support@postgresql.org Sent: Monday, February 22, 2016 3:02:53 PM Subject: Re: [pgadmin-support] Adding users? Thanks, got that done. Now “Login Roles” shows three entries: “postgres”, my Mac account short name, and the one I just created. Next question: how do I actually use this new role to log into the server? When I give the “Connect” command, all I get isa prompt to enter the password for user “postgres”. I can’t find any way to switch to a different user account. This is waaaaaay different from phpMyAdmin! > On Feb 22, 2016, at 10:54 , Colin Beckingham <colbec@kingston.net> wrote: > > On 22/02/16 13:41, Rob Lewis wrote: >> Boy do I feel dumb. >> >> I just installed Postgres.app and pgAdmin3.app on my Mac (El Capitan). >> >> I’ve searched everywhere in the program and the docs and I can’t find out how to simply add a user. Help, please. >> > Use pgadmin to make a connection to a server on the local machine. > Once the connection is active, right click on the server label. > You should see a "New Object" option, with three alternates, a tablespace, group role and login role. > Read up on what these do, but login role might be what you need. > It needs to be a local server, the same option does not appear for a remote server, at least on my machine. > > > -- > Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgadmin-support