pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedconnecting to the database from pgadmin client
3+ messages / 2 participants
[nested] [flat]
* connecting to the database from pgadmin client
@ 2013-09-25 00:37 Thara Vadakkeveedu <tharagv@yahoo.com>
0 siblings, 1 reply; 3+ messages in thread
From: Thara Vadakkeveedu @ 2013-09-25 00:37 UTC (permalink / raw)
To: Albe Laurenz <laurenz.albe@wien.gv.at>; pgsql-admin
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: connecting to the database from pgadmin client
@ 2013-09-25 01:30 Thara Vadakkeveedu <tharagv@yahoo.com>
parent: Thara Vadakkeveedu <tharagv@yahoo.com>
0 siblings, 1 reply; 3+ messages in thread
From: Thara Vadakkeveedu @ 2013-09-25 01:30 UTC (permalink / raw)
To: Albe Laurenz <laurenz.albe@wien.gv.at>; pgsql-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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: connecting to the database from pgadmin client
@ 2013-09-26 12:12 Albe Laurenz <laurenz.albe@wien.gv.at>
parent: Thara Vadakkeveedu <tharagv@yahoo.com>
0 siblings, 0 replies; 3+ messages in thread
From: Albe Laurenz @ 2013-09-26 12:12 UTC (permalink / raw)
To: Thara Vadakkeveedu <tharagv@yahoo.com>; pgsql-admin
Thara Vadakkeveedu wrote:
> 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.
... but it is better with psql first because that is simpler.
I see that there are no semicolons at the end of your statements.
That would mean that the statements don't get executed at all.
Is this just a copy/paste error?
Could you copy the complete session (what exactly you typed and
what response you got)?
Yours,
Laurenz Albe
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2013-09-26 12:12 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-09-25 00:37 connecting to the database from pgadmin client Thara Vadakkeveedu <tharagv@yahoo.com>
2013-09-25 01:30 ` Thara Vadakkeveedu <tharagv@yahoo.com>
2013-09-26 12:12 ` Albe Laurenz <laurenz.albe@wien.gv.at>
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