Howard Eglowstein <howard(at)yankeescientific(dot)com> writes:
> 3) I copied the 20070615.tar file over to the new machine and tried
> restoring it with 'pg_restore 20070615.tar'
With no other arguments, that's just going to spew a bunch of SQL on
your screen. You could pipe its output to psql, but it'd probably make
more sense to add the switches to tell it to connect to your new
database and load the data there.
regards, tom lane