Skip to content

Instantly share code, notes, and snippets.

@haydonryan
Created June 7, 2017 17:55
Show Gist options
  • Save haydonryan/389822275d2a96ee6e2cca1842dfa1f8 to your computer and use it in GitHub Desktop.
Save haydonryan/389822275d2a96ee6e2cca1842dfa1f8 to your computer and use it in GitHub Desktop.
sudo su - tempest-web -s /bin/bash -c 'psql tempest_production'
SELECT column_name, data_type
FROM information_schema.columns
WHERE table_name = 'uaa_configs';
SELECT id, hostname
FROM uaa_configs;
UPDATE uaa_configs
SET hostname = '<NEW_HOST_NAME>'
WHERE id = 1;
# bounce UAA (or opsman)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment