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:31:58 -0600
Message-ID: <531DC65B-1ED0-4A65-887E-C4F548C089C8@gmail.com> (raw)
In-Reply-To: <983811fd-e0ad-5606-ce9e-3110f73feaec@jakobs.com>
References: <983811fd-e0ad-5606-ce9e-3110f73feaec@jakobs.com>
--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--
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: <531DC65B-1ED0-4A65-887E-C4F548C089C8@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