Score:0

my postgreSQL doesn't give me password option when installing

ck flag
Eze

postgreSQL application doesn't ask me for a password when installing it to my machine. I don't know if that is why none of password i entered in my terminal is being rejected.

Please how do i solve this ?

vidarlo avatar
om flag
How do you install it?
Score:0
in flag

If you have installed PostgreSQL on a modern version of Linux from the repositories supplied by Canonical, you do not set a password. Instead, you will need to switch to the postgres user account, then connect.

Here's how:

  1. Open Terminal (or connect to the server via SSH)
  2. Switch to the postgres user account:
    sudo -i -u postgres
    
  3. Access PostgreSQL:
    psql
    
    Note: You will be connected as a superadmin, which will give you the opportunity to create accounts that can be used by applications and/or people.

That's all there is to it

I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.