PgAdmin - UCL-ShippingGroup/shipviz GitHub Wiki

A utility that'd be nice to have in combination with CartoDB if not already installed is PgAdmin3, to browse the contents of CartoDB databases. You can install it like this:

sudo apt-get install -y pgadmin3

And open it like this:

pgadmin3 &

Then click on the button to Add a connection to a server and insert:

• Name: carto
• Host: localhost (or IP if connecting from some other computer)
• Port: 5432
• Maintenance DB: postgres
• Password: postgres

Leave the rest as default and click OK.

The schema to the left should display now a dropdown list of databases, including databases named carto_dev_user_XXXXX with XXXX being the user id of each user created with the create_dev_user script.