I did that with Postgres 8.1 backup file on 9.0 database. I got continuous error messages like "Can not execute the command...". Well, I do not need worry about it for I am going to back up 8.1 database using 9.0 pg_dump command.
Let's see how it goes. Thanks, On Sat, Apr 16, 2011 at 5:17 PM, Raymond O'Donnell <[email protected]> wrote: > On 16/04/2011 22:07, Edison So wrote: > >> Oh yeah. >> Forgot to mention that Postgres 9.0 does not have an option to restore >> text based back up file. Do you know how? >> > > Surely: > > psql -f <dump file> <database name> > > Ray. > > -- > Raymond O'Donnell :: Galway :: Ireland > [email protected] > -- Edison
