Fedora Add exclude to /etc//fedora.repo file section: Īdd exclude to /etc//fedora-updates.repo file section: ĬentOS Add exclude to /etc//CentOS-Base.repo file and sections: Exclude PostgreSQL packages from the repository of the distro. Install PostgreSQL 9.2.1 Database Server on Fedora, CentOS/RHELĮxclude Fedora, CentOS, RHEL own PostgreSQL Packages This is important step to get PostgreSQL repository working properly. Note: If you are upgrading PostgresSQL (from earlier version), then make sure that you backup (dump and copy) your database and configs. This guide uses PostgreSQL own YUM repos, which are always up-to-date and stable releases are available instantly. Needs to be researched further.Ĩ.This is guide, howto install PostgreSQL 9.2 database server on Fedora, CentOS/RHEL. But not sure if this solved the problem because GRANT ALL PRIVILEGES should have taken care of it. The last one was important because I wasn’t able to connect to the database. >GRANT ALL PRIVILEGES ON DATABASE masterdb TO automation >CREATE ROLE automation WITH PASSWORD 'UserPassword' Create user role (with same password as shell) and new database Login as postgres and connect to database. Create local user and set user passwordħ. Then replace “ident” with “md5”, so they look like this:Ħ. Modify the pg_hba.conf file located under /var/lib/pgsql/data/. Yum install postgresql-server postgresql-contribĥ. # Validate installation and version by executing php -info # update will update every currently installed package Thought it will be useful to list down the steps to install PHP and Postgres and get it to work together.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |