Drupal 2 Pgpass - Convert Drupal 6 pgsql db_url to .pgpass format and set permissions

I needed to automagically connect to the database of some drupal 6 instances, so I wrote this script to convert the settings.php [1] $db_url [2] into the ~/.pgpass [3] file, remember to also set the apropriate permissions (0600) and also be sure to own the file, otherwise it won't work.

Related resources

1. https://api.drupal.org/api/drupal/sites!default!default.settings.php/6
2. https://api.drupal.org/api/drupal/developer!globals.php/global/db_url/6
3. https://wiki.postgresql.org/wiki/Pgpass

--
= ^ . ^ =