So habe ich das @ gelesDokumentatio aufpg:pull, aber es scheint nicht zu funktionieren. Wenn ich den Befehl mit den richtigen Parametern ausführe, wird meine Heroku-Datenbank abgerufen und eine lokale Datenbank erstellt, das Schema wird jedoch nicht lokal ausgefüllt. Es werden beispielsweise keine Tabellen erstellt, keine Trigger eingerichtet, keine Einschränkungen, keine Daten usw.

Hier ist dieheroku pg:info log für meine Datenbank:

=== HEROKU_POSTGRESQL_ORANGE_URL (DATABASE_URL)
Plan:        Hobby-dev
Status:      Available
Connections: 1
PG Version:  9.3.3
Created:     2014-04-02 19:24 UTC
Data Size:   7.4 MB
Tables:      6
Rows:        1376/10000 (In compliance)
Fork/Follow: Unsupported
Rollback:    Unsupported

Hier ist der Befehl, den ich verwende:

PGUSER=postgres PGPASSWORD=password heroku pg:pull HEROKU_POSTGRESQL_ORANGE mylocaldb --app myappname

Ich konnte nicht herausfinden, wie die Umgebungsvariablen für @ gesetzt werdePGUSER undPGPASSWORD (Wenn jemand mich in die richtige Richtung lenken kann, bekommst du +1. Ich lesediese Frag und Antwort ohne Erfolg).

mylocaldb wird erstellt, aber das Schema ist nicht ausgefüllt.

Hier ist derpg_dump sobald der Befehl ausgeführt wurde:

pg_dump: reading schemas
pg_dump: reading user-defined tables
pg_dump: reading extensions
pg_dump: reading user-defined functions
pg_dump: reading user-defined types
pg_dump: reading procedural languages
pg_dump: reading user-defined aggregate functions
pg_dump: reading user-defined operators
pg_dump: reading user-defined operator classes
pg_dump: reading user-defined operator families
pg_dump: reading user-defined text search parsers
pg_dump: reading user-defined text search templates
pg_dump: reading user-defined text search dictionaries
pg_dump: reading user-defined text search configurations
pg_dump: reading user-defined foreign-data wrappers
pg_dump: reading user-defined foreign servers
pg_dump: reading default privileges
pg_dump: reading user-defined collations
pg_dump: reading user-defined conversions
pg_dump: reading type casts
pg_dump: reading table inheritance information
pg_dump: reading event triggers
pg_dump: finding extension members
pg_dump: finding inheritance relationships
pg_dump: reading column info for interesting tables
pg_dump: finding the columns and types of table "phrases"
pg_dump: finding default expressions of table "phrases"
pg_dump: finding the columns and types of table "users"
pg_dump: finding default expressions of table "users"
pg_dump: finding the columns and types of table "favorite_phrases"
pg_dump: finding the columns and types of table "favorite_users"
pg_dump: finding the columns and types of table "phrasebooks"
pg_dump: finding default expressions of table "phrasebooks"
pg_dump: finding the columns and types of table "phrasebooks_phrases"
pg_dump: flagging inherited columns in subtables
pg_dump: reading indexes
pg_dump: reading indexes for table "phrases"
pg_dump: reading indexes for table "users"
pg_dump: reading indexes for table "favorite_phrases"
pg_dump: reading indexes for table "favorite_users"
pg_dump: reading indexes for table "phrasebooks"
pg_dump: reading indexes for table "phrasebooks_phrases"
pg_dump: reading constraints
pg_dump: reading foreign key constraints for table "phrases"
pg_dump: reading foreign key constraints for table "users"
pg_dump: reading foreign key constraints for table "favorite_phrases"
pg_dump: reading foreign key constraints for table "favorite_users"
pg_dump: reading foreign key constraints for table "phrasebooks"
pg_dump: reading triggers
pg_dump: reading triggers for table "phrases"
pg_dump: reading triggers for table "users"
pg_dump: reading triggers for table "favorite_phrases"
pg_dump: reading triggers for table "favorite_users"
pg_dump: reading triggers for table "phrasebooks"
pg_dump: reading rewrite rules
pg_dump: reading large objects
pg_dump: reading dependency data
pg_dump: saving encoding = UTF8
pg_dump: saving standard_conforming_strings = on
pg_dump: saving database definition
pg_restore: [archiver] did not find magic string in file header
pg_dump: [custom archiver] WARNING: ftell mismatch with expected position -- fte
ll used
pg_dump: [custom archiver] WARNING: ftell mismatch with expected position -- fte
ll used
pg_dump: dumping contents of table favorite_phrases
pg_dump: [custom archiver] WARNING: ftell mismatch with expected position -- fte
ll used
pg_dump: dumping contents of table favorite_users
pg_dump: [custom archiver] WARNING: ftell mismatch with expected position -- fte
ll used
pg_dump: dumping contents of table phrasebooks
pg_dump: [custom archiver] WARNING: ftell mismatch with expected position -- fte
ll used
pg_dump: dumping contents of table phrasebooks_phrases
pg_dump: [custom archiver] WARNING: ftell mismatch with expected position -- fte
ll used
pg_dump: dumping contents of table phrases
pg_dump: [custom archiver] could not write to output file: Invalid argument

Gibt es eine weitere Konfiguration, die ich lokal vornehmen muss, damit dies funktioniert? Wenn es darauf ankommt, verwende ich ein benutzerdefiniertes Stoppwort-Wörterbuch fürtsquery, das (noch) nicht lokal auf diesem Computer eingerichtet ist ... Ich bezweifle, dass dies ein Problem in derpg_dump obwohl ... Jede Hilfe wird sehr geschätzt!

Bearbeite: Ich habe gerade versucht, diesen Befehl auf meinem Desktop auszuführen, der anderen lokalen Station, auf der alles konfiguriert ist. Keine Knochen. Ich erhalte genau die gleichen Ergebnisse. Unten ist die Ausgabe vonwhich psql auf der lokalen Maschine, nur für den Fall:

$ which psql
/c/Program Files/PostgreSQL/9.3/bin/psql