Fix database server name for users-agreed script

diff --git a/cookbooks/planet/files/default/replication-bin/users-agreed b/cookbooks/planet/files/default/replication-bin/users-agreed
index 1aa0c1b6ec60f300f1964efd056c6d2505f89ee4..427910c0583dfba8d2cffc8a0c9b1daa76841c81 100644 (file)
--- a/cookbooks/planet/files/default/replication-bin/users-agreed
+++ b/cookbooks/planet/files/default/replication-bin/users-agreed
@@ -8,9 +8,9 @@ export PGPASSFILE=/etc/replication/users-agreed.conf
 
 echo "# user IDs < 286582 who have agreed to the contributor terms. " > $T/users_agreed
 echo "# any active user IDs >= 286582 would have agreed as part of the sign-up process." >> $T/users_agreed
-psql -h db -U planetdiff -t -c "select id from users where id < 286582 and terms_agreed is not null order by id asc" openstreetmap >> $T/users_agreed
+psql -h ramoth.ic.openstreetmap.org -U planetdiff -t -c "select id from users where id < 286582 and terms_agreed is not null order by id asc" openstreetmap >> $T/users_agreed
 
-psql -h db -U planetdiff -t -c "select id from users where terms_seen and terms_agreed is null order by id asc" openstreetmap > $T/users_disagreed
+psql -h ramoth.ic.openstreetmap.org -U planetdiff -t -c "select id from users where terms_seen and terms_agreed is null order by id asc" openstreetmap > $T/users_disagreed
 
 if cmp -s "${T}/users_agreed" "/store/planet/users_agreed/users_agreed.txt"; then
   : # do nothing

diff --git a/cookbooks/planet/templates/default/users-agreed.conf.erb b/cookbooks/planet/templates/default/users-agreed.conf.erb
index c6dd2fffa4741d3da05580087e37e587a4f5e3dc..1f2e3c36c0b71ac2b50496b5cd533fe60c4fa539 100644 (file)
--- a/cookbooks/planet/templates/default/users-agreed.conf.erb
+++ b/cookbooks/planet/templates/default/users-agreed.conf.erb
@@ -1,3 +1,3 @@
 # DO NOT EDIT - This file is being maintained by Chef
 
-db:5432:openstreetmap:planetdiff:<%= @password %>
+ramoth.ic.openstreetmap.org:5432:openstreetmap:planetdiff:<%= @password %>