Re: Stuck (again) trying to move a 7.x app and database to 8.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: howard(at)yankeescientific(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Stuck (again) trying to move a 7.x app and database to 8.2
Date: 2007-06-15 21:06:00
Message-ID: 22357.1181941560@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Guillaume Yziquel 2007-06-16 23:28:41 Connecting to the database via TCP/IP
Previous Message Howard Eglowstein 2007-06-15 18:07:31 Stuck (again) trying to move a 7.x app and database to 8.2