Re: backing and restoring whole database server - how does this script look

Tom Lane wrote:
> Peter Koczan <pjkoczan(at)gmail(dot)com> writes:
>
>> On Fri, Apr 10, 2009 at 4:34 AM, Kevin Bailey
>> <kbailey(at)freewayprojects(dot)com> wrote:
>>
>>> Just to make thigs more interesting, we have to do this for a version 8.1
>>> server and an older 7.4 server which has blobs in it.
>>>
>
>
>> If I remember correctly, pg_dumpall only allows text format dumps, and
>> blobs need to be dumped in non-text formats. This might have changed
>> since 7.4, but I couldn't find any source either way.
>>
>
> The 8.1 release notes quoth:
>
> Allow pg_dump to dump large objects even in text mode (Tom)
>
> With this change, large objects are now always dumped; the former -b switch is a no-op.
>
> so in that version and up you can use pg_dumpall without worrying about
> blobs. The upthread proposal of separately dumping each database in
> -Fc mode is probably the only solution in 7.4, but you ought to be
> thinking about how to get off 7.4 not how to perpetuate it. We'll be
> dropping support for 7.4 RSN.
>
> regards, tom lane
>
>
This is still giving out plenty of error messages - BTW - both servers
are on 8.1

time PG_dumpall --inserts --clean -h $REMOTE -U admin | psql -U postgres
template1

Will reply with the error messages after the cron job has run in an hour
or so.

Regards,

bailey86