Postgres Pro
Downloads
Home   >   mailing lists

Re: how to copy data between machines ? - Mailing list pgsql-novice

From Tom Lane
Subject Re: how to copy data between machines ?
Date
Msg-id 12145.1115929176@sss.pgh.pa.us
Whole thread Raw
In response to how to copy data between machines ?  (D.C. <coughlandesmond@yahoo.fr>)
Responses Re: how to copy data between machines ?  (D.C. <coughlandesmond@yahoo.fr>)
List pgsql-novice
Tree view 
"D.C." <coughlandesmond@yahoo.fr> writes:
> The result is ...
>     pg_restore: [archiver] input file does not appear to be a valid
> archive

> Eh ???

pg_restore is for restoring dumps that you make with the -Fc or -Ft
options to pg_dump.  The default output from pg_dump is a plain sql
script that you just feed to psql.

            regards, tom lane

pgsql-novice by date:

Previous
From: D.C.
Date:
Subject: Re: how to copy data between machines ?
Next
From: Frank Bax
Date:
Subject: Re: how to copy data between machines ?