Re: connecting to the database from pgadmin client

I need to create a database and a user and make this new user the owner of this new database.
Since I cannot access postgres db from pgadmin client on my desktop,
 
I tried to do the same from the command line on the linux db server:
 
su - postgres
-bash-4.1$ psql -d postgres

postgres=#  create user puser password 'xxxxxx'

postgres=#  create database pfdb owner puser
 
If I now try to list databases using \l
it lists postgres, template0 and template1 but not the new database I created...
 
How can I create a new database successfully ? It will be easier for me to try this from the pgadmin client.
Thanks
TG

________________________________
From: Thara Vadakkeveedu <tharagv(at)yahoo(dot)com>
To: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>; "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Sent: Tuesday, September 24, 2013 8:37 PM
Subject: connecting to the database from pgadmin client

Hi
I am trying to connect to the database on a linux server from pgadmin on my windows desktop.
I see "Error connecting to the server: Fatal: password authentication failed for user "postgres"

I specified my linux server name for the host
port : 5432
Maintenance DB : postgres
username:postgres
passowrd: a passwod I set (using alter user postgres password command. I changed password as user postgres)
 
How can I connect to the postgres database ?
thanks,
thara.