how to copy data between machines ?
| От | D.C. |
|---|---|
| Тема | how to copy data between machines ? |
| Дата | |
| Msg-id | 097c619fcaf710a8d70c100c2d453378@yahoo.fr обсуждение |
| Ответы |
Re: how to copy data between machines ?
Re: how to copy data between machines ? Re: how to copy data between machines ? Re: how to copy data between machines ? |
| Список | pgsql-novice |
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.
В списке pgsql-novice по дате отправления: