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 1rO1PO-000WC4-A6 for pgsql-admin@arkaria.postgresql.org; Thu, 11 Jan 2024 20:12:10 +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 1rO1PN-00EXZi-37 for pgsql-admin@arkaria.postgresql.org; Thu, 11 Jan 2024 20:12:09 +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 1rO1PM-00EXZV-OG; Thu, 11 Jan 2024 20:12:08 +0000 Received: from mail-yw1-x112a.google.com ([2607:f8b0:4864:20::112a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rO1PF-0014P7-6q; Thu, 11 Jan 2024 20:12:07 +0000 Received: by mail-yw1-x112a.google.com with SMTP id 00721157ae682-5e7c1012a42so54476997b3.3; Thu, 11 Jan 2024 12:12:00 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1705003918; x=1705608718; 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=bLeo5FHWm6IH0C7/gLeN2OyLZKT7hWhfVFLx+dJ83x4=; b=Na/uVRrZlguDDHGJmZw0Qq8lt2rrWWq1lLXj5sB4iM0DM2y5xZKY129jJ9yWYoRKRz k/IndGKrR0Lp+PjmdGOZRByYL1VP4mFArqJlzSCsfS1e0vklqRZt2ZavYto+KFauQ7Rb 4HNS9MaTXhCj3dFps8bC4jrbow+y6905iOQ4Vblm2HhFvZS0XWbs5eIvyLFvZNedrtZF K16w+OhSfziDUZk5IqEgxnwFJZrcq4psm3cr6Y4uIa4bDi5rH4ScB4b0idYImpWO99ab 8O4ugzt+Gm6phRAEIMD2xkbcjtwSt/wlA/remq9gZJuB2g4aLW/4p2QxYfS/K9VEZ1++ LglA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1705003918; x=1705608718; 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=bLeo5FHWm6IH0C7/gLeN2OyLZKT7hWhfVFLx+dJ83x4=; b=gx8duF92lSKxnsYUQrmme+aMLqfGBpjwhnUHkm7CsXX7S/NnsVx2Vie5ZmNumZksQI l09jEdSubUhKomMfw38fBfYCcp8sIgs7D1nyI46evPUk1msIQKgl1VYTROsi77rW5qNp 1u+rBu8DFlZK1591O5BAx4GNVuA/D1k0sBPxYO9/Ihf+mzJfjmmqPlR0aWAg4+jWWhry ao6K1eCutl7nvRmG97ScDvaJzeMqsLecvjEglfA6oeMv2dPvc+PQnMU10kRYLiXDmQya tkkITxpmC3yervNIJ6UCJilm4u7HV+/lGfdQhbLE9kI7XmVr1Sj6tnjX8smRhtfB+FHS jXDA== X-Gm-Message-State: AOJu0YyMBRmEy5awzd682LW2TiMMXTnt6JnYie49fmp510ldQb4RXjbe lKpfd0VyaPLuIcZWrVEGS5wveyhFl9U= X-Google-Smtp-Source: AGHT+IElBJU3yzRo4m6rbzvsciB+ksjN9DPF/vd7lZL/z9MFk4v97F1rPXx3DY3jml/TZJv061DRYg== X-Received: by 2002:a0d:d6d5:0:b0:5f0:52cf:eee9 with SMTP id y204-20020a0dd6d5000000b005f052cfeee9mr446112ywd.25.1705003918398; Thu, 11 Jan 2024 12:11:58 -0800 (PST) Received: from smtpclient.apple ([2600:100b:b125:ca03:6c13:c047:d4cc:1871]) by smtp.gmail.com with ESMTPSA id bh31-20020a05690c039f00b005fa3dff166fsm667352ywb.129.2024.01.11.12.11.57 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 11 Jan 2024 12:11:58 -0800 (PST) Content-Type: multipart/alternative; boundary=Apple-Mail-926E70D6-CAFD-4A22-AC91-16EE4D9469F4 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 14:11:46 -0600 Message-Id: <879BF30F-6C2A-4F65-AEFD-3B4596E9BB2C@gmail.com> References: Cc: Ron Johnson , pgsql-admin Owner , Pgsql-admin In-Reply-To: To: Rajesh Kumar X-Mailer: iPhone Mail (21B101) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail-926E70D6-CAFD-4A22-AC91-16EE4D9469F4 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable I used =E2=80=9Crsync=E2=80=9D in Linux to b= ackup the the entire directory that contained data for 12,13 and 15. The las= t 15 was gone after upgrading to 16 with Ubuntu 22.04. I assumed they can me= rged into 16 but they were not after upgrading my system.
Best,


=

On Jan 11, 2024, at 1:4= 6=E2=80=AFPM, Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:
=EF=BB=BFDid you take basebackup? 

On Fri, 12 Jan 2024, 00:55 Ron Jo= hnson, <ronljohnsonjr@gmail.co= m> 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 no= t know how and have not found hits from your web as detailed below. Could yo= u provide a tip for that?Thanks. Regards
Your search for r= estore data from /var/lib/pgsql/ returned no hits.

Andrew

On Thu, Jan 11, 2024 at 11:35=E2=80=AFAM pgsql-admin= Owner <pgsql-admin-owner@lists.postgresql.org> w= rote:
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-926E70D6-CAFD-4A22-AC91-16EE4D9469F4--