(Please stick to plain text posts, as many readers can't read html or the formatting gets screwy. This is a plain text mailing list in general. Attachments are ok tho) On Tue, May 18, 2010 at 5:14 PM, Tena Sakai <sakaitena@xxxxxxxxx> wrote: > > Hi Everybody, > > I am a bit troubled by pg_dump and pg_restore. My platform is > redhat linux, Del 64 bit hardware, running postgres 8.3.7. > I have a database named canon and I want to move a schema full of > tables from canon to a new database named musket. The schema I > am interested in is called tsakai. Here's what I have done: > > $ env | grep PG > PGUSER=postgres > PGDATABASE=canon > PGHOST=localhost > PGDATA=/usr/local/pgsql/data > $ > $ pg_dump -n tsakai > canon_tsakai.sql > $ > $ echo $? > 0 > $ > $ pg_restore -l canon_tsakai.sql > pg_restore: [archiver] input file does not appear to be a valid archive > $ > $ pg_restore -d musket canon_tsakai.sql > pg_restore: [archiver] input file does not appear to be a valid archive > > Can someone please tell me (1) if there is anything wrong with my invocation > of pd_dump? (I want to generate a file pd_restore can use to feed to > musket database.) (2) Why pg_restore wouldn't give me listing? And (3) > why the second pg_restore command is upset? pg_restore expects custom format from pg_dump. For plain sql files, use psql: psql mydb -f mysql.sql -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
