Re: Stuck (again) trying to move a 7.x app and database to 8.2 - Mailing list pgsql-novice

From Tom Lane
Subject Re: Stuck (again) trying to move a 7.x app and database to 8.2
Date
Msg-id 22357.1181941560@sss.pgh.pa.us
Whole thread Raw
In response to Stuck (again) trying to move a 7.x app and database to 8.2  (Howard Eglowstein <howard@yankeescientific.com>)
List pgsql-novice
Howard Eglowstein <howard@yankeescientific.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

pgsql-novice by date:

Previous
From: Howard Eglowstein
Date:
Subject: Stuck (again) trying to move a 7.x app and database to 8.2
Next
From: Guillaume Yziquel
Date:
Subject: Connecting to the database via TCP/IP