Hide Forgot
Title: Configuring PostgreSQL Describe the issue: Command in Step 2 (service postgresql initdb) does not work with systemctl Output is: "The service command supports only basic LSB actions (start, stop, restart, try-restart, reload, force-reload, status). For other actions, please try to use systemctl." Suggestions for improvement: Add command options for systemctl Additional information: This is similar to changes made in Step 3 to include command for systemctl
Was able to initialize database with: pg_ctl initdb -D ~/path/to/location
Had to initialize db again as 'postgres' user. Started database server with: /usr/bin/postgres -D /var/lib/pgsql/pgdb
Step 4: Cannot set a password for postgres user in psql. System attempts to use normal user home directory. Log in as postgres user: su postgres Password: Invoke psql: bash-4.3$ psql could not change directory to "/home/smumford": Permission denied psql (9.4.7) Doc needs more information and/or clearer instructions regarding different users
OK, it appears I had an unusable parameter ("max_fsm_pages") in my 'var/lib/pgsql/data/postgresql.conf' file. Commented out and was able to start postgresql service with: $ sudo systemctl start postgresql.service Then able to switch to postgres user and invoke psql utility with: $ sudo -u postgres -i $ psql
Unable to successfully start JON 3.3 due to 'Cannot obtain client connection to the RHQ app server!!' error and recurring 'FATAL: Ident authentication failed for user' errors. "Cannot obtain client connection..." error is discussed in [1] however proposed solution did not help. 1: https://access.redhat.com/solutions/678553
2.1.1 step 3 sudo systemctl enable postgresql-<version>.service sudo systemctl start postgresql-<version>.service where <version> = <major>.<minor> For Example: systemctl enable postgresql-8.4.service Source: https://wiki.postgresql.org/wiki/YUM_Installation
Changes merged: https://gitlab.cee.redhat.com/red-hat-jboss-operations-network-documentation/doc-jon-docs/merge_requests/3 Currently on patheon (preview): https://access.qa.redhat.com/documentation/en-us/red_hat_jboss_operations_network/3.3/html-single/installation_guide/#Database-Postgres_Preparation
Revised to improve formatting and ensure procedures worked in a variety of situations: Sections 2.1 and 2.1.1: https://access.qa.redhat.com/documentation/en-us/red_hat_jboss_operations_network/3.3/html-single/installation_guide/#Database-Postgres_Preparation Merged: https://gitlab.cee.redhat.com/red-hat-jboss-operations-network-documentation/doc-jon-docs/merge_requests/4 Note: this merge request also includes changes for https://bugzilla.redhat.com/show_bug.cgi?id=1458981 Now includes instructions for RHEL 6 and earlier, RHEL 7 and Later and RHEL 7 using Downloaded binaries from postgresql. Third type of install included as current version of postgresql is not supported by JON https://access.redhat.com/articles/112523.
2 issues: 1) - 2.1.2 Step2 - Initialize the PostgreSQL database. For installs using downloaded binaries on Red Hat Enterprise Linux 7 (and later): sudo service postgresql-<version> initdb this will not work on RHEL 7, should be: /usr/pgsql-y.x/bin/postgresqlyx-setup initdb 2) 2.1.2 Step 3 - Start the PostgreSQL service Update following step to contain 'chkconfig postgresql on' as well. It could look like this: On Red Hat Enterprise Linux 6 (and earlier) using repository install: sudo service postgresql start chkconfig postgresql on Changes suggested according to - https://wiki.postgresql.org/wiki/YUM_Installation
changed 2.1.2 Step 2: Made changes indicated in comment 9, also added RHEL6 downloaded binaries commands (was unable to test on RHEL 6 previously). Git Commit: https://gitlab.cee.redhat.com/tkelly/doc-jon-docs/commit/3bc7e2c43aff3e01a949acf5668b340ce1a3b148 Git merge: https://gitlab.cee.redhat.com/red-hat-jboss-operations-network-documentation/doc-jon-docs/merge_requests/20 Pantheon Preview: https://access.qa.redhat.com/documentation/en-us/red_hat_jboss_operations_network/3.3/html-single/installation_guide/#Database-PostgreSQL_Quick_Start_Installation
Published on customer portal on 2017-06-26