On 24/06/2013 19:20, "Bruce Momjian" wrote:
>On Mon, Jun 24, 2013 at 06:03:40PM +, Stuart Ford wrote:
>>
>> Do you know if not running this script would explain the fact that our
>> dump file sizes have been much smaller than expected?
>
>It might be possible if lack of pg_largeobject_meta
On Mon, Jun 24, 2013 at 06:03:40PM +, Stuart Ford wrote:
> On 24/06/2013 17:18, "Bruce Momjian" wrote:
>
>
> >On Mon, Jun 24, 2013 at 03:25:44PM +, Stuart Ford wrote:
> >> On 24/06/2013 14:00, "Bruce Momjian" wrote:
> >>
> >>
> >> >
> >> >Looking further, here is the command that is e
On 24/06/2013 17:18, "Bruce Momjian" wrote:
>On Mon, Jun 24, 2013 at 03:25:44PM +, Stuart Ford wrote:
>> On 24/06/2013 14:00, "Bruce Momjian" wrote:
>>
>>
>> >
>> >Looking further, here is the command that is executed:
>> >
>> >SELECT pg_catalog.lo_create(t.loid)
>> >FROM (SELECT
On Mon, Jun 24, 2013 at 03:25:44PM +, Stuart Ford wrote:
> On 24/06/2013 14:00, "Bruce Momjian" wrote:
>
>
> >
> >Looking further, here is the command that is executed:
> >
> > SELECT pg_catalog.lo_create(t.loid)
> > FROM (SELECT DISTINCT loid FROM pg_catalog.pg_largeobject) AS t;
>
On 24/06/2013 14:00, "Bruce Momjian" wrote:
>
>Looking further, here is the command that is executed:
>
> SELECT pg_catalog.lo_create(t.loid)
> FROM (SELECT DISTINCT loid FROM pg_catalog.pg_largeobject) AS t;
>
>If you have created _new_ large objects since the upgrde, the script
>mi
On Mon, Jun 24, 2013 at 08:51:46AM -0400, Bruce Momjian wrote:
> On Mon, Jun 24, 2013 at 11:13:08AM +, Stuart Ford wrote:
> > Dear community
> >
> > Last week we upgraded our database from 8.4 to 9.1. The upgrade seemed to
> > go fine and the database seems to have been working fine ever since
On Mon, Jun 24, 2013 at 11:13:08AM +, Stuart Ford wrote:
> Dear community
>
> Last week we upgraded our database from 8.4 to 9.1. The upgrade seemed to
> go fine and the database seems to have been working fine ever since
> (around a week now).
>
> However, today I noticed the output from the
Dear community
Last week we upgraded our database from 8.4 to 9.1. The upgrade seemed to
go fine and the database seems to have been working fine ever since
(around a week now).
However, today I noticed the output from the pg_upgrade command contained
the following:
| Your installation contains
