Re: Compatible Dumps

From: Jake Stride <nsuk(at)users(dot)sourceforge(dot)net>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Compatible Dumps
Date: 2005-03-03 14:02:39
Message-ID: 422718FF.9040104@users.sourceforge.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Richard Huxton wrote:

> Jake Stride wrote:
>
>> Is there a way to make a postgresql 8 database dump work with 7.4?
>> I.E I want to do a dump from 8.0 on one machine and put it into a
>> database running on 7.4 on another?
>
>
> Haven't tried this yet, but apart from turning off dollar-quoting for
> functions, it should just work. If you want to test it, try a
> schema-only dump+restore first.
>
That helps a bit, but I still have the following issue:

ERROR: function pg_catalog.pg_get_serial_sequence("unknown", "unknown")
does not exist

Any ideas how to get around this?

Thanks

Jake

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-03-03 14:51:06 Re: Compatible Dumps
Previous Message Martijn van Oosterhout 2005-03-03 13:56:55 Re: Does IMMUTABLE have any effect on functions?