Andy Colson <andy@squeakycode.net> writes:
> Having a little problem with my large objects. In 8.4 the db owner was
> 'andy', but my web connected as payuser (which had appropriate permissions).
> The backup/restore to pg9 made all the large objects owned by 'andy',
> and I'm guessing payuser does not have select rights.
If you just want it to work like it did before, I believe there's a server
parameter you can change to disable permissions checks on large objects.
regards, tom lane