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 <r...@iol.ie> 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 > r...@iol.ie > -- Edison
