[11/13] incubator-trafficcontrol git commit: create role because its not there to alter and also need a few more permissions on the postgres role

[da...@apache.org]

create role because its not there to alter and also need a few more permissions on the postgres role


Project: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/commit/ed11e01e
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/tree/ed11e01e
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/diff/ed11e01e

Branch: refs/heads/master
Commit: ed11e01ef7a33f48cb1b4961c79ae724ea5e6592
Parents: 9937a38
Author: Jeremy Mitchell <mi...@gmail.com>
Authored: Thu Apr 13 14:28:55 2017 -0600
Committer: Dan Kirkwood <da...@gmail.com>
Committed: Fri Apr 14 14:22:51 2017 -0600

----------------------------------------------------------------------
 traffic_ops/app/db/admin.pl | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/ed11e01e/traffic_ops/app/db/admin.pl
----------------------------------------------------------------------
diff --git a/traffic_ops/app/db/admin.pl b/traffic_ops/app/db/admin.pl
index e5a0e15..6f78f26 100755
--- a/traffic_ops/app/db/admin.pl
+++ b/traffic_ops/app/db/admin.pl
@@ -43,7 +43,7 @@ my $usage = "\n"
 	. "Create the 'postgres' user (if not created):\n"
 	. "     \$ createuser postgres\n\n"
 	. "Set the 'postgres' user password:\n"
-	. "     ALTER ROLE postgres WITH ENCRYPTED PASSWORD 'yourpassword'; \n\n"
+	. "     CREATE ROLE postgres WITH CREATEROLE LOGIN ENCRYPTED PASSWORD 'yourpassword'; \n\n"
 	. "Postgres Password: file allows for easy command line access by defaulting the user and password for the database\n"
 	. "without prompts.\n\n"
 	. " Postgres .pgpass file format:\n"