[GitHub] incubator-trafficcontrol pull request #467: [BACKPORT TC-233] Modified admin...

[dangogh <gi...@git.apache.org>]

Github user dangogh commented on a diff in the pull request:

    https://github.com/apache/incubator-trafficcontrol/pull/467#discussion_r111583751
  
    --- Diff: traffic_ops/app/db/admin.pl ---
    @@ -29,23 +29,44 @@
     use YAML qw(LoadFile);
     use DBIx::Class::Schema::Loader qw/make_schema_at/;
     
    +use Env;
    +use Env qw(HOME);
    +
     my $usage = "\n"
     	. "Usage:  $PROGRAM_NAME [--env (development|test|production|integration)] [arguments]\t\n\n"
     	. "Example:  $PROGRAM_NAME --env=test reset\n\n"
     	. "Purpose:  This script is used to manage database. The environments are\n"
     	. "          defined in the dbconf.yml, as well as the database names.\n\n"
    -	. "arguments:   \n\n"
    +	. "NOTE: \n"
    +	. "Postgres Superuser: The 'postgres' superuser needs to be created to run $PROGRAM_NAME and setup databases.\n"
    +	. "If the 'postgres' superuser has not been created or password has not been set then run the following commands accordingly. \n\n"
    +	. "Create the 'postgres' user as a super user (if not created):\n\n"
    +	. "     \$ createuser postgres --superuser --createrole --createdb --login --pwprompt\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"
    --- End diff --
    
    didn't understand previous 2 lines until I saw mention of .pgpass below.   That probably should be more clear


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---