Okay thanks
On Jan 11, 2024, at 3:26 PM, Holger Jakobs <holger@xxxxxxxxxx> wrote:
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.
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?
"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.
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.
Did you take basebackup?
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?
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
Hello!
This is a test mail for the
list
pgsql-admin@xxxxxxxxxxxxxxxxxxxx
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.
--
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
|
