I'am wnat to install Askbot, and i need to add a line to the pg_hba.conf file, I prefer to use Postgresql since they suggest to use it. Where is that file resides ? asked 18 Jan '12, 06:04 Hanan Natan |
The pg_hba.conf file is located at the database cluster's data directory. On our newer, CentOS 6 machines, that would be /var/lib/pgsql/9.1/data. But since this is a configuration file for the database that all our customers are using, we restrict access to it. If you want to have a PostgresQL instance that you will be able to configure it to your needs, you can follow the instructions in this answer to compile and run on in your home directory. answered 18 Jan '12, 06:25 iliasr ♦♦ I don't wanna compile. But even with mysql i can't run the command like that: "grant all privileges on dbname.* to dbuser@localhost identified by 'dbpassword'; " - is that mean that I have to compolie ?
(18 Jan '12, 06:35)
Hanan Natan
Regarding MySQL, the way our shared databases are setup, each database has exactly one username (same name as the database) with full privileges. You cannot create additional users within that database. What you can do, is create a new, empty database on your account - this will create a new user. You can then grant that user any privileges you want. This procedure is described in the community post here. As far as compiling PGSQL, what lines do you want to add to pg_hba.conf? They might not be needed.
(18 Jan '12, 07:51)
iliasr ♦♦
|