# odd result after migrating postgresql database off-tower **URL:** \ **Category:** Ansible Project\ **Tags:** ubuntu, awx\ **Created:** [November 15, 2016, 6:13pm UTC](https://forum.ansible.com/t/odd-result-after-migrating-postgresql-database-off-tower/23033 "2016-11-15T18:13:50Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Stuart\_Cracraft](https://avatars.discourse-cdn.com/v4/letter/s/d6d6ee/32.png) [@Stuart\_Cracraft](https://forum.ansible.com/u/Stuart_Cracraft)\ **Post date:** [November 15, 2016, 6:13pm UTC](https://forum.ansible.com/t/odd-result-after-migrating-postgresql-database-off-tower/23033/1 "2016-11-15T18:13:50Z")
Getting a bizarre result after migrating postgresql database off-tower using jsmartin’s script. The gui no longer logs in. Shows username where admin/password are entered but then it goes to “Working…” After a very long pause, it reverts to a blanks screen with Tower/Projects/Inventories/Job Templates/Jobs across the top but nothing in the client area. None of the controls in the bar across the top work. supervisorctl status awx-callback-receiver RUNNING pid 5214, uptime 0:04:28 awx-celeryd RUNNING pid 5204, uptime 0:04:29 awx-fact-cache-receiver RUNNING pid 5172, uptime 0:04:31 awx-socketio-service RUNNING pid 5171, uptime 0:04:31 awx-task-system RUNNING pid 5189, uptime 0:04:30 ansible-tower-service status Showing Tower Status - apache2 is running redis-server is running is running Redis log looks ok: tail -10 /var/log/redis/redis-server.log [1647] 15 Nov 18:04:09.012 \* 10 changes in 300 seconds. Saving… [1647] 15 Nov 18:04:09.013 \* Background saving started by pid 6290 [6290] 15 Nov 18:04:09.016 \* DB saved on disk [6290] 15 Nov 18:04:09.016 \* RDB: 4 MB of memory used by copy-on-write [1647] 15 Nov 18:04:09.113 \* Background saving terminated with success [1647] 15 Nov 18:09:10.063 \* 10 changes in 300 seconds. Saving… [1647] 15 Nov 18:09:10.064 \* Background saving started by pid 7096 [7096] 15 Nov 18:09:10.066 \* DB saved on disk [7096] 15 Nov 18:09:10.066 \* RDB: 4 MB of memory used by copy-on-write [1647] 15 Nov 18:09:10.164 \* Background saving terminated with success Able to connect to port 5432 on the remote server which shows: netstat -plunt | grep 5432 tcp 0 0 0.0.0.0:5432 0.0.0.0:\* LISTEN 43939/postgres tcp6 0 0 :::5432 :::\* LISTEN 43939/postgres Apache error log doesn’t show anything: tail -10 /var/log/apache2/error.log [Tue Nov 15 18:00:40.895081 2016] [core:warn] [pid 2303:tid 140370545932160] AH00045: child process 2311 still did not exit, sending a SIGTERM [Tue Nov 15 18:00:42.897368 2016] [core:error] [pid 2303:tid 140370545932160] AH00046: child process 2310 still did not exit, sending a SIGKILL [Tue Nov 15 18:00:42.898396 2016] [core:error] [pid 2303:tid 140370545932160] AH00046: child process 2311 still did not exit, sending a SIGKILL [Tue Nov 15 18:00:43.899660 2016] [mpm\_event:notice] [pid 2303:tid 140370545932160] AH00491: caught SIGTERM, shutting down [Tue Nov 15 18:00:47.629592 2016] [ssl:warn] [pid 5605:tid 140170835982208] AH01906: RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?) [Tue Nov 15 18:00:47.629645 2016] [ssl:warn] [pid 5605:tid 140170835982208] AH01909: RSA certificate configured for localhost:443 does NOT include an ID which matches the server name [Tue Nov 15 18:00:47.637504 2016] [ssl:warn] [pid 5606:tid 140170835982208] AH01906: RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?) [Tue Nov 15 18:00:47.637522 2016] [ssl:warn] [pid 5606:tid 140170835982208] AH01909: RSA certificate configured for localhost:443 does NOT include an ID which matches the server name [Tue Nov 15 18:00:47.639120 2016] [mpm\_event:notice] [pid 5606:tid 140170835982208] AH00489: Apache/2.4.7 (Ubuntu) OpenSSL/1.0.1f mod\_wsgi/3.4 Python/2.7.6 configured – resuming normal operations [Tue Nov 15 18:00:47.639148 2016] [core:notice] [pid 5606:tid 140170835982208] AH00094: Command line: ‘/usr/sbin/apache2’ ---
**Author:** ![James\_Martin](https://avatars.discourse-cdn.com/v4/letter/j/f14d63/32.png) [@James\_Martin](https://forum.ansible.com/u/James_Martin)\ **Post date:** [November 15, 2016, 6:38pm UTC](https://forum.ansible.com/t/odd-result-after-migrating-postgresql-database-off-tower/23033/2 "2016-11-15T18:38:25Z")
I could only assume you are referring to this 2 year old script I wrote: [https://github.com/jsmartin/ansible-tower-db-migrator](https://github.com/jsmartin/ansible-tower-db-migrator). That was created long before Ansibe Tower had a proper backup restore mechanism. I suggest you contact Ansible support and use the official method. ---
**Author:** ![Stuart\_Cracraft1](https://avatars.discourse-cdn.com/v4/letter/s/2bfe46/32.png) [@Stuart\_Cracraft1](https://forum.ansible.com/u/Stuart_Cracraft1)\ **Post date:** [November 15, 2016, 6:39pm UTC](https://forum.ansible.com/t/odd-result-after-migrating-postgresql-database-off-tower/23033/3 "2016-11-15T18:39:47Z")
Exactly my plan. Thanks!