To install the server locally use the command line and type
To start off, we need to set the password of the PostgreSQL user (role) called “postgres”; we will not be able to access the server externally otherwise. As the local “postgres" Linux user, we are allowed to connect and manipulate the server using the psql command.
In a terminal, type:
this connects as a role with same name as the local user, i.e. “postgres”, to the database called “postgres” (1st argument to psql).
Set a password for the “postgres” database role using the command:
and give your password when prompted. The password text will be hidden from the console for security purposes.
Type Control+D or \q to exit the posgreSQL prompt.