Обсуждение: grant on sequence and pg_restore/pg_dump problem

Поиск
Список
Период
Сортировка

grant on sequence and pg_restore/pg_dump problem

От
Tony Caduto
Дата:
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?

Thanks,

--
Tony


Re: grant on sequence and pg_restore/pg_dump problem

От
Bruce Momjian
Дата:
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@momjian.us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

Re: grant on sequence and pg_restore/pg_dump problem

От
Tony Caduto
Дата:
Bruce Momjian wrote:
> 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.
>
>
So for admin tool vendors, we need to now ship more than one copy of
pg_restore?
Wasn't the restore pretty much backwards compatible until now?
Certainly pg_restore must know what version of the server it's
connecting to, shouldn't it be able to adjust the GRANT ON so on versions
<  8.2 it does not use the SEQUENCE keyword?

Thanks,

--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration


Re: grant on sequence and pg_restore/pg_dump problem

От
Bruce Momjian
Дата:
Tony Caduto wrote:
> Bruce Momjian wrote:
> > 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.
> >
> >
> So for admin tool vendors, we need to now ship more than one copy of
> pg_restore?
> Wasn't the restore pretty much backwards compatible until now?
> Certainly pg_restore must know what version of the server it's
> connecting to, shouldn't it be able to adjust the GRANT ON so on versions
> <  8.2 it does not use the SEQUENCE keyword?

We have never spent time making restore work for all versions, partly
because pg_dump typically dumps as text, and you just feed that into
psql.

--
  Bruce Momjian  <bruce@momjian.us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +