1. Forum
  2. Usenet
  3. COMP.DATABASES.POSTGRESQL

  • Granting linux users database access

    From Dimitri Fontaine@21:1/5 to Scott Ellis on Tue Jun 7 10:06:38 2016
    Scott Ellis <[email protected]> writes:
    I am trying to make it so that any user that accesses the database server
    can just login and run
    psql and not have to enter a password.

    Is there a way to grant the linux user this style of authentication without having to have a database user, too? There are 10 different authentication methods for postgresql, and I am not sure which one does this.

    It's called "peer".
    --
    Dimitri Fontaine
    PostgreSQL DBA, Architecte

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Scott Ellis@21:1/5 to All on Mon Jun 6 15:23:29 2016
    I am trying to make it so that any user that accesses the database server can just login and run
    psql and not have to enter a password.

    Is there a way to grant the linux user this style of authentication without having to have a database user, too? There are 10 different authentication methods for postgresql, and I am not sure which one does this.

    Thanks

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)