From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: grant on sequence and pg_restore/pg_dump problem |
Date: | 2007-02-27 21:08:41 |
Message-ID: | 200702272108.l1RL8fM29649@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
From | Date | Subject | |
---|---|---|---|
Next Message | Goran Rakic | 2007-02-27 21:23:13 | How to Kill IDLE users |
Previous Message | Martijn van Oosterhout | 2007-02-27 20:23:12 | Re: How to use OIDs on tables......OR....a better solution? |