Github user MattMills commented on a diff in the pull request:
https://github.com/apache/incubator-trafficcontrol/pull/344#discussion_r106281138
--- Diff: traffic_ops/INSTALL.md ---
@@ -8,53 +8,71 @@
Instructions are here: https://yum.postgresql.org/
- grab the link for CentOS 7 and install:
- $ sudo yum install
https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-xxxx.noarch.rpm
+ $ sudo yum install
https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-xxxx.noarch.rpm
+
+ NOTE: get a valid link from https://yum.postgresql.org/ with the correct
version number.
+
- install `postgresql96` (for psql commands) and `postgresql96-devel` (for
includes/libraries needed to install `DBD::Pg` perl library)
+
$ sudo yum install postgresql96 postgresql96-devel
## Install Postgres 9.6 server (in a container or on the host)
### on the host:
+
$ sudo yum install postgresql96-server
### -or- in a container
NOTE: you do *not* need postgresql96-server if running postgres within a
`docker` container.
Install `docker` and `docker-compose` using instructions here:
+
https://docs.docker.com/engine/installation/linux/centos/
+
https://docs.docker.com/compose/install/
Add yourself to `docker` group
+
$ sudo usermod -G docker $USER
Remember to logout and login again.. You should see `docker` in your
list of groups:
$ id
uid=9876(myuser) gid=9876(myuser) groups=9876(myuser),990(docker) ...
+Edit `mysql-to-postgres.env` to suit your needs.
+* modify `POSTGRES_*` vars to apply to new postgres container that will
house your database, e.g.
+ * POSTGRES_USER=postgres
+ * POSTGRES_PASSWORD=itSas3cre4
+
+If migrating from an existing pre-2.0 traffic_ops server (mysql):
+* `TO_*` vars for admin access to existing mysql-based `traffic_ops` (to
get a db dump), e.g.
+ * TO_SERVER=https://trafficops.example.com
+ * TO_USER=dennisr
+
+* `MYSQL_*` vars to apply to temporary mysql container -- really no need
to change..
+
Start a docker container to run postgres
+
$ cd incubator-trafficcontrol/traffic_ops/app/db/pg-migration
$ ./start_postgres.sh
-Edit `mysql-to-postgres.yml` to suit your needs.
-- modify `POSTGRES_*` vars to apply to new postgres container that will
house
-
-If migrating from an existing pre-2.0 traffic_ops server (mysql):
-- `TO_*` vars for admin access to existing mysql-based `traffic_ops` (to
get a db dump)
-- `MYSQL_*` vars to apply to temporary mysql container
-
Run migration from existing mysql-based `traffic_ops`
+
$ ./migrate.sh
## Install `traffic_ops`
+
$ sudo yum install traffic_ops
--- End diff --
This won't work outside of Comcast
---
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 [email protected] or file a JIRA ticket
with INFRA.
---
