pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Test mail for pgsql-admin
13+ messages / 5 participants
[nested] [flat]
* Re: Test mail for pgsql-admin
@ 2024-01-11 17:43 Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 19:25 ` Re: Test mail for pgsql-admin Ron Johnson <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 13+ messages in thread
From: Andrew Wang @ 2024-01-11 17:43 UTC (permalink / raw)
To: pgsql-admin Owner <pgsql-admin-owner@lists.postgresql.org>; pgsql-admin@lists.postgresql.org
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@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
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Test mail for pgsql-admin
2024-01-11 17:43 Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
@ 2024-01-11 19:25 ` Ron Johnson <ronljohnsonjr@gmail.com>
2024-01-11 19:46 ` Re: Test mail for pgsql-admin Rajesh Kumar <rajeshkumar.dba09@gmail.com>
0 siblings, 1 reply; 13+ messages in thread
From: Ron Johnson @ 2024-01-11 19:25 UTC (permalink / raw)
To: Andrew Wang <andrew.wang.2009@gmail.com>; +Cc: pgsql-admin Owner <pgsql-admin-owner@lists.postgresql.org>; pgsql-admin@lists.postgresql.org
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.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 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@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
>
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Test mail for pgsql-admin
2024-01-11 17:43 Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 19:25 ` Re: Test mail for pgsql-admin Ron Johnson <ronljohnsonjr@gmail.com>
@ 2024-01-11 19:46 ` Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2024-01-11 20:11 ` Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
0 siblings, 1 reply; 13+ messages in thread
From: Rajesh Kumar @ 2024-01-11 19:46 UTC (permalink / raw)
To: Ron Johnson <ronljohnsonjr@gmail.com>; +Cc: Andrew Wang <andrew.wang.2009@gmail.com>; pgsql-admin Owner <pgsql-admin-owner@lists.postgresql.org>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
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 PM 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 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@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
>>
>
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Test mail for pgsql-admin
2024-01-11 17:43 Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 19:25 ` Re: Test mail for pgsql-admin Ron Johnson <ronljohnsonjr@gmail.com>
2024-01-11 19:46 ` Re: Test mail for pgsql-admin Rajesh Kumar <rajeshkumar.dba09@gmail.com>
@ 2024-01-11 20:11 ` Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 20:28 ` Re: Test mail for pgsql-admin Ron Johnson <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 13+ messages in thread
From: Andrew Wang @ 2024-01-11 20:11 UTC (permalink / raw)
To: Rajesh Kumar <rajeshkumar.dba09@gmail.com>; +Cc: Ron Johnson <ronljohnsonjr@gmail.com>; pgsql-admin Owner <pgsql-admin-owner@lists.postgresql.org>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
--Apple-Mail-926E70D6-CAFD-4A22-AC91-16EE4D9469F4
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">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.<br id=3D"lineBreak=
AtBeginningOfSignature"><div dir=3D"ltr">Best,<div><br></div><div><br></div>=
</div><div dir=3D"ltr"><br><blockquote type=3D"cite">On Jan 11, 2024, at 1:4=
6=E2=80=AFPM, Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:<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_qu=
ote"><div dir=3D"ltr" class=3D"gmail_attr">On Fri, 12 Jan 2024, 00:55 Ron Jo=
hnson, <<a href=3D"mailto:ronljohnsonjr@gmail.com">ronljohnsonjr@gmail.co=
m</a>> wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:=
0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr"><di=
v>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:a=
ndrew.wang.2009@gmail.com" target=3D"_blank" rel=3D"noreferrer">andrew.wang.=
2009@gmail.com</a>> wrote:<br></div><blockquote class=3D"gmail_quote" sty=
le=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);paddin=
g-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 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</div><div>Your search for <strong>r=
estore 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"lt=
r" class=3D"gmail_attr">On Thu, Jan 11, 2024 at 11:35=E2=80=AFAM pgsql-admin=
Owner <<a href=3D"mailto:pgsql-admin-owner@lists.postgresql.org" target=3D=
"_blank" rel=3D"noreferrer">pgsql-admin-owner@lists.postgresql.org</a>> w=
rote:<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" target=3D"_blank" rel=3D=
"noreferrer">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></body></html>=
--Apple-Mail-926E70D6-CAFD-4A22-AC91-16EE4D9469F4--
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Test mail for pgsql-admin
2024-01-11 17:43 Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 19:25 ` Re: Test mail for pgsql-admin Ron Johnson <ronljohnsonjr@gmail.com>
2024-01-11 19:46 ` Re: Test mail for pgsql-admin Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2024-01-11 20:11 ` Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
@ 2024-01-11 20:28 ` Ron Johnson <ronljohnsonjr@gmail.com>
2024-01-11 21:12 ` Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
0 siblings, 1 reply; 13+ messages in thread
From: Ron Johnson @ 2024-01-11 20:28 UTC (permalink / raw)
To: Andrew Wang <andrew.wang.2009@gmail.com>; +Cc: Rajesh Kumar <rajeshkumar.dba09@gmail.com>; pgsql-admin Owner <pgsql-admin-owner@lists.postgresql.org>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
"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.wang.2009@gmail.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.dba09@gmail.com>
> wrote:
>
>
> 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 PM 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 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@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
>>>
>>
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Test mail for pgsql-admin
2024-01-11 17:43 Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 19:25 ` Re: Test mail for pgsql-admin Ron Johnson <ronljohnsonjr@gmail.com>
2024-01-11 19:46 ` Re: Test mail for pgsql-admin Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2024-01-11 20:11 ` Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 20:28 ` Re: Test mail for pgsql-admin Ron Johnson <ronljohnsonjr@gmail.com>
@ 2024-01-11 21:12 ` Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 21:18 ` Re: Test mail for pgsql-admin Holger Jakobs <holger@jakobs.com>
2024-01-11 21:45 ` Re: Test mail for pgsql-admin Ron Johnson <ronljohnsonjr@gmail.com>
0 siblings, 2 replies; 13+ messages in thread
From: Andrew Wang @ 2024-01-11 21:12 UTC (permalink / raw)
To: Ron Johnson <ronljohnsonjr@gmail.com>; +Cc: Rajesh Kumar <rajeshkumar.dba09@gmail.com>; pgsql-admin Owner <pgsql-admin-owner@lists.postgresql.org>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
--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--
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Test mail for pgsql-admin
2024-01-11 17:43 Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 19:25 ` Re: Test mail for pgsql-admin Ron Johnson <ronljohnsonjr@gmail.com>
2024-01-11 19:46 ` Re: Test mail for pgsql-admin Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2024-01-11 20:11 ` Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 20:28 ` Re: Test mail for pgsql-admin Ron Johnson <ronljohnsonjr@gmail.com>
2024-01-11 21:12 ` Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
@ 2024-01-11 21:18 ` Holger Jakobs <holger@jakobs.com>
2024-01-11 21:24 ` Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
1 sibling, 1 reply; 13+ messages in thread
From: Holger Jakobs @ 2024-01-11 21:18 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
You can always dump the contents of a running instance (called cluster)
using pg_dumpall creating a text file with SQL commands, which can be
fed subsequently into any empty, but running installation of the same or
more recent version of the server using psql.
What isn't possible is getting a corrupted copy of the data directory
back to life.
Unless you took the copy while the database server was completely down,
regard it unusable.
If the copy isn't corrupt, you can start it on the same architecture
with the same major version of the software again using pg_ctl. Look at
the help of the program for details.
When the database system is running again, take a dump with pg_dumpall.
Am 11.01.24 um 22:12 schrieb Andrew Wang:
> They were separated. The source list in Ubuntu 18 was moved because
> the 16 is different from former versions, which caused the problem, as
> I upgraded the Linux system before, it worked very well.
>
> I tried to install the 15 and 16, but the configuration complained
> ports and other things. Any way to dump all into a format from another
> computer and then read them into the new 16?
> Best,
>
>
>
>> On Jan 11, 2024, at 2:28 PM, Ron Johnson <ronljohnsonjr@gmail.com> wrote:
>>
>>
>> "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.wang.2009@gmail.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.dba09@gmail.com> wrote:
>>>
>>>
>>> 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 PM 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 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@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
>>>
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
Attachments:
[application/pgp-signature] OpenPGP_signature (202B, ../../383812ba-230f-9d66-cebe-dd02c4c4f210@jakobs.com/3-OpenPGP_signature)
download
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Test mail for pgsql-admin
2024-01-11 17:43 Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 19:25 ` Re: Test mail for pgsql-admin Ron Johnson <ronljohnsonjr@gmail.com>
2024-01-11 19:46 ` Re: Test mail for pgsql-admin Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2024-01-11 20:11 ` Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 20:28 ` Re: Test mail for pgsql-admin Ron Johnson <ronljohnsonjr@gmail.com>
2024-01-11 21:12 ` Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 21:18 ` Re: Test mail for pgsql-admin Holger Jakobs <holger@jakobs.com>
@ 2024-01-11 21:24 ` Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 21:26 ` Re: Test mail for pgsql-admin Holger Jakobs <holger@jakobs.com>
0 siblings, 1 reply; 13+ messages in thread
From: Andrew Wang @ 2024-01-11 21:24 UTC (permalink / raw)
To: Holger Jakobs <holger@jakobs.com>; +Cc: pgsql-admin@lists.postgresql.org
--Apple-Mail-B8A6436E-B900-40D7-B508-1942CE6910DC
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">These files were backed up to another Linux=
system. Is it possible to convert it into a program readable format? I can w=
rite a script in most languages to read them.<br id=3D"lineBreakAtBeginningO=
fSignature"><div dir=3D"ltr">Best,<div><br></div><div><br></div></div><div d=
ir=3D"ltr"><br><blockquote type=3D"cite">On Jan 11, 2024, at 3:18=E2=80=AFPM=
, Holger Jakobs <holger@jakobs.com> wrote:<br><br></blockquote></div><=
blockquote type=3D"cite"><div dir=3D"ltr">=EF=BB=BF
=20
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DUTF-8"=
>
=20
=20
<p>You can always dump the contents of a running instance (called
cluster) using pg_dumpall creating a text file with SQL commands,
which can be fed subsequently into any empty, but running
installation of the same or more recent version of the server
using psql.</p>
<p>What isn't possible is getting a corrupted copy of the data
directory back to life.</p>
<p>Unless you took the copy while the database server was completely
down, regard it unusable.</p>
<p>If the copy isn't corrupt, you can start it on the same
architecture with the same major version of the software again
using pg_ctl. Look at the help of the program for details.</p>
<p>When the database system is running again, take a dump with
pg_dumpall.<br>
</p>
<div class=3D"moz-cite-prefix">Am 11.01.24 um 22:12 schrieb Andrew
Wang:<br>
</div>
<blockquote type=3D"cite" cite=3D"mid:A248CBC8-BBB2-44E4-B9F1-408D258D67=
B4@gmail.com">
<meta http-equiv=3D"content-type" content=3D"text/html; charset=3DUTF-=
8">
They were separated. The source list in Ubuntu 18 was moved
because the 16 is different from former versions, which caused 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
complained ports and other things. Any way to dump all into a
format from another computer and then read them into the new 16?<br i=
d=3D"lineBreakAtBeginningOfSignature">
<div dir=3D"ltr">Best,
<div><br>
</div>
<div><br>
</div>
</div>
<div dir=3D"ltr"><br>
<blockquote type=3D"cite">On Jan 11, 2024, at 2:28=E2=80=AFPM, Ron=
Johnson <a class=3D"moz-txt-link-rfc2396E" href=3D"mailto:ronljo=
hnsonjr@gmail.com"><ronljohnsonjr@gmail.com></a> wrote:<br>
<br>
</blockquote>
</div>
<blockquote type=3D"cite">
<div dir=3D"ltr">=EF=BB=BF
<div dir=3D"ltr">
<div dir=3D"ltr">"I assumed they can merged into 16 but they
were not after upgrading my system."</div>
<div dir=3D"ltr"><br>
</div>
<div>Yeah... that's a pretty unfounded assumption.</div>
<div><br>
</div>
<div>Fortunately, your data <b>might</b> 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?</div=
>
<div><br>
</div>
<div>If not, then you can install the old versions of
Postgresql in parallel with 16, and then run pg_upgrade.</di=
v>
<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=AFPM Andrew Wang <<a href=3D"mailto:andre=
w.wang.2009@gmail.com" moz-do-not-send=3D"true" class=3D"moz-txt-link-freete=
xt">andrew.wang.2009@gmail.com</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">
<div dir=3D"auto">I used =E2=80=9Crsync=E2=80=9D in Linux t=
o 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.<br id=3D"m_=
8127120606864866439lineBreakAtBeginningOfSignature">
<div dir=3D"ltr">Best,
<div><br>
</div>
<div><br>
</div>
</div>
<div dir=3D"ltr"><br>
<blockquote type=3D"cite">On Jan 11, 2024, at
1:46=E2=80=AFPM, Rajesh Kumar <<a href=3D"mailto:=
rajeshkumar.dba09@gmail.com" target=3D"_blank" moz-do-not-send=3D"true" clas=
s=3D"moz-txt-link-freetext">rajeshkumar.dba09@gmail.com</a>>
wrote:<br>
<br>
</blockquote>
</div>
<blockquote type=3D"cite">
<div dir=3D"ltr">=EF=BB=BF
<div dir=3D"auto">Did you take basebackup? </di=
v>
<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"mail=
to:ronljohnsonjr@gmail.com" target=3D"_blank" moz-do-not-send=3D"true" class=
=3D"moz-txt-link-freetext">ronljohnsonjr@gmail.com</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">
<div dir=3D"ltr">
<div>1. What is the source of the data
that you copied to <strong>/var/lib/pgs=
ql/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 Andr=
ew
Wang <<a href=3D"mailto:andrew.wang.200=
9@gmail.com" rel=3D"noreferrer" target=3D"_blank" moz-do-not-send=3D"true" c=
lass=3D"moz-txt-link-freetext">andrew.wang.2009@gmail.com</a>>
wrote:<br>
</div>
<blockquote class=3D"gmail_quote" style=3D"m=
argin:0px 0px 0px
0.8ex;border-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 hits from your web as
detailed below. Could you provide
a tip for that?Thanks. Regards</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, Jan 11, 2024 at 11:35=E2=80=AFAM
pgsql-admin Owner <<a href=3D"mailt=
o:pgsql-admin-owner@lists.postgresql.org" rel=3D"noreferrer" target=3D"_blan=
k" moz-do-not-send=3D"true" class=3D"moz-txt-link-freetext">pgsql-admin-owne=
r@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">Hel=
lo!<br>
<br>
This is a test mail for the list<br>
<br>
<a href=3D"mailto:pgsql-admin@lists.po=
stgresql.org" rel=3D"noreferrer" target=3D"_blank" moz-do-not-send=3D"true" c=
lass=3D"moz-txt-link-freetext">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_prefix">--
</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>
</blockquote>
<pre class=3D"moz-signature" cols=3D"72">--=20
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012</pre>
=20
</div></blockquote></body></html>=
--Apple-Mail-B8A6436E-B900-40D7-B508-1942CE6910DC--
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Test mail for pgsql-admin
2024-01-11 17:43 Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 19:25 ` Re: Test mail for pgsql-admin Ron Johnson <ronljohnsonjr@gmail.com>
2024-01-11 19:46 ` Re: Test mail for pgsql-admin Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2024-01-11 20:11 ` Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 20:28 ` Re: Test mail for pgsql-admin Ron Johnson <ronljohnsonjr@gmail.com>
2024-01-11 21:12 ` Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 21:18 ` Re: Test mail for pgsql-admin Holger Jakobs <holger@jakobs.com>
2024-01-11 21:24 ` Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
@ 2024-01-11 21:26 ` Holger Jakobs <holger@jakobs.com>
2024-01-11 21:31 ` Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
0 siblings, 1 reply; 13+ messages in thread
From: Holger Jakobs @ 2024-01-11 21:26 UTC (permalink / raw)
To: Andrew Wang <andrew.wang.2009@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
Unless you read all of the PostgreSQL source code and mimic its
behaviour, I regard this impossible. Those files from the DATA directory
aren't simple CSV files or similar.
Am 11.01.24 um 22:24 schrieb Andrew Wang:
> These files were backed up to another Linux system. Is it possible to
> convert it into a program readable format? I can write a script in
> most languages to read them.
> Best,
>
>
>
>> On Jan 11, 2024, at 3:18 PM, Holger Jakobs <holger@jakobs.com> wrote:
>>
>>
>>
>> You can always dump the contents of a running instance (called
>> cluster) using pg_dumpall creating a text file with SQL commands,
>> which can be fed subsequently into any empty, but running
>> installation of the same or more recent version of the server using psql.
>>
>> What isn't possible is getting a corrupted copy of the data directory
>> back to life.
>>
>> Unless you took the copy while the database server was completely
>> down, regard it unusable.
>>
>> If the copy isn't corrupt, you can start it on the same architecture
>> with the same major version of the software again using pg_ctl. Look
>> at the help of the program for details.
>>
>> When the database system is running again, take a dump with pg_dumpall.
>>
>> Am 11.01.24 um 22:12 schrieb Andrew Wang:
>>> They were separated. The source list in Ubuntu 18 was moved because
>>> the 16 is different from former versions, which caused the problem,
>>> as I upgraded the Linux system before, it worked very well.
>>>
>>> I tried to install the 15 and 16, but the configuration complained
>>> ports and other things. Any way to dump all into a format from
>>> another computer and then read them into the new 16?
>>> Best,
>>>
>>>
>>>
>>>> On Jan 11, 2024, at 2:28 PM, Ron Johnson <ronljohnsonjr@gmail.com>
>>>> wrote:
>>>>
>>>>
>>>> "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.wang.2009@gmail.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.dba09@gmail.com> wrote:
>>>>>
>>>>>
>>>>> 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 PM 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 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@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
>>>>>
>> --
>> Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
Attachments:
[application/pgp-signature] OpenPGP_signature (202B, ../../983811fd-e0ad-5606-ce9e-3110f73feaec@jakobs.com/3-OpenPGP_signature)
download
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Test mail for pgsql-admin
2024-01-11 17:43 Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 19:25 ` Re: Test mail for pgsql-admin Ron Johnson <ronljohnsonjr@gmail.com>
2024-01-11 19:46 ` Re: Test mail for pgsql-admin Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2024-01-11 20:11 ` Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 20:28 ` Re: Test mail for pgsql-admin Ron Johnson <ronljohnsonjr@gmail.com>
2024-01-11 21:12 ` Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 21:18 ` Re: Test mail for pgsql-admin Holger Jakobs <holger@jakobs.com>
2024-01-11 21:24 ` Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 21:26 ` Re: Test mail for pgsql-admin Holger Jakobs <holger@jakobs.com>
@ 2024-01-11 21:31 ` Andrew Wang <andrew.wang.2009@gmail.com>
0 siblings, 0 replies; 13+ messages in thread
From: Andrew Wang @ 2024-01-11 21:31 UTC (permalink / raw)
To: Holger Jakobs <holger@jakobs.com>; +Cc: pgsql-admin@lists.postgresql.org
--Apple-Mail-6535AB43-4703-40AE-B1D4-B3B391EF3B95
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">Okay thanks <br id=3D"lineBreakAtBegin=
ningOfSignature"><div dir=3D"ltr">Best,<div><br></div><div><br></div></div><=
div dir=3D"ltr"><br><blockquote type=3D"cite">On Jan 11, 2024, at 3:26=E2=80=
=AFPM, Holger Jakobs <holger@jakobs.com> wrote:<br><br></blockquote></=
div><blockquote type=3D"cite"><div dir=3D"ltr">=EF=BB=BF
=20
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DUTF-8"=
>
=20
=20
<p>Unless you read all of the PostgreSQL source code and mimic its
behaviour, I regard this impossible. Those files from the DATA
directory aren't simple CSV files or similar.</p>
<p><br>
</p>
<div class=3D"moz-cite-prefix">Am 11.01.24 um 22:24 schrieb Andrew
Wang:<br>
</div>
<blockquote type=3D"cite" cite=3D"mid:BED6BA2A-A526-4806-A0CE-5A09DAD361=
1B@gmail.com">
<meta http-equiv=3D"content-type" content=3D"text/html; charset=3DUTF-=
8">
These files were backed up to another Linux system. Is it possible
to convert it into a program readable format? I can write a script
in most languages to read them.<br id=3D"lineBreakAtBeginningOfSignatu=
re">
<div dir=3D"ltr">Best,
<div><br>
</div>
<div><br>
</div>
</div>
<div dir=3D"ltr"><br>
<blockquote type=3D"cite">On Jan 11, 2024, at 3:18=E2=80=AFPM, Holge=
r
Jakobs <a class=3D"moz-txt-link-rfc2396E" href=3D"mailto:holger@ja=
kobs.com"><holger@jakobs.com></a> wrote:<br>
<br>
</blockquote>
</div>
<blockquote type=3D"cite">
<div dir=3D"ltr">=EF=BB=BF
<meta http-equiv=3D"Content-Type" content=3D"text/html;
charset=3DUTF-8">
<p>You can always dump the contents of a running instance
(called cluster) using pg_dumpall creating a text file with
SQL commands, which can be fed subsequently into any empty,
but running installation of the same or more recent version
of the server using psql.</p>
<p>What isn't possible is getting a corrupted copy of the data
directory back to life.</p>
<p>Unless you took the copy while the database server was
completely down, regard it unusable.</p>
<p>If the copy isn't corrupt, you can start it on the same
architecture with the same major version of the software
again using pg_ctl. Look at the help of the program for
details.</p>
<p>When the database system is running again, take a dump with
pg_dumpall.<br>
</p>
<div class=3D"moz-cite-prefix">Am 11.01.24 um 22:12 schrieb
Andrew Wang:<br>
</div>
<blockquote type=3D"cite" cite=3D"mid:A248CBC8-BBB2-44E4-B9F1-408D=
258D67B4@gmail.com">
<meta http-equiv=3D"content-type" content=3D"text/html;
charset=3DUTF-8">
They were separated. The source list in Ubuntu 18 was moved
because the 16 is different from former versions, which
caused 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
complained ports and other things. Any way to dump all
into a format from another computer and then read them
into the new 16?<br id=3D"lineBreakAtBeginningOfSignature">
<div dir=3D"ltr">Best,
<div><br>
</div>
<div><br>
</div>
</div>
<div dir=3D"ltr"><br>
<blockquote type=3D"cite">On Jan 11, 2024, at 2:28=E2=80=AFP=
M, Ron
Johnson <a class=3D"moz-txt-link-rfc2396E" href=3D"mailto:=
ronljohnsonjr@gmail.com" moz-do-not-send=3D"true"><ronljohnsonjr@gmail.co=
m></a>
wrote:<br>
<br>
</blockquote>
</div>
<blockquote type=3D"cite">
<div dir=3D"ltr">=EF=BB=BF
<div dir=3D"ltr">
<div dir=3D"ltr">"I assumed they can merged into 16
but they were not after upgrading my system."</div>
<div dir=3D"ltr"><br>
</div>
<div>Yeah... that's a pretty unfounded assumption.</div>=
<div><br>
</div>
<div>Fortunately, your data <b>might</b> be
salvageable, if the new system has separate -- an=
d
populated -- directories for 12, 13 and 14. Were=
any of the source system 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 with 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=AFPM Andrew Wang <<a href=3D"m=
ailto:andrew.wang.2009@gmail.com" moz-do-not-send=3D"true" class=3D"moz-txt-=
link-freetext">andrew.wang.2009@gmail.com</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">
<div dir=3D"auto">I used =E2=80=9Crsync=E2=80=9D in L=
inux 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.<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 Jan 11, 2024, at
1:46=E2=80=AFPM, Rajesh Kumar <<a href=3D"m=
ailto:rajeshkumar.dba09@gmail.com" target=3D"_blank" moz-do-not-send=3D"true=
" class=3D"moz-txt-link-freetext">rajeshkumar.dba09@gmail.com</a>>
wrote:<br>
<br>
</blockquote>
</div>
<blockquote type=3D"cite">
<div dir=3D"ltr">=EF=BB=BF
<div dir=3D"auto">Did you take basebackup?&nbs=
p;</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"_blank" moz-do-not-send=3D"true" class=3D"moz-txt-link-freete=
xt">ronljohnsonjr@gmail.com</a>>
wrote:<br>
</div>
<blockquote class=3D"gmail_quote" style=3D"m=
argin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,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=AFP=
M
Andrew Wang <<a href=3D"mailto:an=
drew.wang.2009@gmail.com" rel=3D"noreferrer" target=3D"_blank" moz-do-not-se=
nd=3D"true" class=3D"moz-txt-link-freetext">andrew.wang.2009@gmail.com</a>&g=
t;
wrote:<br>
</div>
<blockquote class=3D"gmail_quote" styl=
e=3D"margin:0px 0px 0px
0.8ex;border-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>restor=
e
all data from
/var/lib/pgsql/15/main,</stron=
g>
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</div>
<div>Your search for <strong>resto=
re
data from /var/lib/pgsql/</str=
ong>
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_at=
tr">On Thu,
Jan 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" moz-do-not-send=3D"true" class=3D"moz-txt-link-freetext">pgsql-admi=
n-owner@lists.postgresql.org</a>>
wrote:<br>
</div>
<blockquote class=3D"gmail_quote" s=
tyle=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@li=
sts.postgresql.org" rel=3D"noreferrer" target=3D"_blank" moz-do-not-send=3D"=
true" class=3D"moz-txt-link-freetext">pgsql-admin@lists.postgresql.org</a><b=
r>
<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_prefi=
x">--
</span><br>
<div dir=3D"ltr" class=3D"gmail_sign=
ature">
<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>
</blockquote>
<pre class=3D"moz-signature" cols=3D"72">--=20
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012</pre>
</div>
</blockquote>
</blockquote>
<pre class=3D"moz-signature" cols=3D"72">--=20
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012</pre>
=20
</div></blockquote></body></html>=
--Apple-Mail-6535AB43-4703-40AE-B1D4-B3B391EF3B95--
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Test mail for pgsql-admin
2024-01-11 17:43 Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 19:25 ` Re: Test mail for pgsql-admin Ron Johnson <ronljohnsonjr@gmail.com>
2024-01-11 19:46 ` Re: Test mail for pgsql-admin Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2024-01-11 20:11 ` Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 20:28 ` Re: Test mail for pgsql-admin Ron Johnson <ronljohnsonjr@gmail.com>
2024-01-11 21:12 ` Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
@ 2024-01-11 21:45 ` Ron Johnson <ronljohnsonjr@gmail.com>
2024-01-12 03:29 ` Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
1 sibling, 1 reply; 13+ messages in thread
From: Ron Johnson @ 2024-01-11 21:45 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Thu, Jan 11, 2024 at 4:12 PM Andrew Wang <andrew.wang.2009@gmail.com>
wrote:
>
> I tried to install the 15 and 16, but the configuration complained ports
> and other things.
>
All of which are issues that simple Postgresql configuration changes can
solve.
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Test mail for pgsql-admin
2024-01-11 17:43 Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 19:25 ` Re: Test mail for pgsql-admin Ron Johnson <ronljohnsonjr@gmail.com>
2024-01-11 19:46 ` Re: Test mail for pgsql-admin Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2024-01-11 20:11 ` Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 20:28 ` Re: Test mail for pgsql-admin Ron Johnson <ronljohnsonjr@gmail.com>
2024-01-11 21:12 ` Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 21:45 ` Re: Test mail for pgsql-admin Ron Johnson <ronljohnsonjr@gmail.com>
@ 2024-01-12 03:29 ` Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-12 03:36 ` Re: Test mail for pgsql-admin Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 1 reply; 13+ messages in thread
From: Andrew Wang @ 2024-01-12 03:29 UTC (permalink / raw)
To: Ron Johnson <ronljohnsonjr@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Thanks, now 3 versions, 14, 15, and 16 are running as shown below. I did
pg_upgrade as detailed below, but it asked me to shutdown postmaster,
should which postmaster be down and how?
##three
#sudo pg_lsclusters
Ver Cluster Port Status Owner Data directory Log file
14 main 5432 online postgres /var/lib/postgresql/14/main
/var/log/postgresql/postgresql-14-main.log
15 main 5434 online postgres /var/lib/postgresql/15/main
/var/log/postgresql/postgresql-15-main.log
16 main 5433 online postgres /var/lib/postgresql/16/main
/var/log/postgresql/postgresql-16-main.log
##pg_upgrade
/usr/lib/postgresql/16/bin/pg_upgrade -b /usr/lib/postgresql/15/bin -B
/usr/lib/postgresql/16/bin -d /var/lib/postgresql/15/main -D
/var/lib/postgresql/16/main --check
There seems to be a postmaster servicing the new cluster.
Please shutdown that postmaster and try again.
Failure, exiting
On Thu, Jan 11, 2024 at 3:45 PM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
>
> On Thu, Jan 11, 2024 at 4:12 PM Andrew Wang <andrew.wang.2009@gmail.com>
> wrote:
>
>>
>> I tried to install the 15 and 16, but the configuration complained ports
>> and other things.
>>
>
> All of which are issues that simple Postgresql configuration changes can
> solve.
>
--
Best,
Andrew Wang
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Test mail for pgsql-admin
2024-01-11 17:43 Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 19:25 ` Re: Test mail for pgsql-admin Ron Johnson <ronljohnsonjr@gmail.com>
2024-01-11 19:46 ` Re: Test mail for pgsql-admin Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2024-01-11 20:11 ` Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 20:28 ` Re: Test mail for pgsql-admin Ron Johnson <ronljohnsonjr@gmail.com>
2024-01-11 21:12 ` Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 21:45 ` Re: Test mail for pgsql-admin Ron Johnson <ronljohnsonjr@gmail.com>
2024-01-12 03:29 ` Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
@ 2024-01-12 03:36 ` Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 0 replies; 13+ messages in thread
From: Scott Ribe @ 2024-01-12 03:36 UTC (permalink / raw)
To: Andrew Wang <andrew.wang.2009@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
> On Jan 11, 2024, at 8:29 PM, Andrew Wang <andrew.wang.2009@gmail.com> wrote:
>
> Thanks, now 3 versions, 14, 15, and 16 are running as shown below. I did pg_upgrade as detailed below, but it asked me to shutdown postmaster, should which postmaster be down and how?
Both old and new, pg_upgrade will start the ones it needs when it needs them. Strongly suggest you review the documentation, where this is clearly stated: https://www.postgresql.org/docs/current/pgupgrade.html
^ permalink raw reply [nested|flat] 13+ messages in thread
end of thread, other threads:[~2024-01-12 03:36 UTC | newest]
Thread overview: 13+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-01-11 17:43 Re: Test mail for pgsql-admin Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 19:25 ` Ron Johnson <ronljohnsonjr@gmail.com>
2024-01-11 19:46 ` Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2024-01-11 20:11 ` Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 20:28 ` Ron Johnson <ronljohnsonjr@gmail.com>
2024-01-11 21:12 ` Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 21:18 ` Holger Jakobs <holger@jakobs.com>
2024-01-11 21:24 ` Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 21:26 ` Holger Jakobs <holger@jakobs.com>
2024-01-11 21:31 ` Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-11 21:45 ` Ron Johnson <ronljohnsonjr@gmail.com>
2024-01-12 03:29 ` Andrew Wang <andrew.wang.2009@gmail.com>
2024-01-12 03:36 ` Scott Ribe <scott_ribe@elevated-dev.com>
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