Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rO2M1-000fjB-EF for pgsql-admin@arkaria.postgresql.org; Thu, 11 Jan 2024 21:12:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rO2M0-00EyE7-D7 for pgsql-admin@arkaria.postgresql.org; Thu, 11 Jan 2024 21:12:44 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rO2M0-00EyDv-2u; Thu, 11 Jan 2024 21:12:44 +0000 Received: from mail-ot1-x32b.google.com ([2607:f8b0:4864:20::32b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rO2Lx-0014ox-5n; Thu, 11 Jan 2024 21:12:43 +0000 Received: by mail-ot1-x32b.google.com with SMTP id 46e09a7af769-6de95fd8767so771085a34.2; Thu, 11 Jan 2024 13:12:40 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1705007559; x=1705612359; darn=lists.postgresql.org; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=TbGKfYliqLW93plSO0t+mzuOOcvQc9jju/QjHZNpJKU=; b=Z9wKVYgT02eWQ6WAUj1/WBLevpOq+/A7oGb5ri88EUpxFnVtuD2VYRxHH0b7SRt6of frHAhJGxDA7c2RY9hguMCYuEiHIdeOC8kyfDCiQiCuHM8L16olwBZAtDa+QD/W1NRvUb Puj9SGCKmwrBHlps+9rU0JCIWFLSPVg83jueu79vzV0Q1fW3/xq+SGifpX/Q6lQebwoQ 5Aokd0gp7X+UyOs/mzf5JaU35iFNRhS/b5p1yhuJyvs4XVvxAiFvLXL+OMjcSRnB7sde ED4vUF1F4MLtPNkI2ny2GpNIJ1X/uX6nmr4+H2gVZigX6xLqcCoxJ+pNI6nw2G71gDzZ iBOA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1705007559; x=1705612359; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=TbGKfYliqLW93plSO0t+mzuOOcvQc9jju/QjHZNpJKU=; b=AyyOQbHEtaH4JRGR0tmLyJFMmu9CFWCK4LolXmgXS74l/7wdtfhL+f27+o7iaN4q46 ovufGBmFkTpUNLaNeAX74t2yewO2qC0TOrkTCOcMFfyOWR907iT3YThadNXl5mKhLiUI Db3pLkSjxdNQb+fczJeTPNtB+t2ydhmsftXzkkgfPUsKqinKCDzlzesIj1nzbDVoYjSV /hpvQerFeKH4oLCnEdIBXfnyhrupmdJT5WIebY67tsWQ2M7DvD1bQR/mBpQu4Bi5M95l nFqxRuv6Tl9uwbXfMalFFaMdZ6Rqz/yUIBieCuOKk6IyF2dy16HG7ouIlROGxXzfGXnX kuMg== X-Gm-Message-State: AOJu0YzAMuL9Q0nWNgh1UA2YSEH5bZ37Mt/rxPPzzZMyMyRa3kEix6Db yqjNmhMXd2uYT3FGJmkgvwE6LyZSsW0= X-Google-Smtp-Source: AGHT+IHdABb8H9msh9HkcyhGcdcMkmdZ7H0Sz5886xSc9M8aL5GfZdeARRxdIx7E9KTyNosggq07gQ== X-Received: by 2002:a05:6830:32aa:b0:6dd:e0b1:d712 with SMTP id m42-20020a05683032aa00b006dde0b1d712mr425361ott.21.1705007559123; Thu, 11 Jan 2024 13:12:39 -0800 (PST) Received: from smtpclient.apple ([2601:3cb:600:e330:7932:f41b:ef8:45bb]) by smtp.gmail.com with ESMTPSA id di7-20020a0568303a0700b006ddde2e3b5fsm308482otb.36.2024.01.11.13.12.37 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 11 Jan 2024 13:12:38 -0800 (PST) Content-Type: multipart/alternative; boundary=Apple-Mail-D86DEA5B-FF66-4F9E-B6D2-93A823C490A6 Content-Transfer-Encoding: 7bit From: Andrew Wang Mime-Version: 1.0 (1.0) Subject: Re: Test mail for pgsql-admin Date: Thu, 11 Jan 2024 15:12:27 -0600 Message-Id: References: Cc: Rajesh Kumar , pgsql-admin Owner , Pgsql-admin In-Reply-To: To: Ron Johnson X-Mailer: iPhone Mail (21B101) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail-D86DEA5B-FF66-4F9E-B6D2-93A823C490A6 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable They were separated. The source list in Ubu= ntu 18 was moved because the 16 is different from former versions, which cau= sed the problem, as I upgraded the Linux system before, it worked very well.=

I tried to install the 15 and 16, but the configuration c= omplained ports and other things. Any way to dump all into a format from ano= ther computer and then read them into the new 16?
Best,



On Jan 11, 2024, at 2:28=E2=80=AF= PM, Ron Johnson <ronljohnsonjr@gmail.com> wrote:

<= /div>
=EF=BB=BF
"I assumed they can merged into 16 but they were not after up= grading my system."

Yeah... that's a pr= etty unfounded assumption.

Fortunately, your data <= b>might be salvageable, if the new system has separate -- and p= opulated -- directories for 12, 13 and 14.  Were any of the source syst= em Postgresql instances running when you ran rsync?

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

On Thu, Jan 11, 2024 at 3:11=E2=80=AF= PM Andrew Wang <andrew.wang= .2009@gmail.com> wrote:
I used =E2=80=9Crsync=E2=80=9D in Linux to ba= ckup 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 mer= ged into 16 but they were not after upgrading my system.
Best,

<= /div>


On J= an 11, 2024, at 1:46=E2=80=AFPM, Rajesh Kumar <rajeshkumar.dba09@gmail.com> w= rote:

=EF= =BB=BF
Did you take basebackup? 

On Fri, 12 Jan 2024, 00:= 55 Ron Johnson, <ronljohnsonjr@gmail.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=E2= =80=AFPM Andrew Wang <andrew.wang.2009@gmail.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 hit= s from your web as detailed below. Could you provide a tip for that?Thanks. R= egards
Your search for restore data from /var/lib/pgsql/ returned no hits.

Andrew
On Thu, Ja= n 11, 2024 at 11:35=E2=80=AFAM pgsql-admin Owner <pgsq= l-admin-owner@lists.postgresql.org> wrote:
Hello!

This is a test mail for the list

pgsql-admin@lists.postgresql.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
= --Apple-Mail-D86DEA5B-FF66-4F9E-B6D2-93A823C490A6--