From: Andrew Wang <andrew.wang.2009@gmail.com>
To: Holger Jakobs <holger@jakobs.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Test mail for pgsql-admin
Date: Thu, 11 Jan 2024 15:24:04 -0600
Message-ID: <BED6BA2A-A526-4806-A0CE-5A09DAD3611B@gmail.com> (raw)
In-Reply-To: <383812ba-230f-9d66-cebe-dd02c4c4f210@jakobs.com>
References: <383812ba-230f-9d66-cebe-dd02c4c4f210@jakobs.com>
--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--
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, holger@jakobs.com, pgsql-admin@lists.postgresql.org
Subject: Re: Test mail for pgsql-admin
In-Reply-To: <BED6BA2A-A526-4806-A0CE-5A09DAD3611B@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