1. PostgreSQL Configuration
   • Database Adapter: The app uses PostgreSQL as the database, specified in config/database.yml under the adapter key.
   • Development and Test Databases:
     • finance_tracker_development (for development).
     • finance_tracker_test (for testing).
   • Role Used: The database is configured to use the finance_tracker role.

Relevant Configurations (from config/database.yml):

development:
  <<: *default
  database: finance_tracker_development
  username: finance_tracker
  password:

test:
  <<: *default
  database: finance_tracker_test
  username: finance_tracker
  password:

1. Role Creation and Database Initialization

   The finance_tracker role and databases were created as follows:

   • Check for Existing Roles:

     psql postgres -c "\\du"
     

     This lists all existing roles in the PostgreSQL server.

   • Create the Role:

     createuser -s -r -d finance_tracker
     

     • s: Grants superuser privileges.
     • r: Makes the role a login role (able to connect to databases).
     • d: Allows the role to create databases.

   • Create the Databases: Run the Rails command:

     rails db:create
     

     This initializes:

     • finance_tracker_development
     • finance_tracker_test

   • Verify Role and Databases:

     • List roles:

     psql postgres -c "\\du"
     

     • List databases:

     psql -c "\\l"
     

2. Troubleshooting Common Issues

   Issue: PostgreSQL Not Running

   • Error Message: psql: could not connect to server: No such file or directory.

   • Solution: Start the PostgreSQL server:

     brew services start postgresql
     

   Issue: Missing pg_config During gem install pg

   • Error Message: Can't find the 'libpq-fe.h header'.

   • Solution:

     1. Install PostgreSQL libraries:

     brew install libpq
     

     1. Link the libraries:

     brew link --overwrite libpq
     

     1. Update your shell configuration:

     echo 'export PATH="/usr/local/opt/libpq/bin:$PATH"' >> ~/.zshrc
     source ~/.zshrc
     

     Issue: Permission Denied When Creating Databases

     • Error Message: ERROR: permission denied to create database.
     • Solution: Ensure your role has the correct permissions. Recreate the role with s for superuser privileges:

     createuser -s -r -d finance_tracker