All Collections
Customize your nation
How to open your NationBuilder snapshot on a Mac
How to open your NationBuilder snapshot on a Mac

This HOWTO will teach you how to open a NationBuilder snapshot on your Mac, so that you can work with your data outside of NationBuilder.

Updated over a week ago

Using the Postgres/pgAdmin Apps

1. Install Postgres App.

2. Download the most recent version of pgAdmin 4. Open the pgadmin4-[version number].dmg file to download the application.

3. Open the Postgres App, and click "Initialize" from the window that opens. Select the "postgres" server icon.

4. Open up a window in terminal, and enter "psql".

5. Make owner "nbuild" as a superuser:

6. Create a new database "nbuild" with owner "nbuild":

7. Connect to the "nbuild" database:
\c nbuild;

8. Paste the following command, replace "SLUG" with the slug of the nation the snapshot is from.

CREATE SCHEMA nbuild_SLUG; CREATE SCHEMA shared_extensions; CREATE EXTENSION hstore WITH schema shared_extensions; CREATE EXTENSION dblink WITH schema shared_extensions; CREATE EXTENSION citext WITH schema shared_extensions; CREATE EXTENSION pg_trgm WITH schema shared_extensions;

9. Open pgAdmin.

10. Right-click on Servers and select Create Server...

11. Under General, set the Name as 'localhost.'

12. Under Connection, set the Host name/address as 'localhost,' the Port as '5432', the Maintenance database as 'postgres' and the Username as 'nbuild'

13. Under Servers > localhost > Databases > nbuild > Schemas, find your schema. Right click and select Restore.

14. Click on the three dots in the Filename field to search for your file. Make sure the filename format is set to All Files.

15. Select your file and click Restore.

Now you should be good to go!

Related HOWTOs

Did this answer your question?