Skip to content

Instantly share code, notes, and snippets.

@roukmoute
Last active August 30, 2019 14:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save roukmoute/d698510b1ef79bfad6b16106748fe430 to your computer and use it in GitHub Desktop.
Save roukmoute/d698510b1ef79bfad6b16106748fe430 to your computer and use it in GitHub Desktop.
TAOP - Makefile - Import segfault
[postgres@roukmoute-pc TheArtOfPostgreSQL]$ make
createuser -SDr taop
createdb -O taop taop
psql -d taop -c 'create extension btree_gist'
CREATE EXTENSION
psql -d taop -c 'create extension ip4r'
CREATE EXTENSION
psql -d taop -c 'create extension hll'
CREATE EXTENSION
psql -d taop -c 'create extension cube'
CREATE EXTENSION
psql -d taop -c 'create extension earthdistance'
CREATE EXTENSION
psql -d taop -c 'create extension hstore'
CREATE EXTENSION
psql -d taop -c 'create extension intarray'
CREATE EXTENSION
psql -d taop -c 'create extension pg_trgm'
CREATE EXTENSION
pg_restore -v -U taop -d taop --use-list=./exclude-extensions.list --no-owner ./taop.dump
pg_restore: connecting to database for restore
pg_restore: creating SCHEMA "chinook"
pg_restore: creating SCHEMA "eav"
pg_restore: creating SCHEMA "f1db"
pg_restore: creating SCHEMA "geolite"
pg_restore: creating SCHEMA "geoname"
pg_restore: creating SCHEMA "imdb"
pg_restore: creating SCHEMA "lastfm"
pg_restore: creating SCHEMA "magic"
pg_restore: creating SCHEMA "moma"
pg_restore: creating SCHEMA "opendata"
pg_restore: creating SCHEMA "raw"
pg_restore: creating SCHEMA "sample"
pg_restore: creating SCHEMA "sandbox"
pg_restore: creating SCHEMA "twcache"
pg_restore: creating SCHEMA "tweet"
pg_restore: creating TYPE "public.rate_t"
pg_restore: creating TYPE "tweet.action_t"
pg_restore: creating FUNCTION "chinook.get_all_albums(bigint)"
pg_restore: creating FUNCTION "chinook.get_all_albums(text)"
pg_restore: creating FUNCTION "moma.audit()"
pg_restore: creating FUNCTION "public.random(integer, integer)"
pg_restore: creating FUNCTION "public.random(timestamp with time zone, timestamp with time zone)"
pg_restore: creating FUNCTION "public.syncrep_important_delta()"
pg_restore: creating FUNCTION "sandbox.lorem(integer)"
pg_restore: creating FUNCTION "tweet.update_unique_visitors(bigint)"
pg_restore: creating TABLE "chinook.album"
pg_restore: creating TABLE "chinook.artist"
pg_restore: creating TABLE "chinook.cars"
pg_restore: creating TABLE "chinook.color"
pg_restore: creating SEQUENCE "chinook.color_id_seq"
pg_restore: creating SEQUENCE OWNED BY "chinook.color_id_seq"
pg_restore: creating TABLE "chinook.commitlog"
pg_restore: creating TABLE "chinook.customer"
pg_restore: creating TABLE "chinook.employee"
pg_restore: creating TABLE "chinook.genre"
pg_restore: creating TABLE "chinook.invoice"
pg_restore: creating TABLE "chinook.invoiceline"
pg_restore: creating TABLE "chinook.mediatype"
pg_restore: creating TABLE "chinook.playlist"
pg_restore: creating TABLE "chinook.playlisttrack"
pg_restore: creating TABLE "chinook.track"
pg_restore: creating TABLE "eav.customer"
pg_restore: creating SEQUENCE "eav.customer_id_seq"
pg_restore: creating SEQUENCE OWNED BY "eav.customer_id_seq"
pg_restore: creating TABLE "eav.params"
pg_restore: creating TABLE "eav.support"
pg_restore: creating TABLE "eav.support_contract"
pg_restore: creating SEQUENCE "eav.support_contract_id_seq"
pg_restore: creating SEQUENCE OWNED BY "eav.support_contract_id_seq"
pg_restore: creating TABLE "eav.support_contract_type"
pg_restore: creating SEQUENCE "eav.support_contract_type_id_seq"
pg_restore: creating SEQUENCE OWNED BY "eav.support_contract_type_id_seq"
pg_restore: creating TABLE "f1db.circuits"
pg_restore: creating SEQUENCE "f1db.circuits_circuitid_seq"
pg_restore: creating SEQUENCE OWNED BY "f1db.circuits_circuitid_seq"
pg_restore: creating TABLE "f1db.constructorresults"
pg_restore: creating SEQUENCE "f1db.constructorresults_constructorresultsid_seq"
pg_restore: creating SEQUENCE OWNED BY "f1db.constructorresults_constructorresultsid_seq"
pg_restore: creating TABLE "f1db.constructors"
pg_restore: creating SEQUENCE "f1db.constructors_constructorid_seq"
pg_restore: creating SEQUENCE OWNED BY "f1db.constructors_constructorid_seq"
pg_restore: creating TABLE "f1db.constructorstandings"
pg_restore: creating SEQUENCE "f1db.constructorstandings_constructorstandingsid_seq"
pg_restore: creating SEQUENCE OWNED BY "f1db.constructorstandings_constructorstandingsid_seq"
pg_restore: creating TABLE "f1db.drivers"
pg_restore: creating SEQUENCE "f1db.drivers_driverid_seq"
pg_restore: creating SEQUENCE OWNED BY "f1db.drivers_driverid_seq"
pg_restore: creating TABLE "f1db.driverstandings"
pg_restore: creating SEQUENCE "f1db.driverstandings_driverstandingsid_seq"
pg_restore: creating SEQUENCE OWNED BY "f1db.driverstandings_driverstandingsid_seq"
pg_restore: creating TABLE "f1db.laptimes"
pg_restore: creating TABLE "f1db.pitstops"
pg_restore: creating TABLE "f1db.qualifying"
pg_restore: creating SEQUENCE "f1db.qualifying_qualifyid_seq"
pg_restore: creating SEQUENCE OWNED BY "f1db.qualifying_qualifyid_seq"
pg_restore: creating TABLE "f1db.races"
pg_restore: creating SEQUENCE "f1db.races_raceid_seq"
pg_restore: creating SEQUENCE OWNED BY "f1db.races_raceid_seq"
pg_restore: creating TABLE "f1db.results"
pg_restore: creating SEQUENCE "f1db.results_resultid_seq"
pg_restore: creating SEQUENCE OWNED BY "f1db.results_resultid_seq"
pg_restore: creating TABLE "f1db.seasons"
pg_restore: creating TABLE "f1db.status"
pg_restore: creating SEQUENCE "f1db.status_statusid_seq"
pg_restore: creating SEQUENCE OWNED BY "f1db.status_statusid_seq"
pg_restore: creating TABLE "geolite.blocks"
pg_restore: creating TABLE "geolite.location"
pg_restore: creating TABLE "geoname.class"
pg_restore: creating TABLE "geoname.continent"
pg_restore: creating TABLE "geoname.country"
pg_restore: creating TABLE "geoname.district"
pg_restore: creating TABLE "geoname.feature"
pg_restore: creating TABLE "geoname.geoname"
pg_restore: creating TABLE "geoname.neighbour"
pg_restore: creating TABLE "geoname.region"
pg_restore: creating TABLE "imdb.akas"
pg_restore: creating TABLE "imdb.name"
pg_restore: creating TABLE "imdb.uname"
pg_restore: creating TABLE "lastfm.tags"
pg_restore: creating SEQUENCE "lastfm.tags_rowid_seq"
pg_restore: creating SEQUENCE OWNED BY "lastfm.tags_rowid_seq"
pg_restore: creating TABLE "lastfm.tid_tag"
pg_restore: creating TABLE "lastfm.tids"
pg_restore: creating SEQUENCE "lastfm.tids_rowid_seq"
pg_restore: creating SEQUENCE OWNED BY "lastfm.tids_rowid_seq"
pg_restore: creating TABLE "lastfm.track"
pg_restore: creating VIEW "lastfm.v_track_tags"
pg_restore: creating MATERIALIZED VIEW "lastfm.track_tags"
pg_restore: creating TABLE "magic.allsets"
pg_restore: creating TABLE "magic.cards"
pg_restore: creating TABLE "magic.sets"
pg_restore: creating TABLE "moma.artist"
pg_restore: creating TABLE "moma.audit"
pg_restore: creating TABLE "opendata.archives_planete"
pg_restore: creating TABLE "public.access_log"
pg_restore: creating TABLE "public.cities"
pg_restore: creating TABLE "public.factbook"
pg_restore: creating TABLE "public.hashtag"
pg_restore: creating TABLE "public.hello"
pg_restore: creating TABLE "public.pubnames"
pg_restore: creating TABLE "public.rate"
pg_restore: creating TABLE "public.rates"
pg_restore: creating TABLE "public.tweet"
pg_restore: creating TABLE "raw.admin1"
pg_restore: creating TABLE "raw.admin2"
pg_restore: creating TABLE "raw.country"
pg_restore: creating TABLE "raw.feature"
pg_restore: creating TABLE "raw.geonames"
pg_restore: creating TABLE "raw.rates"
pg_restore: creating TABLE "sample.geonames"
pg_restore: creating TABLE "sandbox.article"
pg_restore: creating SEQUENCE "sandbox.article_id_seq"
pg_restore: creating SEQUENCE OWNED BY "sandbox.article_id_seq"
pg_restore: creating TABLE "sandbox.category"
pg_restore: creating SEQUENCE "sandbox.category_id_seq"
pg_restore: creating SEQUENCE OWNED BY "sandbox.category_id_seq"
pg_restore: creating TABLE "sandbox.comment"
pg_restore: creating SEQUENCE "sandbox.comment_id_seq"
pg_restore: creating SEQUENCE OWNED BY "sandbox.comment_id_seq"
pg_restore: creating TABLE "sandbox.lorem"
pg_restore: creating VIEW "tweet.message_with_counters"
pg_restore: creating MATERIALIZED VIEW "twcache.message"
pg_restore: creating TABLE "tweet.activity"
pg_restore: creating SEQUENCE "tweet.activity_id_seq"
pg_restore: creating SEQUENCE OWNED BY "tweet.activity_id_seq"
pg_restore: creating TABLE "tweet.follower"
pg_restore: creating TABLE "tweet.list"
pg_restore: creating SEQUENCE "tweet.list_listid_seq"
pg_restore: creating SEQUENCE OWNED BY "tweet.list_listid_seq"
pg_restore: creating TABLE "tweet.membership"
pg_restore: creating TABLE "tweet.message"
pg_restore: creating SEQUENCE "tweet.message_messageid_seq"
pg_restore: creating SEQUENCE OWNED BY "tweet.message_messageid_seq"
pg_restore: creating TABLE "tweet.uniques"
pg_restore: creating TABLE "tweet.users"
pg_restore: creating SEQUENCE "tweet.users_userid_seq"
pg_restore: creating SEQUENCE OWNED BY "tweet.users_userid_seq"
pg_restore: creating TABLE "tweet.visitor"
pg_restore: creating SEQUENCE "tweet.visitors_id_seq"
pg_restore: creating SEQUENCE OWNED BY "tweet.visitors_id_seq"
pg_restore: creating DEFAULT "chinook.color id"
pg_restore: creating DEFAULT "eav.customer id"
pg_restore: creating DEFAULT "eav.support_contract id"
pg_restore: creating DEFAULT "eav.support_contract_type id"
pg_restore: creating DEFAULT "f1db.circuits circuitid"
pg_restore: creating DEFAULT "f1db.constructorresults constructorresultsid"
pg_restore: creating DEFAULT "f1db.constructors constructorid"
pg_restore: creating DEFAULT "f1db.constructorstandings constructorstandingsid"
pg_restore: creating DEFAULT "f1db.drivers driverid"
pg_restore: creating DEFAULT "f1db.driverstandings driverstandingsid"
pg_restore: creating DEFAULT "f1db.qualifying qualifyid"
pg_restore: creating DEFAULT "f1db.races raceid"
pg_restore: creating DEFAULT "f1db.results resultid"
pg_restore: creating DEFAULT "f1db.status statusid"
pg_restore: creating DEFAULT "lastfm.tags rowid"
pg_restore: creating DEFAULT "lastfm.tids rowid"
pg_restore: creating DEFAULT "sandbox.article id"
pg_restore: creating DEFAULT "sandbox.category id"
pg_restore: creating DEFAULT "sandbox.comment id"
pg_restore: creating DEFAULT "tweet.activity id"
pg_restore: creating DEFAULT "tweet.list listid"
pg_restore: creating DEFAULT "tweet.message messageid"
pg_restore: creating DEFAULT "tweet.users userid"
pg_restore: creating DEFAULT "tweet.visitor id"
make: *** [Makefile:8: restore] Segmentation fault (core dumped)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment