Tony Caduto wrote: > Hi, > I did a quick search and didn't see anything on this, if I missed it > sorry in advance. > Anyway, I was doing a restore of a 8.1 database(on a 8.1 server) using > the 8.2 pg_restore and it was throwing errors when it was trying to > restore the permissions on the sequences. > basically the pg_restore was using the grant on sequence against the 8.1 > database which of course 8.1 knows nothing about. > > Is there a switch or something I missed that would allow this to work > properly on a 8.1 or lower database? > Or do I have to now have 2 versions of dump/restore in order to do this?
You can use 8.2 to dump 8.1, but for restore, you should use the same version as the target database. -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
