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 <rod@xxxxxx> wrote:
On 16/04/2011 22:07, Edison So wrote:Surely:
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?
psql -f <dump file> <database name>
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@xxxxxx
--
Edison