W dniu 18.08.2022 o 16:46, Laurenz Albe pisze:
On Thu, 2022-08-18 at 08:39 +0200, W.P. wrote:
I have a PostgreSQL 11 server on OrangePi3 (ARM 64 bit, Armbian, PG from
distro).
Database (all cluster) is located on USB disk. This approach give me
already 2 times loosing DB contents (it is a
Hi there,
I have a PostgreSQL 11 server on OrangePi3 (ARM 64 bit, Armbian, PG from
distro).
Database (all cluster) is located on USB disk. This approach give me
already 2 times loosing DB contents (it is a replica of DB on i7).
But the whole thing (mainly indexes) is about 50G, and internal
see disk actity running queries.
W.P..
> If it is experimental you could try pg_resetwal:
https://www.postgresql.org/docs/11/app-pgresetwal.html
Found this, had to use -f (program hint), but no luck. Same error.
Is there anything else?
Problem stille here: during restore (from pg_dumpall on 11 on i386)
server on OPi crashed dur
W dniu 06.04.2022 o 20:09, Adrian Klaver pisze:
On 4/6/22 11:04 AM, W.P. wrote:
W dniu 06.04.2022 o 18:54, Ron pisze:
I know about restoring backup. I just don't have one (at least with
reasonnable age), as it is experimental installation. (Didn't ever
been thinking abou
W dniu 06.04.2022 o 18:54, Ron pisze:
On 4/6/22 11:41, W.P. wrote:
W dniu 06.04.2022 o 12:37, Laurenz Albe pisze:
On Wed, 2022-04-06 at 10:57 +0200, W.P. wrote:
Is it possible to repair this?
Not unless you tell us what exactly you did, command by command.
Yours,
Laurenz Albe
That was
W dniu 06.04.2022 o 12:37, Laurenz Albe pisze:
On Wed, 2022-04-06 at 10:57 +0200, W.P. wrote:
Is it possible to repair this?
Not unless you tell us what exactly you did, command by command.
Yours,
Laurenz Albe
That was not a "command". PG was working ok, DB on encrypted (LUK
Hi there,
I had a problem with disconnecting USB disc with PG database on my OPi3.
PG is 11.
Now base refuses to start, with problem reported in log (see attached file).
But I don't have replication configured!
Is it possible to repair this?
Laurent
2022-04-05 20:53:38.892 CEST [12022-04-
W dniu 04.07.2021 o 21:10, Adrian Klaver pisze:
On 7/4/21 11:59 AM, W.P. wrote:
W dniu 04.07.2021 o 19:48, Adrian Klaver pisze:
On 7/4/21 9:33 AM, W.P. wrote:
W dniu 02.07.2021 o 21:05, Adrian Klaver pisze:
On 7/2/21 10:18 AM, W.P. wrote:
W dniu 02.07.2021 o 17:16, Adrian Klaver pisze
>> So you have backup of the failed machine's disk stored somewhere else?
No, I have disc from this machine, looks not damaged (random
files). Only problem that OS does not boot beyond "emergency mode".
I would say your second sentence contradicts your first.
Nope ;). There was 1 500GB dis
W dniu 04.07.2021 o 19:48, Adrian Klaver pisze:
On 7/4/21 9:33 AM, W.P. wrote:
W dniu 02.07.2021 o 21:05, Adrian Klaver pisze:
On 7/2/21 10:18 AM, W.P. wrote:
W dniu 02.07.2021 o 17:16, Adrian Klaver pisze:
So you have backup of the failed machine's disk stored somewhere
else?
W dniu 02.07.2021 o 21:05, Adrian Klaver pisze:
On 7/2/21 10:18 AM, W.P. wrote:
W dniu 02.07.2021 o 17:16, Adrian Klaver pisze:
So you have backup of the failed machine's disk stored somewhere else?
No, I have disc from this machine, looks not damaged (random files).
Only problem
W dniu 02.07.2021 o 17:16, Adrian Klaver pisze:
On 7/1/21 9:24 PM, W.P. wrote:
W dniu 01.07.2021 o 22:27, Adrian Klaver pisze:
On 7/1/21 12:56 PM, W.P. wrote:
W dniu 01.07.2021 o 16:19, Laurenz Albe pisze:
On Thu, 2021-07-01 at 10:56 +0200, W.P. wrote:
I have a PG 11.12 (was 9.5 or 9.5
W dniu 01.07.2021 o 22:27, Adrian Klaver pisze:
On 7/1/21 12:56 PM, W.P. wrote:
W dniu 01.07.2021 o 16:19, Laurenz Albe pisze:
On Thu, 2021-07-01 at 10:56 +0200, W.P. wrote:
I have a PG 11.12 (was 9.5 or 9.5) upgraded from 9.x (during OS
upgrade).
One table is now damaged, trying to dump it
W dniu 01.07.2021 o 16:19, Laurenz Albe pisze:
On Thu, 2021-07-01 at 10:56 +0200, W.P. wrote:
I have a PG 11.12 (was 9.5 or 9.5) upgraded from 9.x (during OS upgrade).
One table is now damaged, trying to dump it results in server restart,
message is "invalid record length maximum i
Hi there,
I have a PG 11.12 (was 9.5 or 9.5) upgraded from 9.x (during OS upgrade).
One table is now damaged, trying to dump it results in server restart,
message is "invalid record length maximum is yyy" (from memory).
Also fails pg_dumpall.
How can I (?) repair this table? (for recent
Hi there,
I have a PG 11.12 (was 9.5 or 9.5) upgraded from 9.x (during OS upgrade).
One table is now damaged, trying to dump it results in server restart,
message is "invalid record length maximum is yyy" (from memory).
Also fails pg_dumpall.
How can I (?) repair this table? (for recent
W dniu 18.01.2021 o 17:19, Laurenz Albe pisze:
On Mon, 2021-01-18 at 05:33 +0100, W.P. wrote:
For 9.5 to 9.6 transition, it worked like charm. (except some problems
with parsing json data in a view, but this I will address later, after
upgrade to final version - Fedora 30, probably PG 10.x
W dniu 13.01.2021 o 12:28, Laurenz Albe pisze:
On Wed, 2021-01-13 at 07:41 +0100, W.P. wrote:
I am upgrading Fedora 24 to (now) 26, PostgreSQL stopped starting (as
expected), the message from systemctl was to do "postgresql-setup
--upgrade".
Did installed the tool, loaunched.
Bu
Hi there,
I am upgrading Fedora 24 to (now) 26, PostgreSQL stopped starting (as
expected), the message from systemctl was to do "postgresql-setup
--upgrade".
Did installed the tool, loaunched.
But it fails with (attached logs) messages, I am missing some libraries,
what should I install?
Hi there,
I am (still) using 9.5 Postgres.
On my new devices (OrangePi) default installed is 11.9. This also seems
to be reasonable choice for my Intel laptop(s), as 11.9 offers logical
replication (as Depesz explained me at some point of time) which is
needed to replicate data between Intel6
Hi there,
how to do "hot backup" (copying files) while database running?
Not using pg_dump.
Is there some equivalent of Oracle (I knew v8) "ALTER DATABASE BEGIN
BACKUP", which froze writes to database files, pushing everything to
redo files?
Laurent.
Hi there,
I have following setup:
- master database, 9.5.7, on I386 (Pentium M),
now i want to replicate database to:
- slave database. 9.5.7 on armhf (OrangePiPC+).
Is in possible?
I already followed "replication setup"
https://www.howtoforge.com/tutorial/postgresql-replication-on-ubuntu-15-04/
23 matches
Mail list logo
