Yedidyah Bar David has uploaded a new change for review. Change subject: packaging: engine-backup.sh output db creation info ......................................................................
packaging: engine-backup.sh output db creation info Add to '--help' instructions for creating a database and making it accessible. Change-Id: I212bfdd3b362880faa7aee159866d928de83d6f3 Bug-Url: https://bugzilla.redhat.com/1002401 Signed-off-by: Yedidyah Bar David <d...@redhat.com> --- M packaging/bin/engine-backup.sh 1 file changed, 23 insertions(+), 0 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/45/20445/1 diff --git a/packaging/bin/engine-backup.sh b/packaging/bin/engine-backup.sh index 5b4b3b2..9f2dda3 100755 --- a/packaging/bin/engine-backup.sh +++ b/packaging/bin/engine-backup.sh @@ -67,6 +67,29 @@ --db-name=name set database name --db-secured set a secured connection --db-secured-validation validate host + + To create a new user/database: + + create user <user> password '<password>'; + create database <database> owner <user> template template0 + encoding 'UTF8' lc_collate 'en_US.UTF-8 lc_ctype 'en_US.UTF-8'; + + Open access in the firewall/iptables/etc. to the postgresql port, + 5432/tcp by default. + + Locate pg_hba.conf within your distribution, + common locations are: + - /var/lib/pgsql/data/pg_hba.conf + - /etc/postgresql-*/pg_hba.conf + - /etc/postgresql/*/main/pg_hba.conf + + and open access there by adding the following lines: + + host <database> <user> 0.0.0.0/0 md5 + host <database> <user> ::0/0 md5 + + Replace <user>, <password>, <database> with appropriate values. + __EOF__ return 0 } -- To view, visit http://gerrit.ovirt.org/20445 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I212bfdd3b362880faa7aee159866d928de83d6f3 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: ovirt-engine-3.3 Gerrit-Owner: Yedidyah Bar David <d...@redhat.com> _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches
