![]() The simplest and safest way to add a password to the “postgres” user is to connect to the local server using “psql” (see steps #1 and #2 above), then type the “\password” meta command of psql. These tools need to connect through the network and work as a standard client application.īy default, when you create a PostgreSQL cluster, password authentication for the database superuser (“postgres”) is disabled. However, a lot of our customers and students love graphical interfaces (especially if you come from databases with advanced tools in this area – I on the other hand am a console guy). ![]() connect to the local server using “psql”.become the “postgres” system user (either via the root user, sudo or through SSH public key authentication).Therefore, my favourite way of connecting is: ![]() I personally use the “postgres” user just to manage global objects (roles, tablespaces, databases) and to perform regular administration duties. One of the most recurring questions I get from users that are starting their long and prosperous journey with PostgreSQL involves connecting with the “postgres” user.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |