From: Andrew Wang <andrew.wang.2009@gmail.com>
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
Cc: pgsql-admin Owner <pgsql-admin-owner@lists.postgresql.org>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Test mail for pgsql-admin
Date: Thu, 11 Jan 2024 15:12:27 -0600
Message-ID: <A248CBC8-BBB2-44E4-B9F1-408D258D67B4@gmail.com> (raw)
In-Reply-To: <CANzqJaC3vDu7=TVOBxbA16+7FTYF=JMUaLa_R0ryP=p_kr570A@mail.gmail.com>
References: <CANzqJaC3vDu7=TVOBxbA16+7FTYF=JMUaLa_R0ryP=p_kr570A@mail.gmail.com>
--Apple-Mail-D86DEA5B-FF66-4F9E-B6D2-93A823C490A6
Content-Type: text/html;
charset=utf-8
Content-Transfer-Encoding: quoted-printable
<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto">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.=
<div><br></div><div>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?<br id=3D"lineBreakAtBeginn=
ingOfSignature"><div dir=3D"ltr">Best,<div><br></div><div><br></div></div><d=
iv dir=3D"ltr"><br><blockquote type=3D"cite">On Jan 11, 2024, at 2:28=E2=80=AF=
PM, Ron Johnson <ronljohnsonjr@gmail.com> wrote:<br><br></blockquote><=
/div><blockquote type=3D"cite"><div dir=3D"ltr">=EF=BB=BF<div dir=3D"ltr"><d=
iv dir=3D"ltr">"I assumed they can merged into 16 but they were not after up=
grading my system."</div><div dir=3D"ltr"><br></div><div>Yeah... that's a pr=
etty unfounded assumption.</div><div><br></div><div>Fortunately, your data <=
b>might</b> 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?</div><div><br></div><div=
>If not, then you can install the old versions of Postgresql in parallel wit=
h 16, and then run pg_upgrade.</div><div><br></div><div class=3D"gmail_quote=
"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, Jan 11, 2024 at 3:11=E2=80=AF=
PM Andrew Wang <<a href=3D"mailto:andrew.wang.2009@gmail.com">andrew.wang=
.2009@gmail.com</a>> wrote:<br></div><blockquote class=3D"gmail_quote" st=
yle=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);paddi=
ng-left:1ex"><div dir=3D"auto">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.<br id=3D"m_81271206=
06864866439lineBreakAtBeginningOfSignature"><div dir=3D"ltr">Best,<div><br><=
/div><div><br></div></div><div dir=3D"ltr"><br><blockquote type=3D"cite">On J=
an 11, 2024, at 1:46=E2=80=AFPM, Rajesh Kumar <<a href=3D"mailto:rajeshku=
mar.dba09@gmail.com" target=3D"_blank">rajeshkumar.dba09@gmail.com</a>> w=
rote:<br><br></blockquote></div><blockquote type=3D"cite"><div dir=3D"ltr">=EF=
=BB=BF<div dir=3D"auto">Did you take basebackup? </div><br><div class=3D=
"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Fri, 12 Jan 2024, 00:=
55 Ron Johnson, <<a href=3D"mailto:ronljohnsonjr@gmail.com" target=3D"_bl=
ank">ronljohnsonjr@gmail.com</a>> wrote:<br></div><blockquote class=3D"gm=
ail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,2=
04,204);padding-left:1ex"><div dir=3D"ltr"><div>1. What is the source of the=
data that you copied to <strong>/var/lib/pgsql/15/main</strong>?</div>=
<div>2. What errors or problems are you having?</div><br><div class=3D"gmail=
_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, Jan 11, 2024 at 12:43=E2=
=80=AFPM Andrew Wang <<a href=3D"mailto:andrew.wang.2009@gmail.com" rel=3D=
"noreferrer" target=3D"_blank">andrew.wang.2009@gmail.com</a>> wrote:<br>=
</div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bo=
rder-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div=
>Dear staff at pqsql,</div><div> I try to <strong>restore all data from=
/var/lib/pgsql/15/main,</strong> 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</div><div>Your search for <strong>restore data from /var/lib/pgsql/</=
strong> returned no hits.</div><div><br></div><div>Andrew<br></div></div><br=
><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, Ja=
n 11, 2024 at 11:35=E2=80=AFAM pgsql-admin Owner <<a href=3D"mailto:pgsql=
-admin-owner@lists.postgresql.org" rel=3D"noreferrer" target=3D"_blank">pgsq=
l-admin-owner@lists.postgresql.org</a>> wrote:<br></div><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb=
(204,204,204);padding-left:1ex">Hello!<br>
<br>
This is a test mail for the list<br>
<br>
<a href=3D"mailto:pgsql-admin@lists.postgresql.org" rel=3D"noreferrer" targe=
t=3D"_blank">pgsql-admin@lists.postgresql.org</a><br>
<br>
as requested. The mail has the same list-id header<br>
as email delivered to the list, and can be used to<br>
for example test local mail filters.<br>
</blockquote></div><br clear=3D"all"><br><span class=3D"gmail_signature_pref=
ix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr=
"><div>Best, <br></div><div><br>Andrew Wang</div></div></div>
</blockquote></div></div>
</blockquote></div>
</div></blockquote></div></blockquote></div></div>
</div></blockquote></div></body></html>=
--Apple-Mail-D86DEA5B-FF66-4F9E-B6D2-93A823C490A6--
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: andrew.wang.2009@gmail.com, ronljohnsonjr@gmail.com, rajeshkumar.dba09@gmail.com, pgsql-admin-owner@lists.postgresql.org, pgsql-admin@lists.postgresql.org
Subject: Re: Test mail for pgsql-admin
In-Reply-To: <A248CBC8-BBB2-44E4-B9F1-408D258D67B4@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox