Setting up PostgreSQL (Ubuntu Linux) - Cannot connect, dont know password

Get Help SQL
#1

Hello everyone,

I have just setup PostgreSQL on Ubuntu according to:
https://www.codecademy.com/article/installing-and-using-postgresql-locally

I am trying to connect to it using Postbird OR psql command line but I dont seem to know what the password is to connect.

I have followed these steps:

Create the file repository configuration:

sudo sh -c ‘echo “deb Index of /pub/repos/apt/ $(lsb_release -cs)-pgdg main” > /etc/apt/sources.list.d/pgdg.list’

# Import the repository signing key:
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -

# Update the package lists:
sudo apt-get update

# Install the latest version of PostgreSQL.
# If you want a specific version, use ‘postgresql-12’ or similar instead of ‘postgresql’:
sudo apt-get -y install postgresql

And now started the Postgres server using the following command which seems to run successfully:

sudo pg_ctlcluster 14 main start

…however I am prompted to enter a password in Postbird or PSQL command line which I don’t recall setting up or seeing in these steps? Any help is greatly appreciated.

Cheers!
Tommy

#2

Ok, looks like you can use command line to switch to default postgres system user created by install:

sudo su - postgres

Then type this command:

psql

Then you can just change the password using:

\password

1 Like
#3

Source: How To Install PostgreSQL 14 on Ubuntu 20.04 - howtodojo

Many super useful commands here that are not in the setup page. I think adding a step to explain how to connect and setup the user so Postbird can connect and allow the users to continue with the project would be super useful to people.

1 Like