Send an Email
1800 810 6547
All Entries Tagged With: "PostgreSQL"
Configure Sphinx in Rails application
Install Sphinx Just run the following three commands on your server or dev machine to install Sphinx: ./configure make sudo make install That will setup Sphinx with default for use with MySQL. If you want to use it with PostgreSQL, then run configure with the following flag: ./configure –with-pgsql Note: you can download the sphinx [...]
Postgres databases not showing up in cPanel
Issue : Postgres databases do not show up in cPanel. Fix : Go to /var/lib/pgsql/data/pg_hba.conf Change ‘md5′ to ‘trust’. It should look like : local all all trust host all all 127.0.0.1 255.255.255.255 trust Try accessing cPanel now. The databases should show up!
Authentication failure in PostgreSQL
If you are seeing the following error in the cPanel error log (/usr/local/cpanel/logs/error_log) while creating a postgreSQL database from cPanel, you need to reset the password of postgres user from WHM >> SQL Services >> Postgres Config as given in the file /var/lib/pgsql/.pgpass psql: FATAL: password authentication failed for user “postgres” And the error – [...]
