From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Erwin Moller <erwin(at)darwine(dot)nl>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: pg_dump problems: [archiver (db)] query failed: ERROR: relation "pg_opfamily" does not exist |
Date: | 2019-08-20 15:11:42 |
Message-ID: | 44b31c0c-f287-a844-7b85-4c5559699ac7@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 8/20/19 8:02 AM, Adrian Klaver wrote:
> On 8/20/19 7:37 AM, Erwin Moller wrote:
>>
>> That is a bummer.
>> Since I have no idea how to safely install an older version of pg_dump
>> alongside my current 10.10 install, I will wait for the patch.
>
> A quick test showed that:
>
> 1) Go here:
> https://apt.postgresql.org/pub/repos/apt/pool/main/p/postgresql-11/
>
> 2) Grab
> https://apt.postgresql.org/pub/repos/apt/pool/main/p/postgresql-11/postgresql-client-11_11.4-1.pgdg18.10%2b1_amd64.deb
>
>
> 3) Using Ark extract pg_dump from data.tar.xz at path
> /usr/lib/postgresql/11/bin
Just to be clear I did the above in my home directory so as not to
overwrite the installed programs.
Also probably not a bad idea to rename the below to something like
pg_dump_11_4 to keep things straight.
>
>
> ./pg_dump -V
> pg_dump (PostgreSQL) 11.4 (Ubuntu 11.4-1.pgdg18.10+1)
>
>
> I do not have a 8.1 instance to try against, so I could not test that part.
>
>
>
>>
>> Thank you for your responses!
>>
>> Regards,
>> Erwin Moller
>>
>>
>>
>>
>>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | pabloa98 | 2019-08-20 16:24:09 | Re: SELECT all the rows where id is children of other node. |
Previous Message | Tom Lane | 2019-08-20 15:03:13 | Re: Retroactively adding send and recv functions to a type? |