Re: [ADMIN] connecting to the database from pgadmin client

2013-09-26 Thread Albe Laurenz
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 > -bas

Re: [ADMIN] connecting to the database from pgadmin client

2013-09-24 Thread Thara Vadakkeveedu
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

[ADMIN] connecting to the database from pgadmin client

2013-09-24 Thread Thara Vadakkeveedu
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