Search code examples
postgresqlcloud9-ide

Where to find the PostgreSQL db file in Cloud9?

I recently switched from SQLite to PostgreSQL and am using Cloud9 IDE (Rails). With SQLite there was a file db/development.sqlite that I could open to examine the db contents. Where can I find a similar file now I've switched to PostgreSQL?

Solution

  • You should be able to use the following:

    sudo sudo -u postgres psql

    to access your PostgreSQL server. Here's some documentation from Cloud9 regarding PostgreSQL.