|
From: Shashwat_Nigam@xxxxxxxxxx To: aroravishal22@xxxxxxxxxxx; pgsql-admin@xxxxxxxxxxxxxx CC: pgsql-general@xxxxxxxxxxxxxx; pgsql-sql@xxxxxxxxxxxxxx; pgsql-admin@xxxxxxxxxxxxxx Date: Thu, 21 Aug 2008 14:55:05 +0530 Subject: Re: [ADMIN] Regarding access to a user Hi Vishal
Ya you are right and the order is same and the command is like that only.
I am opening it through pgAdmin only..
If you are using pgAdmin, you have to keep maintainence db as postgres for which you do not have the entry for that in pg_hba file. I would suggest you to use psql -U <username> command line option to connect.
Thanks & Regards, | Software Engineer | Geographical Information System Satyam Computer Services Limited, Hyderabad | MOBILE: +919951467324 |
From: Vishal Arora [mailto:aroravishal22@xxxxxxxxxxx]
Dear Vishal Thanks for the help but by doing this an error is generated at the time when the user is trying to log in with the following message: “ Access to database denied The server doesn't grant access to the database: the server reports FATAL: no pg_hba.conf entry for host "127.0.0.1", user "hmri", database "postgres", SSL off To access a database on a PostgreSQL server, you first have to grant primary access to the server for your client (Host Based Authentication). PostgreSQL will check the pg_hba.conf file if a pattern that matches your client address / username / database is present and enabled before any SQL GRANT access control lists are evaluated. The initial settings in pg_hba.conf are quite restrictive, in order to avoid unwanted security holes caused by unreviewed but mandatory system settings. You'll probably want to add something like host all all 192.168.0.0/24 md5 This example grants MD5 encrypted password access to all databases to all users on the private network 192.168.0.0/24. You can use the pg_hba.conf editor that is built into pgAdmin III to edit the pg_hba.conf configuration file. After changing pg_hba.conf, you need to trigger a server configuration reload using pg_ctl or by stopping and restarting the server process. “ Please provide futher proceedings Thanks & Regards, | Software Engineer | Geographical Information System Satyam Computer Services Limited, Hyderabad | MOBILE: +919951467324 |
From: Vishal Arora [mailto:aroravishal22@xxxxxxxxxxx]
Search for videos of Bollywood, Hollywood, Mollywood and every other wood, only on Live.com Try it now!
DISCLAIMER: Searching for weekend getaways? Try Live.com Try it! DISCLAIMER: This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. Do you have a You@xxxxxxx id yet? Get it now. Sign up for a Windows Live ID Try it! |
