Skip to content

Instantly share code, notes, and snippets.

@frankmt
Created December 5, 2012 10:16
Show Gist options
  • Save frankmt/4214497 to your computer and use it in GitHub Desktop.
Save frankmt/4214497 to your computer and use it in GitHub Desktop.
Lbl Setup
wget -O lbl.dump `heroku pgbackups:url --app livebelowtheline`
--2012-12-05 21:09:30-- https://s3.amazonaws.com/hkpgbackups/app2617661@heroku.com/a311.dump?AWSAccessKeyId=AKIAIYZ2BP3RBVXEIZDA&Expires=1354702770&Signature=kRPBYEWap9ZtiUApvNz%2FTi28pck%3D
Resolving s3.amazonaws.com... 207.171.189.80
Connecting to s3.amazonaws.com|207.171.189.80|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 19561402 (19M) [binary/octet-stream]
Saving to: `lbl.dump'
100%[==================================================================================================================================>] 19,561,402 309K/s in 66s
2012-12-05 21:10:39 (290 KB/s) - `lbl.dump' saved [19561402/19561402]
McNulty:lblau (master)$ pg_restore --verbose --clean --no-acl --no-owner -U lbl -d lbl_dev lbl.dump
pg_restore: connecting to database for restore
pg_restore: dropping INDEX unique_schema_migrations
pg_restore: dropping INDEX join_team_requests_team_id
pg_restore: dropping INDEX join_team_requests_participant_id
pg_restore: dropping INDEX index_users_on_id
pg_restore: dropping INDEX index_user_plugins_on_title
pg_restore: dropping INDEX index_unique_user_plugins
pg_restore: dropping INDEX index_teams_on_slug
pg_restore: dropping INDEX index_teams_on_id
pg_restore: dropping INDEX index_team_memberships_on_id
pg_restore: dropping INDEX index_slugs_on_sluggable_id
pg_restore: dropping INDEX index_slugs_on_n_s_s_and_s
pg_restore: dropping INDEX index_slugs_on_locale
pg_restore: dropping INDEX index_seo_meta_on_seo_meta_id_and_seo_meta_type
pg_restore: dropping INDEX index_seo_meta_on_id
pg_restore: dropping INDEX index_roles_users_on_user_id_and_role_id
pg_restore: dropping INDEX index_roles_users_on_role_id_and_user_id
pg_restore: dropping INDEX index_refinery_settings_on_name
pg_restore: dropping INDEX index_partners_on_id
pg_restore: dropping INDEX index_participants_on_username
pg_restore: dropping INDEX index_participants_on_reset_password_token
pg_restore: dropping INDEX index_participants_on_id
pg_restore: dropping INDEX index_participants_on_email
pg_restore: dropping INDEX index_pages_on_rgt
pg_restore: dropping INDEX index_pages_on_parent_id
pg_restore: dropping INDEX index_pages_on_lft
pg_restore: dropping INDEX index_pages_on_id
pg_restore: dropping INDEX index_pages_on_depth
pg_restore: dropping INDEX index_page_translations_on_page_id
pg_restore: dropping INDEX index_page_parts_on_page_id
pg_restore: dropping INDEX index_page_parts_on_id
pg_restore: dropping INDEX index_page_part_translations_on_page_part_id
pg_restore: dropping INDEX index_networks_on_id
pg_restore: dropping INDEX index_network_types_on_id
pg_restore: dropping INDEX index_donations_on_id
pg_restore: dropping INDEX index_campaign_countries_on_id
pg_restore: dropping INDEX index_campaign_countries_on_code
pg_restore: dropping INDEX donation_recipient
pg_restore: dropping CONSTRAINT videos_pkey
pg_restore: dropping CONSTRAINT users_pkey
pg_restore: dropping CONSTRAINT user_plugins_pkey
pg_restore: dropping CONSTRAINT teams_pkey
pg_restore: dropping CONSTRAINT slugs_pkey
pg_restore: dropping CONSTRAINT seo_meta_pkey
pg_restore: dropping CONSTRAINT roles_pkey
pg_restore: dropping CONSTRAINT resources_pkey
pg_restore: dropping CONSTRAINT reports_pkey
pg_restore: dropping CONSTRAINT refinery_settings_pkey
pg_restore: dropping CONSTRAINT posts_pkey
pg_restore: dropping CONSTRAINT partners_pkey
pg_restore: dropping CONSTRAINT participants_pkey
pg_restore: dropping CONSTRAINT pages_pkey
pg_restore: dropping CONSTRAINT page_translations_pkey
pg_restore: dropping CONSTRAINT page_parts_pkey
pg_restore: dropping CONSTRAINT page_part_translations_pkey
pg_restore: dropping CONSTRAINT networks_pkey
pg_restore: dropping CONSTRAINT network_types_pkey
pg_restore: dropping CONSTRAINT join_team_requests_pkey
pg_restore: dropping CONSTRAINT images_pkey
pg_restore: dropping CONSTRAINT feed_images_pkey
pg_restore: dropping CONSTRAINT donations_pkey
pg_restore: dropping CONSTRAINT donation_options_pkey
pg_restore: dropping CONSTRAINT comments_pkey
pg_restore: dropping CONSTRAINT campaign_countries_pkey
pg_restore: dropping TABLE DATA videos
pg_restore: dropping TABLE DATA users
pg_restore: dropping TABLE DATA user_plugins
pg_restore: dropping TABLE DATA teams
pg_restore: dropping TABLE DATA team_memberships
pg_restore: dropping TABLE DATA slugs
pg_restore: dropping TABLE DATA seo_meta
pg_restore: dropping TABLE DATA schema_migrations
pg_restore: dropping TABLE DATA roles_users
pg_restore: dropping TABLE DATA roles
pg_restore: dropping TABLE DATA resources
pg_restore: dropping TABLE DATA reports
pg_restore: dropping TABLE DATA refinery_settings
pg_restore: dropping TABLE DATA partners
pg_restore: dropping TABLE DATA participants
pg_restore: dropping TABLE DATA pages
pg_restore: dropping TABLE DATA page_translations
pg_restore: dropping TABLE DATA page_parts
pg_restore: dropping TABLE DATA page_part_translations
pg_restore: dropping TABLE DATA networks
pg_restore: dropping TABLE DATA network_types
pg_restore: dropping TABLE DATA images
pg_restore: dropping TABLE DATA feed_images
pg_restore: dropping TABLE DATA donations
pg_restore: dropping TABLE DATA donation_options
pg_restore: dropping TABLE DATA comments
pg_restore: dropping TABLE DATA campaign_countries
pg_restore: dropping TABLE DATA blogs
pg_restore: dropping DEFAULT id
pg_restore: dropping DEFAULT id
pg_restore: dropping DEFAULT id
pg_restore: dropping DEFAULT id
pg_restore: dropping DEFAULT id
pg_restore: dropping DEFAULT id
pg_restore: dropping DEFAULT id
pg_restore: dropping DEFAULT id
pg_restore: dropping DEFAULT id
pg_restore: dropping DEFAULT id
pg_restore: dropping DEFAULT id
pg_restore: dropping DEFAULT id
pg_restore: dropping DEFAULT id
pg_restore: dropping DEFAULT id
pg_restore: dropping DEFAULT id
pg_restore: dropping DEFAULT id
pg_restore: dropping DEFAULT id
pg_restore: dropping DEFAULT id
pg_restore: dropping DEFAULT id
pg_restore: dropping DEFAULT id
pg_restore: dropping DEFAULT id
pg_restore: dropping DEFAULT id
pg_restore: dropping DEFAULT id
pg_restore: dropping DEFAULT id
pg_restore: dropping DEFAULT id
pg_restore: dropping DEFAULT id
pg_restore: dropping SEQUENCE SET videos_id_seq
pg_restore: dropping SEQUENCE OWNED BY videos_id_seq
pg_restore: dropping SEQUENCE videos_id_seq
pg_restore: dropping TABLE videos
pg_restore: dropping SEQUENCE SET users_id_seq
pg_restore: dropping SEQUENCE OWNED BY users_id_seq
pg_restore: dropping SEQUENCE users_id_seq
pg_restore: dropping TABLE users
pg_restore: dropping SEQUENCE SET user_plugins_id_seq
pg_restore: dropping SEQUENCE OWNED BY user_plugins_id_seq
pg_restore: dropping SEQUENCE user_plugins_id_seq
pg_restore: dropping TABLE user_plugins
pg_restore: dropping SEQUENCE SET teams_id_seq
pg_restore: dropping SEQUENCE OWNED BY teams_id_seq
pg_restore: dropping SEQUENCE teams_id_seq
pg_restore: dropping TABLE teams
pg_restore: dropping SEQUENCE SET slugs_id_seq
pg_restore: dropping SEQUENCE OWNED BY slugs_id_seq
pg_restore: dropping SEQUENCE slugs_id_seq
pg_restore: dropping TABLE slugs
pg_restore: dropping SEQUENCE SET seo_meta_id_seq
pg_restore: dropping SEQUENCE OWNED BY seo_meta_id_seq
pg_restore: dropping SEQUENCE seo_meta_id_seq
pg_restore: dropping TABLE seo_meta
pg_restore: dropping TABLE schema_migrations
pg_restore: dropping TABLE roles_users
pg_restore: dropping SEQUENCE SET roles_id_seq
pg_restore: dropping SEQUENCE OWNED BY roles_id_seq
pg_restore: dropping SEQUENCE roles_id_seq
pg_restore: dropping TABLE roles
pg_restore: dropping SEQUENCE SET resources_id_seq
pg_restore: dropping SEQUENCE OWNED BY resources_id_seq
pg_restore: dropping SEQUENCE resources_id_seq
pg_restore: dropping TABLE resources
pg_restore: dropping SEQUENCE SET reports_id_seq
pg_restore: dropping SEQUENCE OWNED BY reports_id_seq
pg_restore: dropping SEQUENCE reports_id_seq
pg_restore: dropping TABLE reports
pg_restore: dropping SEQUENCE SET refinery_settings_id_seq
pg_restore: dropping SEQUENCE OWNED BY refinery_settings_id_seq
pg_restore: dropping SEQUENCE refinery_settings_id_seq
pg_restore: dropping TABLE refinery_settings
pg_restore: dropping SEQUENCE SET posts_id_seq
pg_restore: dropping SEQUENCE OWNED BY posts_id_seq
pg_restore: dropping SEQUENCE posts_id_seq
pg_restore: dropping SEQUENCE SET partners_id_seq
pg_restore: dropping SEQUENCE OWNED BY partners_id_seq
pg_restore: dropping SEQUENCE partners_id_seq
pg_restore: dropping TABLE partners
pg_restore: dropping SEQUENCE SET participants_id_seq
pg_restore: dropping SEQUENCE OWNED BY participants_id_seq
pg_restore: dropping SEQUENCE participants_id_seq
pg_restore: dropping TABLE participants
pg_restore: dropping SEQUENCE SET pages_id_seq
pg_restore: dropping SEQUENCE OWNED BY pages_id_seq
pg_restore: dropping SEQUENCE pages_id_seq
pg_restore: dropping TABLE pages
pg_restore: dropping SEQUENCE SET page_translations_id_seq
pg_restore: dropping SEQUENCE OWNED BY page_translations_id_seq
pg_restore: dropping SEQUENCE page_translations_id_seq
pg_restore: dropping TABLE page_translations
pg_restore: dropping SEQUENCE SET page_parts_id_seq
pg_restore: dropping SEQUENCE OWNED BY page_parts_id_seq
pg_restore: dropping SEQUENCE page_parts_id_seq
pg_restore: dropping TABLE page_parts
pg_restore: dropping SEQUENCE SET page_part_translations_id_seq
pg_restore: dropping SEQUENCE OWNED BY page_part_translations_id_seq
pg_restore: dropping SEQUENCE page_part_translations_id_seq
pg_restore: dropping TABLE page_part_translations
pg_restore: dropping SEQUENCE SET networks_id_seq
pg_restore: dropping SEQUENCE OWNED BY networks_id_seq
pg_restore: dropping SEQUENCE networks_id_seq
pg_restore: dropping TABLE networks
pg_restore: dropping SEQUENCE SET network_types_id_seq
pg_restore: dropping SEQUENCE OWNED BY network_types_id_seq
pg_restore: dropping SEQUENCE network_types_id_seq
pg_restore: dropping TABLE network_types
pg_restore: dropping SEQUENCE SET join_team_requests_id_seq
pg_restore: dropping SEQUENCE OWNED BY join_team_requests_id_seq
pg_restore: dropping SEQUENCE join_team_requests_id_seq
pg_restore: dropping TABLE team_memberships
pg_restore: dropping SEQUENCE SET images_id_seq
pg_restore: dropping SEQUENCE OWNED BY images_id_seq
pg_restore: dropping SEQUENCE images_id_seq
pg_restore: dropping TABLE images
pg_restore: dropping SEQUENCE SET feed_images_id_seq
pg_restore: dropping SEQUENCE OWNED BY feed_images_id_seq
pg_restore: dropping SEQUENCE feed_images_id_seq
pg_restore: dropping TABLE feed_images
pg_restore: dropping SEQUENCE SET donations_id_seq
pg_restore: dropping SEQUENCE OWNED BY donations_id_seq
pg_restore: dropping SEQUENCE donations_id_seq
pg_restore: dropping TABLE donations
pg_restore: dropping SEQUENCE SET donation_options_id_seq
pg_restore: dropping SEQUENCE OWNED BY donation_options_id_seq
pg_restore: dropping SEQUENCE donation_options_id_seq
pg_restore: dropping TABLE donation_options
pg_restore: dropping SEQUENCE SET comments_id_seq
pg_restore: dropping SEQUENCE OWNED BY comments_id_seq
pg_restore: dropping SEQUENCE comments_id_seq
pg_restore: dropping TABLE comments
pg_restore: dropping SEQUENCE SET campaign_countries_id_seq
pg_restore: dropping SEQUENCE OWNED BY campaign_countries_id_seq
pg_restore: dropping SEQUENCE campaign_countries_id_seq
pg_restore: dropping TABLE campaign_countries
pg_restore: dropping TABLE blogs
pg_restore: dropping COMMENT EXTENSION plpgsql
pg_restore: dropping EXTENSION plpgsql
pg_restore: dropping SCHEMA public
pg_restore: dropping DATABASE d8tuqt1pflui4o
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 2573; 1262 16417 DATABASE d8tuqt1pflui4o exrxkoctwydvtd
pg_restore: [archiver (db)] could not execute query: ERROR: database "d8tuqt1pflui4o" does not exist
Command was: DROP DATABASE d8tuqt1pflui4o;
pg_restore: creating SCHEMA public
pg_restore: creating EXTENSION plpgsql
pg_restore: creating COMMENT EXTENSION plpgsql
pg_restore: creating TABLE blogs
pg_restore: creating TABLE campaign_countries
pg_restore: creating SEQUENCE campaign_countries_id_seq
pg_restore: creating SEQUENCE OWNED BY campaign_countries_id_seq
pg_restore: executing SEQUENCE SET campaign_countries_id_seq
pg_restore: creating TABLE comments
pg_restore: creating SEQUENCE comments_id_seq
pg_restore: creating SEQUENCE OWNED BY comments_id_seq
pg_restore: executing SEQUENCE SET comments_id_seq
pg_restore: creating TABLE donation_options
pg_restore: creating SEQUENCE donation_options_id_seq
pg_restore: creating SEQUENCE OWNED BY donation_options_id_seq
pg_restore: executing SEQUENCE SET donation_options_id_seq
pg_restore: creating TABLE donations
pg_restore: creating SEQUENCE donations_id_seq
pg_restore: creating SEQUENCE OWNED BY donations_id_seq
pg_restore: executing SEQUENCE SET donations_id_seq
pg_restore: creating TABLE feed_images
pg_restore: creating SEQUENCE feed_images_id_seq
pg_restore: creating SEQUENCE OWNED BY feed_images_id_seq
pg_restore: executing SEQUENCE SET feed_images_id_seq
pg_restore: creating TABLE images
pg_restore: creating SEQUENCE images_id_seq
pg_restore: creating SEQUENCE OWNED BY images_id_seq
pg_restore: executing SEQUENCE SET images_id_seq
pg_restore: creating TABLE team_memberships
pg_restore: creating SEQUENCE join_team_requests_id_seq
pg_restore: creating SEQUENCE OWNED BY join_team_requests_id_seq
pg_restore: executing SEQUENCE SET join_team_requests_id_seq
pg_restore: creating TABLE network_types
pg_restore: creating SEQUENCE network_types_id_seq
pg_restore: creating SEQUENCE OWNED BY network_types_id_seq
pg_restore: executing SEQUENCE SET network_types_id_seq
pg_restore: creating TABLE networks
pg_restore: creating SEQUENCE networks_id_seq
pg_restore: creating SEQUENCE OWNED BY networks_id_seq
pg_restore: executing SEQUENCE SET networks_id_seq
pg_restore: creating TABLE page_part_translations
pg_restore: creating SEQUENCE page_part_translations_id_seq
pg_restore: creating SEQUENCE OWNED BY page_part_translations_id_seq
pg_restore: executing SEQUENCE SET page_part_translations_id_seq
pg_restore: creating TABLE page_parts
pg_restore: creating SEQUENCE page_parts_id_seq
pg_restore: creating SEQUENCE OWNED BY page_parts_id_seq
pg_restore: executing SEQUENCE SET page_parts_id_seq
pg_restore: creating TABLE page_translations
pg_restore: creating SEQUENCE page_translations_id_seq
pg_restore: creating SEQUENCE OWNED BY page_translations_id_seq
pg_restore: executing SEQUENCE SET page_translations_id_seq
pg_restore: creating TABLE pages
pg_restore: creating SEQUENCE pages_id_seq
pg_restore: creating SEQUENCE OWNED BY pages_id_seq
pg_restore: executing SEQUENCE SET pages_id_seq
pg_restore: creating TABLE participants
pg_restore: creating SEQUENCE participants_id_seq
pg_restore: creating SEQUENCE OWNED BY participants_id_seq
pg_restore: executing SEQUENCE SET participants_id_seq
pg_restore: creating TABLE partners
pg_restore: creating SEQUENCE partners_id_seq
pg_restore: creating SEQUENCE OWNED BY partners_id_seq
pg_restore: executing SEQUENCE SET partners_id_seq
pg_restore: creating SEQUENCE posts_id_seq
pg_restore: creating SEQUENCE OWNED BY posts_id_seq
pg_restore: executing SEQUENCE SET posts_id_seq
pg_restore: creating TABLE refinery_settings
pg_restore: creating SEQUENCE refinery_settings_id_seq
pg_restore: creating SEQUENCE OWNED BY refinery_settings_id_seq
pg_restore: executing SEQUENCE SET refinery_settings_id_seq
pg_restore: creating TABLE reports
pg_restore: creating SEQUENCE reports_id_seq
pg_restore: creating SEQUENCE OWNED BY reports_id_seq
pg_restore: executing SEQUENCE SET reports_id_seq
pg_restore: creating TABLE resources
pg_restore: creating SEQUENCE resources_id_seq
pg_restore: creating SEQUENCE OWNED BY resources_id_seq
pg_restore: executing SEQUENCE SET resources_id_seq
pg_restore: creating TABLE roles
pg_restore: creating SEQUENCE roles_id_seq
pg_restore: creating SEQUENCE OWNED BY roles_id_seq
pg_restore: executing SEQUENCE SET roles_id_seq
pg_restore: creating TABLE roles_users
pg_restore: creating TABLE schema_migrations
pg_restore: creating TABLE seo_meta
pg_restore: creating SEQUENCE seo_meta_id_seq
pg_restore: creating SEQUENCE OWNED BY seo_meta_id_seq
pg_restore: executing SEQUENCE SET seo_meta_id_seq
pg_restore: creating TABLE slugs
pg_restore: creating SEQUENCE slugs_id_seq
pg_restore: creating SEQUENCE OWNED BY slugs_id_seq
pg_restore: executing SEQUENCE SET slugs_id_seq
pg_restore: creating TABLE teams
pg_restore: creating SEQUENCE teams_id_seq
pg_restore: creating SEQUENCE OWNED BY teams_id_seq
pg_restore: executing SEQUENCE SET teams_id_seq
pg_restore: creating TABLE user_plugins
pg_restore: creating SEQUENCE user_plugins_id_seq
pg_restore: creating SEQUENCE OWNED BY user_plugins_id_seq
pg_restore: executing SEQUENCE SET user_plugins_id_seq
pg_restore: creating TABLE users
pg_restore: creating SEQUENCE users_id_seq
pg_restore: creating SEQUENCE OWNED BY users_id_seq
pg_restore: executing SEQUENCE SET users_id_seq
pg_restore: creating TABLE videos
pg_restore: creating SEQUENCE videos_id_seq
pg_restore: creating SEQUENCE OWNED BY videos_id_seq
pg_restore: executing SEQUENCE SET videos_id_seq
pg_restore: creating DEFAULT id
pg_restore: creating DEFAULT id
pg_restore: creating DEFAULT id
pg_restore: creating DEFAULT id
pg_restore: creating DEFAULT id
pg_restore: creating DEFAULT id
pg_restore: creating DEFAULT id
pg_restore: creating DEFAULT id
pg_restore: creating DEFAULT id
pg_restore: creating DEFAULT id
pg_restore: creating DEFAULT id
pg_restore: creating DEFAULT id
pg_restore: creating DEFAULT id
pg_restore: creating DEFAULT id
pg_restore: creating DEFAULT id
pg_restore: creating DEFAULT id
pg_restore: creating DEFAULT id
pg_restore: creating DEFAULT id
pg_restore: creating DEFAULT id
pg_restore: creating DEFAULT id
pg_restore: creating DEFAULT id
pg_restore: creating DEFAULT id
pg_restore: creating DEFAULT id
pg_restore: creating DEFAULT id
pg_restore: creating DEFAULT id
pg_restore: creating DEFAULT id
pg_restore: restoring data for table "blogs"
pg_restore: restoring data for table "campaign_countries"
pg_restore: restoring data for table "comments"
pg_restore: restoring data for table "donation_options"
pg_restore: restoring data for table "donations"
pg_restore: restoring data for table "feed_images"
pg_restore: restoring data for table "images"
pg_restore: restoring data for table "network_types"
pg_restore: restoring data for table "networks"
pg_restore: restoring data for table "page_part_translations"
pg_restore: restoring data for table "page_parts"
pg_restore: restoring data for table "page_translations"
pg_restore: restoring data for table "pages"
pg_restore: restoring data for table "participants"
pg_restore: restoring data for table "partners"
pg_restore: restoring data for table "refinery_settings"
pg_restore: restoring data for table "reports"
pg_restore: restoring data for table "resources"
pg_restore: restoring data for table "roles"
pg_restore: restoring data for table "roles_users"
pg_restore: restoring data for table "schema_migrations"
pg_restore: restoring data for table "seo_meta"
pg_restore: restoring data for table "slugs"
pg_restore: restoring data for table "team_memberships"
pg_restore: restoring data for table "teams"
pg_restore: restoring data for table "user_plugins"
pg_restore: restoring data for table "users"
pg_restore: restoring data for table "videos"
pg_restore: creating CONSTRAINT campaign_countries_pkey
pg_restore: creating CONSTRAINT comments_pkey
pg_restore: creating CONSTRAINT donation_options_pkey
pg_restore: creating CONSTRAINT donations_pkey
pg_restore: creating CONSTRAINT feed_images_pkey
pg_restore: creating CONSTRAINT images_pkey
pg_restore: creating CONSTRAINT join_team_requests_pkey
pg_restore: creating CONSTRAINT network_types_pkey
pg_restore: creating CONSTRAINT networks_pkey
pg_restore: creating CONSTRAINT page_part_translations_pkey
pg_restore: creating CONSTRAINT page_parts_pkey
pg_restore: creating CONSTRAINT page_translations_pkey
pg_restore: creating CONSTRAINT pages_pkey
pg_restore: creating CONSTRAINT participants_pkey
pg_restore: creating CONSTRAINT partners_pkey
pg_restore: creating CONSTRAINT posts_pkey
pg_restore: creating CONSTRAINT refinery_settings_pkey
pg_restore: creating CONSTRAINT reports_pkey
pg_restore: creating CONSTRAINT resources_pkey
pg_restore: creating CONSTRAINT roles_pkey
pg_restore: creating CONSTRAINT seo_meta_pkey
pg_restore: creating CONSTRAINT slugs_pkey
pg_restore: creating CONSTRAINT teams_pkey
pg_restore: creating CONSTRAINT user_plugins_pkey
pg_restore: creating CONSTRAINT users_pkey
pg_restore: creating CONSTRAINT videos_pkey
pg_restore: creating INDEX donation_recipient
pg_restore: creating INDEX index_campaign_countries_on_code
pg_restore: creating INDEX index_campaign_countries_on_id
pg_restore: creating INDEX index_donations_on_id
pg_restore: creating INDEX index_network_types_on_id
pg_restore: creating INDEX index_networks_on_id
pg_restore: creating INDEX index_page_part_translations_on_page_part_id
pg_restore: creating INDEX index_page_parts_on_id
pg_restore: creating INDEX index_page_parts_on_page_id
pg_restore: creating INDEX index_page_translations_on_page_id
pg_restore: creating INDEX index_pages_on_depth
pg_restore: creating INDEX index_pages_on_id
pg_restore: creating INDEX index_pages_on_lft
pg_restore: creating INDEX index_pages_on_parent_id
pg_restore: creating INDEX index_pages_on_rgt
pg_restore: creating INDEX index_participants_on_email
pg_restore: creating INDEX index_participants_on_id
pg_restore: creating INDEX index_participants_on_reset_password_token
pg_restore: creating INDEX index_participants_on_username
pg_restore: creating INDEX index_partners_on_id
pg_restore: creating INDEX index_refinery_settings_on_name
pg_restore: creating INDEX index_roles_users_on_role_id_and_user_id
pg_restore: creating INDEX index_roles_users_on_user_id_and_role_id
pg_restore: creating INDEX index_seo_meta_on_id
pg_restore: creating INDEX index_seo_meta_on_seo_meta_id_and_seo_meta_type
pg_restore: creating INDEX index_slugs_on_locale
pg_restore: creating INDEX index_slugs_on_n_s_s_and_s
pg_restore: creating INDEX index_slugs_on_sluggable_id
pg_restore: creating INDEX index_team_memberships_on_id
pg_restore: creating INDEX index_teams_on_id
pg_restore: creating INDEX index_teams_on_slug
pg_restore: creating INDEX index_unique_user_plugins
pg_restore: creating INDEX index_user_plugins_on_title
pg_restore: creating INDEX index_users_on_id
pg_restore: creating INDEX join_team_requests_participant_id
pg_restore: creating INDEX join_team_requests_team_id
pg_restore: creating INDEX unique_schema_migrations
pg_restore: setting owner and privileges for DATABASE d8tuqt1pflui4o
pg_restore: setting owner and privileges for SCHEMA public
pg_restore: setting owner and privileges for EXTENSION plpgsql
pg_restore: setting owner and privileges for COMMENT EXTENSION plpgsql
pg_restore: setting owner and privileges for TABLE blogs
pg_restore: setting owner and privileges for TABLE campaign_countries
pg_restore: setting owner and privileges for SEQUENCE campaign_countries_id_seq
pg_restore: setting owner and privileges for SEQUENCE OWNED BY campaign_countries_id_seq
pg_restore: setting owner and privileges for SEQUENCE SET campaign_countries_id_seq
pg_restore: setting owner and privileges for TABLE comments
pg_restore: setting owner and privileges for SEQUENCE comments_id_seq
pg_restore: setting owner and privileges for SEQUENCE OWNED BY comments_id_seq
pg_restore: setting owner and privileges for SEQUENCE SET comments_id_seq
pg_restore: setting owner and privileges for TABLE donation_options
pg_restore: setting owner and privileges for SEQUENCE donation_options_id_seq
pg_restore: setting owner and privileges for SEQUENCE OWNED BY donation_options_id_seq
pg_restore: setting owner and privileges for SEQUENCE SET donation_options_id_seq
pg_restore: setting owner and privileges for TABLE donations
pg_restore: setting owner and privileges for SEQUENCE donations_id_seq
pg_restore: setting owner and privileges for SEQUENCE OWNED BY donations_id_seq
pg_restore: setting owner and privileges for SEQUENCE SET donations_id_seq
pg_restore: setting owner and privileges for TABLE feed_images
pg_restore: setting owner and privileges for SEQUENCE feed_images_id_seq
pg_restore: setting owner and privileges for SEQUENCE OWNED BY feed_images_id_seq
pg_restore: setting owner and privileges for SEQUENCE SET feed_images_id_seq
pg_restore: setting owner and privileges for TABLE images
pg_restore: setting owner and privileges for SEQUENCE images_id_seq
pg_restore: setting owner and privileges for SEQUENCE OWNED BY images_id_seq
pg_restore: setting owner and privileges for SEQUENCE SET images_id_seq
pg_restore: setting owner and privileges for TABLE team_memberships
pg_restore: setting owner and privileges for SEQUENCE join_team_requests_id_seq
pg_restore: setting owner and privileges for SEQUENCE OWNED BY join_team_requests_id_seq
pg_restore: setting owner and privileges for SEQUENCE SET join_team_requests_id_seq
pg_restore: setting owner and privileges for TABLE network_types
pg_restore: setting owner and privileges for SEQUENCE network_types_id_seq
pg_restore: setting owner and privileges for SEQUENCE OWNED BY network_types_id_seq
pg_restore: setting owner and privileges for SEQUENCE SET network_types_id_seq
pg_restore: setting owner and privileges for TABLE networks
pg_restore: setting owner and privileges for SEQUENCE networks_id_seq
pg_restore: setting owner and privileges for SEQUENCE OWNED BY networks_id_seq
pg_restore: setting owner and privileges for SEQUENCE SET networks_id_seq
pg_restore: setting owner and privileges for TABLE page_part_translations
pg_restore: setting owner and privileges for SEQUENCE page_part_translations_id_seq
pg_restore: setting owner and privileges for SEQUENCE OWNED BY page_part_translations_id_seq
pg_restore: setting owner and privileges for SEQUENCE SET page_part_translations_id_seq
pg_restore: setting owner and privileges for TABLE page_parts
pg_restore: setting owner and privileges for SEQUENCE page_parts_id_seq
pg_restore: setting owner and privileges for SEQUENCE OWNED BY page_parts_id_seq
pg_restore: setting owner and privileges for SEQUENCE SET page_parts_id_seq
pg_restore: setting owner and privileges for TABLE page_translations
pg_restore: setting owner and privileges for SEQUENCE page_translations_id_seq
pg_restore: setting owner and privileges for SEQUENCE OWNED BY page_translations_id_seq
pg_restore: setting owner and privileges for SEQUENCE SET page_translations_id_seq
pg_restore: setting owner and privileges for TABLE pages
pg_restore: setting owner and privileges for SEQUENCE pages_id_seq
pg_restore: setting owner and privileges for SEQUENCE OWNED BY pages_id_seq
pg_restore: setting owner and privileges for SEQUENCE SET pages_id_seq
pg_restore: setting owner and privileges for TABLE participants
pg_restore: setting owner and privileges for SEQUENCE participants_id_seq
pg_restore: setting owner and privileges for SEQUENCE OWNED BY participants_id_seq
pg_restore: setting owner and privileges for SEQUENCE SET participants_id_seq
pg_restore: setting owner and privileges for TABLE partners
pg_restore: setting owner and privileges for SEQUENCE partners_id_seq
pg_restore: setting owner and privileges for SEQUENCE OWNED BY partners_id_seq
pg_restore: setting owner and privileges for SEQUENCE SET partners_id_seq
pg_restore: setting owner and privileges for SEQUENCE posts_id_seq
pg_restore: setting owner and privileges for SEQUENCE OWNED BY posts_id_seq
pg_restore: setting owner and privileges for SEQUENCE SET posts_id_seq
pg_restore: setting owner and privileges for TABLE refinery_settings
pg_restore: setting owner and privileges for SEQUENCE refinery_settings_id_seq
pg_restore: setting owner and privileges for SEQUENCE OWNED BY refinery_settings_id_seq
pg_restore: setting owner and privileges for SEQUENCE SET refinery_settings_id_seq
pg_restore: setting owner and privileges for TABLE reports
pg_restore: setting owner and privileges for SEQUENCE reports_id_seq
pg_restore: setting owner and privileges for SEQUENCE OWNED BY reports_id_seq
pg_restore: setting owner and privileges for SEQUENCE SET reports_id_seq
pg_restore: setting owner and privileges for TABLE resources
pg_restore: setting owner and privileges for SEQUENCE resources_id_seq
pg_restore: setting owner and privileges for SEQUENCE OWNED BY resources_id_seq
pg_restore: setting owner and privileges for SEQUENCE SET resources_id_seq
pg_restore: setting owner and privileges for TABLE roles
pg_restore: setting owner and privileges for SEQUENCE roles_id_seq
pg_restore: setting owner and privileges for SEQUENCE OWNED BY roles_id_seq
pg_restore: setting owner and privileges for SEQUENCE SET roles_id_seq
pg_restore: setting owner and privileges for TABLE roles_users
pg_restore: setting owner and privileges for TABLE schema_migrations
pg_restore: setting owner and privileges for TABLE seo_meta
pg_restore: setting owner and privileges for SEQUENCE seo_meta_id_seq
pg_restore: setting owner and privileges for SEQUENCE OWNED BY seo_meta_id_seq
pg_restore: setting owner and privileges for SEQUENCE SET seo_meta_id_seq
pg_restore: setting owner and privileges for TABLE slugs
pg_restore: setting owner and privileges for SEQUENCE slugs_id_seq
pg_restore: setting owner and privileges for SEQUENCE OWNED BY slugs_id_seq
pg_restore: setting owner and privileges for SEQUENCE SET slugs_id_seq
pg_restore: setting owner and privileges for TABLE teams
pg_restore: setting owner and privileges for SEQUENCE teams_id_seq
pg_restore: setting owner and privileges for SEQUENCE OWNED BY teams_id_seq
pg_restore: setting owner and privileges for SEQUENCE SET teams_id_seq
pg_restore: setting owner and privileges for TABLE user_plugins
pg_restore: setting owner and privileges for SEQUENCE user_plugins_id_seq
pg_restore: setting owner and privileges for SEQUENCE OWNED BY user_plugins_id_seq
pg_restore: setting owner and privileges for SEQUENCE SET user_plugins_id_seq
pg_restore: setting owner and privileges for TABLE users
pg_restore: setting owner and privileges for SEQUENCE users_id_seq
pg_restore: setting owner and privileges for SEQUENCE OWNED BY users_id_seq
pg_restore: setting owner and privileges for SEQUENCE SET users_id_seq
pg_restore: setting owner and privileges for TABLE videos
pg_restore: setting owner and privileges for SEQUENCE videos_id_seq
pg_restore: setting owner and privileges for SEQUENCE OWNED BY videos_id_seq
pg_restore: setting owner and privileges for SEQUENCE SET videos_id_seq
pg_restore: setting owner and privileges for DEFAULT id
pg_restore: setting owner and privileges for DEFAULT id
pg_restore: setting owner and privileges for DEFAULT id
pg_restore: setting owner and privileges for DEFAULT id
pg_restore: setting owner and privileges for DEFAULT id
pg_restore: setting owner and privileges for DEFAULT id
pg_restore: setting owner and privileges for DEFAULT id
pg_restore: setting owner and privileges for DEFAULT id
pg_restore: setting owner and privileges for DEFAULT id
pg_restore: setting owner and privileges for DEFAULT id
pg_restore: setting owner and privileges for DEFAULT id
pg_restore: setting owner and privileges for DEFAULT id
pg_restore: setting owner and privileges for DEFAULT id
pg_restore: setting owner and privileges for DEFAULT id
pg_restore: setting owner and privileges for DEFAULT id
pg_restore: setting owner and privileges for DEFAULT id
pg_restore: setting owner and privileges for DEFAULT id
pg_restore: setting owner and privileges for DEFAULT id
pg_restore: setting owner and privileges for DEFAULT id
pg_restore: setting owner and privileges for DEFAULT id
pg_restore: setting owner and privileges for DEFAULT id
pg_restore: setting owner and privileges for DEFAULT id
pg_restore: setting owner and privileges for DEFAULT id
pg_restore: setting owner and privileges for DEFAULT id
pg_restore: setting owner and privileges for DEFAULT id
pg_restore: setting owner and privileges for DEFAULT id
pg_restore: setting owner and privileges for TABLE DATA blogs
pg_restore: setting owner and privileges for TABLE DATA campaign_countries
pg_restore: setting owner and privileges for TABLE DATA comments
pg_restore: setting owner and privileges for TABLE DATA donation_options
pg_restore: setting owner and privileges for TABLE DATA donations
pg_restore: setting owner and privileges for TABLE DATA feed_images
pg_restore: setting owner and privileges for TABLE DATA images
pg_restore: setting owner and privileges for TABLE DATA network_types
pg_restore: setting owner and privileges for TABLE DATA networks
pg_restore: setting owner and privileges for TABLE DATA page_part_translations
pg_restore: setting owner and privileges for TABLE DATA page_parts
pg_restore: setting owner and privileges for TABLE DATA page_translations
pg_restore: setting owner and privileges for TABLE DATA pages
pg_restore: setting owner and privileges for TABLE DATA participants
pg_restore: setting owner and privileges for TABLE DATA partners
pg_restore: setting owner and privileges for TABLE DATA refinery_settings
pg_restore: setting owner and privileges for TABLE DATA reports
pg_restore: setting owner and privileges for TABLE DATA resources
pg_restore: setting owner and privileges for TABLE DATA roles
pg_restore: setting owner and privileges for TABLE DATA roles_users
pg_restore: setting owner and privileges for TABLE DATA schema_migrations
pg_restore: setting owner and privileges for TABLE DATA seo_meta
pg_restore: setting owner and privileges for TABLE DATA slugs
pg_restore: setting owner and privileges for TABLE DATA team_memberships
pg_restore: setting owner and privileges for TABLE DATA teams
pg_restore: setting owner and privileges for TABLE DATA user_plugins
pg_restore: setting owner and privileges for TABLE DATA users
pg_restore: setting owner and privileges for TABLE DATA videos
pg_restore: setting owner and privileges for CONSTRAINT campaign_countries_pkey
pg_restore: setting owner and privileges for CONSTRAINT comments_pkey
pg_restore: setting owner and privileges for CONSTRAINT donation_options_pkey
pg_restore: setting owner and privileges for CONSTRAINT donations_pkey
pg_restore: setting owner and privileges for CONSTRAINT feed_images_pkey
pg_restore: setting owner and privileges for CONSTRAINT images_pkey
pg_restore: setting owner and privileges for CONSTRAINT join_team_requests_pkey
pg_restore: setting owner and privileges for CONSTRAINT network_types_pkey
pg_restore: setting owner and privileges for CONSTRAINT networks_pkey
pg_restore: setting owner and privileges for CONSTRAINT page_part_translations_pkey
pg_restore: setting owner and privileges for CONSTRAINT page_parts_pkey
pg_restore: setting owner and privileges for CONSTRAINT page_translations_pkey
pg_restore: setting owner and privileges for CONSTRAINT pages_pkey
pg_restore: setting owner and privileges for CONSTRAINT participants_pkey
pg_restore: setting owner and privileges for CONSTRAINT partners_pkey
pg_restore: setting owner and privileges for CONSTRAINT posts_pkey
pg_restore: setting owner and privileges for CONSTRAINT refinery_settings_pkey
pg_restore: setting owner and privileges for CONSTRAINT reports_pkey
pg_restore: setting owner and privileges for CONSTRAINT resources_pkey
pg_restore: setting owner and privileges for CONSTRAINT roles_pkey
pg_restore: setting owner and privileges for CONSTRAINT seo_meta_pkey
pg_restore: setting owner and privileges for CONSTRAINT slugs_pkey
pg_restore: setting owner and privileges for CONSTRAINT teams_pkey
pg_restore: setting owner and privileges for CONSTRAINT user_plugins_pkey
pg_restore: setting owner and privileges for CONSTRAINT users_pkey
pg_restore: setting owner and privileges for CONSTRAINT videos_pkey
pg_restore: setting owner and privileges for INDEX donation_recipient
pg_restore: setting owner and privileges for INDEX index_campaign_countries_on_code
pg_restore: setting owner and privileges for INDEX index_campaign_countries_on_id
pg_restore: setting owner and privileges for INDEX index_donations_on_id
pg_restore: setting owner and privileges for INDEX index_network_types_on_id
pg_restore: setting owner and privileges for INDEX index_networks_on_id
pg_restore: setting owner and privileges for INDEX index_page_part_translations_on_page_part_id
pg_restore: setting owner and privileges for INDEX index_page_parts_on_id
pg_restore: setting owner and privileges for INDEX index_page_parts_on_page_id
pg_restore: setting owner and privileges for INDEX index_page_translations_on_page_id
pg_restore: setting owner and privileges for INDEX index_pages_on_depth
pg_restore: setting owner and privileges for INDEX index_pages_on_id
pg_restore: setting owner and privileges for INDEX index_pages_on_lft
pg_restore: setting owner and privileges for INDEX index_pages_on_parent_id
pg_restore: setting owner and privileges for INDEX index_pages_on_rgt
pg_restore: setting owner and privileges for INDEX index_participants_on_email
pg_restore: setting owner and privileges for INDEX index_participants_on_id
pg_restore: setting owner and privileges for INDEX index_participants_on_reset_password_token
pg_restore: setting owner and privileges for INDEX index_participants_on_username
pg_restore: setting owner and privileges for INDEX index_partners_on_id
pg_restore: setting owner and privileges for INDEX index_refinery_settings_on_name
pg_restore: setting owner and privileges for INDEX index_roles_users_on_role_id_and_user_id
pg_restore: setting owner and privileges for INDEX index_roles_users_on_user_id_and_role_id
pg_restore: setting owner and privileges for INDEX index_seo_meta_on_id
pg_restore: setting owner and privileges for INDEX index_seo_meta_on_seo_meta_id_and_seo_meta_type
pg_restore: setting owner and privileges for INDEX index_slugs_on_locale
pg_restore: setting owner and privileges for INDEX index_slugs_on_n_s_s_and_s
pg_restore: setting owner and privileges for INDEX index_slugs_on_sluggable_id
pg_restore: setting owner and privileges for INDEX index_team_memberships_on_id
pg_restore: setting owner and privileges for INDEX index_teams_on_id
pg_restore: setting owner and privileges for INDEX index_teams_on_slug
pg_restore: setting owner and privileges for INDEX index_unique_user_plugins
pg_restore: setting owner and privileges for INDEX index_user_plugins_on_title
pg_restore: setting owner and privileges for INDEX index_users_on_id
pg_restore: setting owner and privileges for INDEX join_team_requests_participant_id
pg_restore: setting owner and privileges for INDEX join_team_requests_team_id
pg_restore: setting owner and privileges for INDEX unique_schema_migrations
WARNING: errors ignored on restore: 1
McNulty:lblau (master)$ be rake
WARNING: Nokogiri was built against LibXML version 2.7.7, but has dynamically loaded 2.7.3
You have 7 pending migrations:
20121101045043 ReplaceHomePageWithAustralia
20121112063408 AddFacebookIdToParticipant
20121116035527 CreateInterestRegistrations
20121116054157 AddParticipantIdToInterestRegistrations
20121121070455 AddActiveToParticipants
20121122110000 AddFacebookConnectStatusToParticipant
20121122110001 AddFundraisingTargetAndLastYearsAverageToCampaignCountry
Run "rake db:migrate" to update your database then try again.
McNulty:lblau (master)$ be rake db:migrate
WARNING: Nokogiri was built against LibXML version 2.7.7, but has dynamically loaded 2.7.3
== ReplaceHomePageWithAustralia: migrating ===================================
rake aborted!
An error has occurred, this and all later migrations canceled:
undefined method `sluggable_id' for nil:NilClass
Tasks: TOP => db:migrate
(See full trace by running task with --trace)
McNulty:lblau (master)$
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment