From: Thara Vadakkeveedu <tharagv@yahoo.com>
To: Albe Laurenz <laurenz.albe@wien.gv.at>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: connecting to the database from pgadmin client
Date: Tue, 24 Sep 2013 18:30:27 -0700 (PDT)
Message-ID: <1380072627.42016.YahooMailNeo@web125006.mail.ne1.yahoo.com> (raw)
In-Reply-To: <1380069469.70241.YahooMailNeo@web125005.mail.ne1.yahoo.com>
References: <48F1E182B1021B449414C85E713CE8250E61E0@WLT-MBX03.KRONOS.com>
<1379975782.27726.YahooMailNeo@web125005.mail.ne1.yahoo.com>
<A737B7A37273E048B164557ADEF4A58B17C23A2B@ntex2010a.host.magwien.gv.at>
<1380030420.19939.YahooMailNeo@web125003.mail.ne1.yahoo.com>
<1380030784.27416.YahooMailNeo@web125003.mail.ne1.yahoo.com>
<1380031785.83405.YahooMailNeo@web125005.mail.ne1.yahoo.com>
<A737B7A37273E048B164557ADEF4A58B17C23CED@ntex2010a.host.magwien.gv.at>
<1380069469.70241.YahooMailNeo@web125005.mail.ne1.yahoo.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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@yahoo.com>
To: Albe Laurenz <laurenz.albe@wien.gv.at>; "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tharagv@yahoo.com, laurenz.albe@wien.gv.at
Subject: Re: connecting to the database from pgadmin client
In-Reply-To: <1380072627.42016.YahooMailNeo@web125006.mail.ne1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox