Start PostgreSQL Server and Autostart PostgreSQL on BootĬhkconfig -levels 235 postgresql-9.HyperSnap 9 Free Download Latest Version for Windows. You can find more examples and full guide from PostgreSQL pg_hba.conf manual. Modify PostgreSQL /var/lib/pgsql/9.2/data/pg_hba.conf (host-based authentication) file: # Local networks Port = 5432 Or if you want use specific ip, then use following: listen_addresses = '192.168.1.33' If you want just localhost setup, then use following: listen_addresses = 'localhost' Open /var/lib/pgsql/9.2/data/nf file, and add/uncomment/modify following: listen_addresses = '*' Here is multiple alternatives howto do this (like service postgresql-9.x initdb, /etc/init.d/postgresql-9.x initdb) and postgresql-setup initdb, so that’s why I use here universal PostgreSQL initdb method, which should work with Fedora, CentOS/RHEL: su - postgres -c /usr/pgsql-9.2/bin/initdb Set PostgreSQL Server to Listen Addresses and Set Port Rpm -Uvh Install PostgreSQL 9.2 with YUM yum install postgresql92 postgresql92-server postgresql92-contrib Configure PostgreSQL 9.2 Initialize Cluster with initdb Command # Red Hat Enterprise Linux 5 - x86_64 - 64-bit # # Red Hat Enterprise Linux 5 - i386 - 32-bit # # Red Hat Enterprise Linux 6 - x86_64 - 64-bit # Red Hat (RHEL) # Red Hat Enterprise Linux 6 - i386 - 32-bit # Exclude PostgreSQL packages from the repository of the distro.Īdd exclude to /etc//fedora.repo file section: Īdd exclude to /etc//fedora-updates.repo file section: Īdd exclude to /etc//CentOS-Base.repo file and sections: Īdd exclude to /etc/yum/pluginconf.d/nf file section: Įxclude=postgresql* Install PostgreSQL 9.2 Repository This is important step to get PostgreSQL repository working properly. Install PostgreSQL 9.2.1 Database Server on Fedora, CentOS/RHELĮxclude Fedora, CentOS, RHEL own PostgreSQL Packages 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. This is guide, howto install PostgreSQL 9.2 database server on Fedora, CentOS/RHEL.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |