Hi,
imagine a simple table with 1 row
=# table tf;
i | x
---+
1 | xx
(1 row)
And this query:
with x as (update tf set i=i+1 returning *)
, y as (update tf set x=x||'yy' returning *)
select * from x,y;
My PG14 gives this result
i | x | i | x
---+---+---+---
(0 rows)
To me that was a bi
Dear All,
I am trying to use Barman to back up PostgreSQL, which is running in a
Podman container. However, I encounter the error "WAL archive: FAILED," as
shown below:
#barman check testdb
Server testdb:
WAL archive: FAILED (please make sure WAL shipping is set up)
PostgreSQL: OK
superuser: OK
P
On Wed, Jan 10, 2024 at 12:29:54PM +0100, Torsten Förtsch wrote:
> Hi,
>
> imagine a simple table with 1 row
>
> =# table tf;
> i | x
> ---+
> 1 | xx
> (1 row)
>
> And this query:
>
> with x as (update tf set i=i+1 returning *)
> , y as (update tf set x=x||'yy' returning *)
> select * f
Hi,
It's a typical error for brand new setup. After new backup setup do
$ barman switch-xlog --force --archive testdb
br
Kaido
On Wed, 10 Jan 2024 at 15:58, duc hiep ha wrote:
> Dear All,
>
> I am trying to use Barman to back up PostgreSQL, which is running in a
> Podman container. However, I
On Wed, Jan 10, 2024 at 8:46 AM Bruce Momjian wrote:
> On Wed, Jan 10, 2024 at 12:29:54PM +0100, Torsten Förtsch wrote:
>
> >
> > To me that was a bit surprising. I would have expected it to fail with
> > something like "can't update the same row twice in the same command".
> >
> > If I check the
On Wed, Jan 10, 2024 at 09:06:31AM -0700, David G. Johnston wrote:
> It is mostly documented.
>
> https://www.postgresql.org/docs/current/queries-with.html#
> QUERIES-WITH-MODIFYING
> """
> Only one of the modifications takes place, but it is not easy (and sometimes
> not possible) to reliably pre
Is there a problem with the installation of 8.1? I've installed it 3 times but
when I bring it up it still says I'm at 7.8. The Help > About menu shows 7.8
as well.
I am hesitant to uninstall and install from scratch because I don't want to
lose my connections, etc.
Thanks
architects of vi
On 1/10/24 10:47 AM, David Barron wrote:
Is there a problem with the installation of 8.1? I’ve installed it 3
times but when I bring it up it still says I’m at 7.8. The Help >
About menu shows 7.8 as well.
What OS are you using?
Where did you get pgAdmin from?
How did you install it?
David Barron
Zencos Consulting LLC
919-995-2356 (Mobile)
From: Adrian Klaver
Sent: Wednesday, January 10, 2024 1:56 PM
To: David Barron ; pgsql-general@lists.postgresql.org
Subject: Re: pgAdmin 8.1 install
EXTERNAL SENDER
On 1/10/24 10:47 AM, David Barron wrote:
Is there a problem with the
On 1/10/24 10:58 AM, David Barron wrote:
On 1/10/24 10:47 AM, David Barron wrote:
Is there a problem with the installation of 8.1? I’ve installed
it 3 times but when I bring it up it still says I’m at 7.8. The
Help > About menu shows 7.8 as well.
What OS are you using?
Where di
On 1/10/24 10:58 AM, David Barron wrote:
On 1/10/24 10:47 AM, David Barron wrote:
Is there a problem with the installation of 8.1? I’ve installed it 3 times but
when I bring it up it still says I’m at 7.8. The Help > About menu shows 7.8
as well.
What OS are you using?
Where did you get
On 1/10/24 11:37 AM, David Barron wrote:
I am running Windows 10.
I downloaded the Dec 14 release from pgadmin.org
I installed by double-clicking on the executable I downloaded and
running through the installation wizard without making any changes.
Well that looks good to m
> Is there a problem with the installation of 8.1? I’ve installed it 3
times but when I bring it up it still says I’m at 7.8. The Help > About
menu shows 7.8 as well.
> It’s odd because I have gone from 7.6 to 7.7 and 7.7 to 7.8 following the
same steps.
When I look at the directory on my mach
> Is there a problem with the installation of 8.1? I’ve installed it 3 times
> but when I bring it up it still says I’m at 7.8. The Help > About menu shows
> 7.8 as well.
> It’s odd because I have gone from 7.6 to 7.7 and 7.7 to 7.8 following the
> same steps.
When I look at the directory o
On 1/10/24 12:20, David Barron wrote:
Note that v6 and v7 are in subdirectories but v8 is not. If you have an
existing shortcut that you are using, then perhaps it is pointed to the
v7 directory and needs to be updated to point to the directory that v8
is installed in. That would also explai
On 1/10/24 12:20, David Barron wrote:
> Note that v6 and v7 are in subdirectories but v8 is not. If you have
> an existing shortcut that you are using, then perhaps it is pointed to
> the
> v7 directory and needs to be updated to point to the directory that v8
> is installed in. That would a
Hello,
I'm building a new 2-node Postgreql 13 streaming replication cluster. I'm able
to clone the primary to the standby using pg_basebackup.
However, the standby is unable to authenticate to the primary to begin recovery
during startup. It logs an error, "FATAL: could not connect to the prima
On Wed, Jan 10, 2024 at 5:51 PM Keaney, Will wrote:
> Hello,
>
> I'm building a new 2-node Postgreql 13 streaming replication cluster. I'm
> able to clone the primary to the standby using pg_basebackup.
> However, the standby is unable to authenticate to the primary to begin
> recovery during sta
18 matches
Mail list logo
