Search Postgresql Archives

Re: Changing the admin/postgres user password

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




> On Sep 5, 2022, at 19:40, Jeffrey Walton <noloader@xxxxxxxxx> wrote:
> And finally, try the new password:
> 
>    PGPASSWORD=hi...HS psql -U postgres
>    psql: error: connection to server on socket
> "/var/run/postgresql/.s.PGSQL.5432" failed:
>    FATAL:  Peer authentication failed for user "postgres"

If it's complaining about peer authentication, you are most likely not logged in as the "postgres" Linux user.  If you want other Linux users to be able to log in as the "postgres" PostgreSQL user, you'll need to edit your pg_hba.conf file to allow it; it's off by default.





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux