I see. I have pgAdmin III on my local system and have been able to create database and tables through it. I hope this is fine?
Thanks once again; though I am sure I'll be back with some query for you and the community.[?] On Thu, Mar 4, 2010 at 1:54 PM, Iñigo Martinez Lasala < [email protected]> wrote: > dbadmin is a database user, not a Linux user. > You cannot use dbadmin in order to get logged to your machine. Only to > access database. > > Why are you using dbadmin to login to unix? Use root. > > Configure your web app using your root user to login to postgresql with > dbadmin. You will have to modify a config file somewhere in the path of this > app. Read INSTALL or README files of your web app. > > Use phppgadmin as alternative. It's also free and it will be probably at > RedHat/CentOS repos. "yum install phppgadmin" or "up2date install > phppgadmin" > Or webmin if you want to admin all server without having to use command > line. http://www.webmin.com/ > > > > > -----Original Message----- > From: Major Services <[email protected]> > To: Iñigo Martinez Lasala <[email protected]> > Cc: [email protected] > Subject: Re: [ADMIN] password authentication failed for user postgres > Date: Wed, 3 Mar 2010 23:40:39 +0530 > > When I try to login as dbadmin through shell, I get 'access denied'. > > What could be wrong? > > On Wed, Mar 3, 2010 at 10:49 PM, Iñigo Martinez Lasala > <[email protected]> wrote: >> OK, it's a web app installed locally... >> >> Modify config file for this app (I don't know about it, so you will have >> to >> search by yourserlf) and point to 127.0.0.1 instead of use unix sockets, >> and >> also change use postgres for user dbadmin. >> >> Or modify your pg_hba.conf like this >> local all postgres trust >> >> I don't suggest to revert to "local all postgres password" since you will >> have to enter password for any local operation in your server, but anyway, >> it's your decision. >> >> -----Original Message----- >> From: Major Services <[email protected]> >> To: Iñigo Martinez Lasala <[email protected]> >> Cc: [email protected] >> Subject: Re: [ADMIN] password authentication failed for user postgres >> Date: Wed, 3 Mar 2010 22:41:47 +0530 >> >> Thanks. >> I already have created a user. >> And can connect to the server through the PgAdmin on my local system. >> >> My query now is : >> Now when I try to connect to the server through DBWebAdmin (in >> Parallels Plesk Panel); I get the following : >> Error: FATAL: Ident authentication failed for user "postgres" >> >> (earlier, with this link I could reach the login screen for PgAdmin ) >> >> Do I need to remove the following from pg_hba.conf now? >> local all postgres ident sameuser >> >> Thanks for all your help & support. >> >> >> >> On Wed, Mar 3, 2010 at 8:56 PM, Iñigo Martinez Lasala >> <[email protected]> wrote: >>> Great. You managed to start server. :-) >>> >>> You are using user postgres and you shoudn't use it.I suggest you to >>> create >>> your own dbadmin... >>> >>> In your linux box, as root user: >>> >>> su - postgres >>> createuser -s dbadmin -P >>> >>> You will create a new user called dbadmin. It will ask you for a password >>> for this user and some extra options. Response YES to all. >>> >>> Now you can connect remotely with this dbadmin user. >>> >>> >>> >>> -----Original Message----- >>> From: Major Services <[email protected]> >>> To: Iñigo Martinez Lasala <[email protected]> >>> Cc: [email protected] >>> Subject: Re: [ADMIN] password authentication failed for user postgres >>> Date: Wed, 3 Mar 2010 20:07:23 +0530 >>> >>> >>> Finally, I am able to create a user. >>> >>> Now when I try to connect to the server through DBWebAdmin (in >>> Parallels Plesk Panel); I get the following : >>> Error: FATAL: Ident authentication failed for user "postgres" >>> >>> (earlier, with this link I could reach the login screen for PgAdmin ) >>> >>> Do I need to remove the following from pg_hba.conf now? >>> local all postgres ident sameuser >>> >>> >>> >>> >>> >>> On Tue, Mar 2, 2010 at 2:44 PM, Iñigo Martinez Lasala >>> <[email protected]> wrote: >>>> In order to lauch createuser you don't need to modify listen_address >>>> since >>>> you can use unix sockets. But anyway it's a requirement if you are goint >>>> to >>>> access remotely. >>>> >>>> Add this line in first place to your pg_hba.conf >>>> local all postgres ident sameuser >>>> >>>> >>>> Reload postgresql and launch createuser as postgres user. >>>> >>>> >>>> -----Original Message----- >>>> From: Major Services <[email protected]> >>>> To: [email protected] >>>> Subject: [ADMIN] password authentication failed for user postgres >>>> Date: Tue, 2 Mar 2010 14:13:10 +0530 >>>> >>>> Hi, >>>> >>>> 1. I have added listen_addresses = '*' ; in postgresql.conf >>>> >>>> 2. And have made the following changes to pg_hba.conf >>>> >>>> local DATABASE USER METHOD >>>> local samegroup all password >>>> host DATABASE USER CIDR-ADDRESS METHOD [OPTION] >>>> >>> >>>> hostssl all all 0.0.0.0/0 md5 >>>> >>>> 3. Have restarted the server >>>> >>>> 4. I can login to the server as user postgres. >>>> >>>> But while trying to createuser I get the following message : >>>> 'createuser: could not connect to database postgres: FATAL : >>>> password authentication failed for user "postgres" >>>> >>>> This is on Redhat running Plesk also. >>>> >>>> I am new to Linux as well as PostgreSQL. Help would be much appreciated. >>>> >>>> Thanks >>>> Viv >>>> >>>> >>>> >>> >>> >> >> > >
<<330.gif>>
