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?
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
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.
Error connecting to the server: fe_sendauth: no password supplied
password authentication failed for a user that doesn't exist when using md5 auth.
It helps me:
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
Restart the server
sudo service postgresql restart
Login into psql and set password
psql -U postgres
ALTER USER postgres with password 'new password';
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
sudo service postgresql restart
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.
sudo -u postgres -i will lead to password question. There is no password on my system you can enter. My proposal works always (hm, hopefully).
sudo -u postgress -i doesn't lead to password question (at least on my Ubuntu after default installation). Either the createuser --interactive doesn't lead to the password prompt... :(
createuser --interactive Enter name of role to add: postgres Shall the new role be a superuser? (y/n) yFirst 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.
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.
