Re: Test mail for pgsql-admin

"I assumed they can merged into 16 but they were not after upgrading my
system."

Yeah... that's a pretty unfounded assumption.

Fortunately, your data *might* be salvageable, if the new system has
separate -- and populated -- directories for 12, 13 and 14. Were any of
the source system Postgresql instances running when you ran rsync?

If not, then you can install the old versions of Postgresql in parallel
with 16, and then run pg_upgrade.

On Thu, Jan 11, 2024 at 3:11 PM Andrew Wang <andrew(dot)wang(dot)2009(at)gmail(dot)com>
wrote:

> I used “rsync” in Linux to backup the the entire directory that contained
> data for 12,13 and 15. The last 15 was gone after upgrading to 16 with
> Ubuntu 22.04. I assumed they can merged into 16 but they were not after
> upgrading my system.
> Best,
>
>
>
> On Jan 11, 2024, at 1:46 PM, Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
> wrote:
>
> 
> Did you take basebackup?
>
> On Fri, 12 Jan 2024, 00:55 Ron Johnson, <ronljohnsonjr(at)gmail(dot)com> wrote:
>
>> 1. What is the source of the data that you copied to
>> */var/lib/pgsql/15/main*?
>> 2. What errors or problems are you having?
>>
>> On Thu, Jan 11, 2024 at 12:43 PM Andrew Wang <andrew(dot)wang(dot)2009(at)gmail(dot)com>
>> wrote:
>>
>>> Dear staff at pqsql,
>>> I try to *restore all data from /var/lib/pgsql/15/main,* but do not
>>> know how and have not found hits from your web as detailed below. Could you
>>> provide a tip for that?Thanks. Regards
>>> Your search for *restore data from /var/lib/pgsql/* returned no hits.
>>>
>>> Andrew
>>>
>>> On Thu, Jan 11, 2024 at 11:35 AM pgsql-admin Owner <
>>> pgsql-admin-owner(at)lists(dot)postgresql(dot)org> wrote:
>>>
>>>> Hello!
>>>>
>>>> This is a test mail for the list
>>>>
>>>> pgsql-admin(at)lists(dot)postgresql(dot)org
>>>>
>>>> as requested. The mail has the same list-id header
>>>> as email delivered to the list, and can be used to
>>>> for example test local mail filters.
>>>>
>>>
>>>
>>> --
>>> Best,
>>>
>>> Andrew Wang
>>>
>>