Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VOdw5-0001D9-Lz for pgsql-admin@arkaria.postgresql.org; Wed, 25 Sep 2013 01:30:37 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VOdw5-0004bc-4z for pgsql-admin@arkaria.postgresql.org; Wed, 25 Sep 2013 01:30:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VOdw4-0004bV-0x for pgsql-admin@postgresql.org; Wed, 25 Sep 2013 01:30:36 +0000 Received: from nm49-vm6.bullet.mail.gq1.yahoo.com ([67.195.87.236]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VOdvy-0004j2-Ps for pgsql-admin@postgresql.org; Wed, 25 Sep 2013 01:30:35 +0000 Received: from [98.137.12.59] by nm49.bullet.mail.gq1.yahoo.com with NNFMP; 25 Sep 2013 01:30:28 -0000 Received: from [98.137.12.222] by tm4.bullet.mail.gq1.yahoo.com with NNFMP; 25 Sep 2013 01:30:28 -0000 Received: from [127.0.0.1] by omp1030.mail.gq1.yahoo.com with NNFMP; 25 Sep 2013 01:30:28 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 248101.8557.bm@omp1030.mail.gq1.yahoo.com Received: (qmail 42822 invoked by uid 60001); 25 Sep 2013 01:30:27 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1380072627; bh=qC46WyNu8m94YpNZ9d1/GabSHHYy90aPuPFcxBj5zBs=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=y/RGOKin8jyLUywCcQOAgIkaGeYZYeCKZCFn3sKvLlGETjx30XTalTxJwYAQy3UQEZsAHvtH5BB1sRzywNMWJOFyWUxdyLehgbSIvI+sGiYZlbrW9LVUlPxnOWc7/eGddkve5D2acmL+DyFZXiAth52dG8y4VyINMHHAVb+Eyh0= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=5JZV6uni8AEYdZ8kqQ27/SI/+rCPu9GKSrr4uZJsA3W8TIFcCAFAiejW77BVfOJWsllAdcSykbBFUW62e1W+dZ+BLMsdfVNKxs2A0KzhnycvdTWDbmRDPmR6kYF8Y4Br+I4RZ3V3c+c6I3f9wXLMDB2RxC6b3olHtiuQF7RZp9Q=; X-YMail-OSG: 29QUAjoVM1nO8jPG3sJy.caBCtiX3ploEA59OtKlZxB9kBd b6sHEnmk2o5TOoUvvA0NHlQF7AX4s2Pnw.ZbsXu3oKn_IVt8gJFUuaIRmwec gD5p5TEkbA5dGBJlu4xUO9TuHooJ4IltznyW8t.J8s9cBdtfDwX48QuwQSwX I_om97gH8upNU0ccsprrwKlV__luoUmL45TAWBKCElqJEPTHTANE.X52FZHD VvNWFLPZFFANEwj6erNJnoTjRXFFNhruNiLkR5OZ6WWlAPKjl4SEX3HuyKG4 9JnZJrtZfGhTxGaxBNp.wN8PGc.E6vfyyTtw1KH_8Rua1jZPBJen4qhSi_T. XhM7g60Q3ow_V1xW9I9gOUG.nuqQz4uSyKxP22vcQyK5veI.bHQGmYJlqh_7 x59uSyqkmQb01wahWm_NJg3dzwxnOJjXfPEF_c9.6UsmHPDaoDO0cv_5HHwd iS848Lfiob0dyyISd8pmMCM6n6W3y.9C4MX_4lX3CX81ojb8OLMazlv6WVu9 mHNDB7Da9ZvellfPzRGX1dJtNE6RVr1db0Vj9VQwdnRGTt.8Jr01lN1egPH5 w9tpniO2i43iisL9Ypxhm0LJBnrNGaGY- Received: from [50.241.80.25] by web125006.mail.ne1.yahoo.com via HTTP; Tue, 24 Sep 2013 18:30:27 PDT X-Rocket-MIMEInfo: 002.001, SSBuZWVkIHRvIGNyZWF0ZSBhIGRhdGFiYXNlIGFuZCBhIHVzZXIgYW5kIG1ha2UgdGhpcyBuZXcgdXNlciB0aGUgb3duZXIgb2YgdGhpcyBuZXcgZGF0YWJhc2UuClNpbmNlIEkgY2Fubm90IGFjY2VzcyBwb3N0Z3JlcyBkYiBmcm9tIHBnYWRtaW4gY2xpZW50IG9uIG15IGRlc2t0b3AsIArCoApJIHRyaWVkIHRvIGRvIHRoZSBzYW1lIGZyb20gdGhlIGNvbW1hbmQgbGluZSBvbiB0aGUgbGludXggZGIgc2VydmVyOgrCoApzdSAtIHBvc3RncmVzCi1iYXNoLTQuMSQgcHNxbCAtZCBwb3N0Z3JlcwoKcG9zdGdyZXMBMAEBAQE- X-Mailer: YahooMailWebService/0.8.157.561 References: <48F1E182B1021B449414C85E713CE8250E61E0@WLT-MBX03.KRONOS.com> <1379975782.27726.YahooMailNeo@web125005.mail.ne1.yahoo.com> <1380030420.19939.YahooMailNeo@web125003.mail.ne1.yahoo.com> <1380030784.27416.YahooMailNeo@web125003.mail.ne1.yahoo.com> <1380031785.83405.YahooMailNeo@web125005.mail.ne1.yahoo.com> <1380069469.70241.YahooMailNeo@web125005.mail.ne1.yahoo.com> Message-ID: <1380072627.42016.YahooMailNeo@web125006.mail.ne1.yahoo.com> Date: Tue, 24 Sep 2013 18:30:27 -0700 (PDT) From: Thara Vadakkeveedu Reply-To: Thara Vadakkeveedu Subject: Re: connecting to the database from pgadmin client To: Albe Laurenz , "pgsql-admin@postgresql.org" In-Reply-To: <1380069469.70241.YahooMailNeo@web125005.mail.ne1.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-1430280533-720090758-1380072627=:42016" X-Pg-Spam-Score: -4.3 (----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org ---1430280533-720090758-1380072627=:42016 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable I need to create a database and a user and make this new user the owner of = this new database.=0ASince I cannot access postgres db from pgadmin client = on my desktop, =0A=A0=0AI tried to do the same from the command line on the= linux db server:=0A=A0=0Asu - postgres=0A-bash-4.1$ psql -d postgres=0A=0A= postgres=3D#=A0 create user puser password 'xxxxxx'=0A=0Apostgres=3D#=A0 cr= eate database pfdb owner puser=0A=A0=0AIf I now try to list databases using= \l=0Ait lists postgres, template0 and template1 but not the new database I= created...=0A=A0=0AHow can I create a new database successfully ? It will = be=A0easier for me to=A0try=A0this from the pgadmin client. =0AThanks=0ATG= =0A=0A________________________________=0AFrom: Thara Vadakkeveedu =0ATo: Albe Laurenz ; "pgsql-admin@postg= resql.org" =0ASent: Tuesday, September 24, 201= 3 8:37 PM=0ASubject: connecting to the database from pgadmin client=0A=0A= =0A=0A=0A=0AHi=0AI am trying to connect to the database on a linux server f= rom pgadmin on my windows desktop.=0AI=A0see "Error connecting to the serve= r: Fatal: password authentication=A0failed for user "postgres"=0A=0AI speci= fied=A0my linux server name for the host=0Aport : 5432=0AMaintenance DB : p= ostgres=0Ausername:postgres=0Apassowrd: a passwod=A0I set (using alter user= postgres password command. I changed password as user postgres)=0A=A0=0AHo= w can I connect to the postgres database ?=0Athanks,=0Athara. ---1430280533-720090758-1380072627=:42016 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
I need to create a database and a user an= d make this new user the owner of this new database.
Since I cannot access postgre= s db from pgadmin client on my desktop,
 
I tried to do the sa= me from the command line on the linux db server:
 
su - postgres=
-bash-4.1$ psql -d p= ostgres

postgres=3D#  create user puser password 'xxxxxx= '

postgres=3D#  cre= ate database pfdb owner puser
 
If I now try to list databases using \l
it lists postgres, template0 and template1 but n= ot the new database I created...
 
How can I create a new database successfully ? I= t will be easier for me to try this from the pgadmin client.=
Thanks
TG
From: Thara Vadakkeveedu <tharagv@yaho= o.com>
To: Albe Laure= nz <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 authentica= tion 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 com= mand. I changed password as user postgres)
 
How can I connect to the postgres database ?
thanks,
thara.


<= /html> ---1430280533-720090758-1380072627=:42016--