How to connect Postgres to localhost server using pgAdmin on Ubuntu?
PostgresqlDatabase ConnectionPgadminPostgresql Problem Overview
I installed Postgres with this command
sudo apt-get install postgresql postgresql-client postgresql-contrib libpq-dev
Using psql --version
on terminal I get psql (PostgreSQL) 9.3.4
then I installed pgadmin
with
sudo apt-get install pgadmin3
Later I opened the UI and create the server with this information
but this error appear
how can I fix it?
Postgresql Solutions
Solution 1 - Postgresql
Modify password for role postgres:
sudo -u postgres psql postgres
alter user postgres with password 'postgres';
Now connect to pgadmin using username postgres and password postgres
Now you can create roles & databases using pgAdmin
https://stackoverflow.com/questions/12720967/is-possible-to-check-or-change-postgresql-user-password
Solution 2 - Postgresql
You haven't created a user db
. If its just a fresh install, the default user is postgres
and the password should be blank. After you access it, you can create the users you need.
Solution 3 - Postgresql
It helps me:
- Open the file
pg_hba.conf
> sudo nano /etc/postgresql/9.x/main/pg_hba.conf
and change this line:
Database administrative login by Unix domain socket
local all postgres md5
to
Database administrative login by Unix domain socket
local all postgres trust
2. Restart the server >sudo service postgresql restart
- Login into psql and set password >psql -U postgres
ALTER USER postgres with password 'new password';
- Again open the file
pg_hba.conf
and change this line:
Database administrative login by Unix domain socket local all postgres trust
to
Database administrative login by Unix domain socket local all postgres md5
- Restart the server >sudo service postgresql restart
It works.
Helpful links
1: PostgreSQL (from ubuntu.com)
Solution 4 - Postgresql
Create a user first. You must do this as user postgres. Because the postgres system account has no password assigned, you can either set a password first, or you go like this:
sudo /bin/bash
# you should be root now
su postgres
# you are postgres now
createuser --interactive
and the programm will prompt you.
Solution 5 - Postgresql
First you should change the password using terminal. (username is postgres)
postgres=# \password postgres
Then you will be prompted to enter the password and confirm it.
Now you will be able to connect using pgadmin with the new password.
Solution 6 - Postgresql
if you open the psql
console in a terminal window, by typing
$ psql
you're super user username will be shown before the =#
, for example:
elisechant=#
$
That will be the user name you should use for localhost.