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-
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
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 (LUKS on
LVM2, ext4
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 not a "command". PG was working ok, DB on
On Wednesday, April 6th, 2022 at 17:41, W.P. wrote:
> That was not a "command". PG was working ok, DB on encrypted (LUKS on
> LVM2, ext4) USB drive.
>
I mean, why ?
If there was ever a "setting yourself up to fail" scenario, it would be this.
Just because you can do it, doesn't mean you sho
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 not
On 06/04/2022 18:20, Laura Smith wrote:
On Wednesday, April 6th, 2022 at 17:41, W.P. wrote:
That was not a "command". PG was working ok, DB on encrypted (LUKS
on LVM2, ext4) USB drive.
I mean, why ?
If there was ever a "setting yourself up to fail" scenario, it would
be this. Just because y
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 about locating production DB on USB drive :) ).
If it is experimental y
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 about locating production
On Wed, 2022-04-06 at 18:41 +0200, 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
> >
> >
> >
> 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
11 matches
Mail list logo