Re: how to copy data between machines ?

At 04:05 PM 5/12/05, D.C. wrote:
>After searching for a while as to how to transfer data from machine to
>machine, I came across the 'pg_dump' and 'pg_restore' commands.
>
>On machine 'A', I did ..
>
>    /usr/local/pgsql/bin/pg_dump test -f /tmp/blah
>
>Then ...
>
>    pg_restore -d test /tmp/test
>
>The result is ...
>
>    pg_restore: [archiver] input file does not appear to be a valid archive
>
>What did I miss ?


You forgot to read the manpage for pg_dump:

        -F format

        --format=format
               t      Output a tar archive suitable for input into
                      pg_restore. Using this archive format allows
                      reordering  and/or  exclusion of schema ele-
                      ments at the time the database is  restored.
                      It  is  also possible to limit which data is
                      reloaded at restore time.