From: | Mark Greenbank <mark(dot)greenbank(at)gmail(dot)com> |
---|---|
To: | "D(dot)C(dot)" <coughlandesmond(at)yahoo(dot)fr> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: how to copy data between machines ? |
Date: | 2005-05-12 20:11:23 |
Message-ID: | 4110a4f05051213116cd00818@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I think you need the '-F c' option in pg_dump to make pg_restore
understand the archive.
Mark
On 5/12/05, D.C. <coughlandesmond(at)yahoo(dot)fr> wrote:
>
> Hi folks,
>
> 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 ...
>
> [socrates:/tmp] desmond% ls -l /tmp/blah
> -rw-r--r-- 1 desmond wheel 540 12 May 22:02 /tmp/blah
>
> I then scp that file to machine B, and do ...
>
> pg_restore -d test /tmp/test
>
> The result is ...
>
> pg_restore: [archiver] input file does not appear to be a valid
> archive
>
> Eh ???
>
> What did I miss ?
>
> I'm using the same version of postgreSQL on both machines, both
> installed within minutes of each other.
>
> Thanks in advance.
>
> D.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
From | Date | Subject | |
---|---|---|---|
Next Message | D.C. | 2005-05-12 20:17:37 | Re: how to copy data between machines ? |
Previous Message | D.C. | 2005-05-12 20:10:24 | Re: how to copy data between machines ? |