onday, June 24, 2024 3:48 AM
To: Dmitry O Litvintsev
Cc: pgsql-generallists.postgresql.org
Subject: Re: Help. The database was created using collation version 2.17, but
the operating system provides version 2.34.
[EXTERNAL] – This message is from an external sender
Dmitry O Litvintsev wr
From: Daniel Verite
Sent: Thursday, June 20, 2024 7:02 AM
To: Dmitry O Litvintsev
Cc: pgsql-generallists.postgresql.org
Subject: Re: Help. The database was created using collation version 2.17, but
the operating system provides version 2.34.
[EXTERNAL
Hello,
I am in the process of migrating DB to Alma9 host. The databse
is rather large - few TBs.
I have run pg_basebackup on Alma9 host and established replication from
production to it. The idea is to quickly switch from master to this new host
during downtime.
Establishing replication we
dnf -qy module sisable postgresql -> "dnf -qy module disable postgresql".
Proper syntax was used. :)
____
From: Dmitry O Litvintsev
Sent: Tuesday, June 18, 2024 12:48 PM
To: Adrian Klaver; pgsql-generallists.postgresql.org
Subject: Re: fa
Yes I did. Sorry did not mention that. I ran the
dnf -qy module sisable postgresql
prior to running.
dnf install postgresql15-server
(so that did not help)
From: Adrian Klaver
Sent: Tuesday, June 18, 2024 12:44 PM
To: Dmitry O Litvintsev; pgsql
Hello,
I am foillowing instructions on
https://www.postgresql.org/download/linux/redhat/
I select version "15"
I select "Red Hat Enterprise, Rocky, AlmaLinux or or Oracle 9"
I get this command to run:
"dnf install -y
https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-re
, 2024 6:42 PM
To: Dmitry O Litvintsev
Cc: pgsql-generallists.postgresql.org
Subject: Re: Confusing error message in 15.6
[EXTERNAL] – This message is from an external sender
On Tue, May 21, 2024, 17:29 Dmitry O Litvintsev
mailto:litvi...@fnal.gov>> wrote:
Hi,
I am observing the following
Hi,
I am observing the following error which confuses me:
# psql -U postgres template1 -c "checkpoint; select
pg_backup_start('${dest}.tar.Z', true)"
CHECKPOINT
pg_backup_start
-
17BF7/3009498
(1 row)
# psql -U postgres template1 -c "select pg_backup_stop(true)"
ERROR: b
Thanks for the quick reply! NP, I was just being extra cautious after upgrade.
From: Tom Lane
Sent: Wednesday, May 15, 2024 6:50 PM
To: Dmitry O Litvintsev
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Seeing new stuff in log after upgrading from
Hi,
After upgrade 11 -> 15 started to see these messages in hot standby log:
< 2024-05-15 17:20:24.164 CDT 151879 > LOG: restartpoint complete: wrote
296338 buffers (28.3%); 0 WAL file(s) added, 134 removed, 0 recycled;
write=1619.469 s, sync=0.022 s, total=1619.539 s; sync files=1492,
long
Hi,
I have a workflow where I recover from PITR backup and run a query on it. The
program that runs query
checks that it can connect to database in a loop, until it can, and then runs
the query.
This has worked fine far. Recently I upgraded to 11 and I see that I can
connect to DB while reco
Hi,
we run 9.6 postgresql DB on Linux box. We run as different user than postgres.
To get it to work we had to chown /var/run/postgresql to be owned by the
process user.
Upgraded to 11 and now we see that file
/var/run/postgresql changes ownership to postgres:postgres on reboot , even
thou
C 240 |
| E-mail:litvi...@fnal.gov |
\--/
On Wed, 5 Jun 2019, Jakub Olczyk wrote:
> Hi Dimiry,
>
> On 04/06/2019 23:49, Dmitry O Litvintsev wrote:
>> Where can I find p
Hi,
Where can I find postgresq11-devel RPM ?
It is missing from direct RPM download page :
https://yum.postgresql.org/11/redhat/rhel-7-x86_64/repoview/
or
https://yum.postgresql.org/11/redhat/rhel-7-x86_64/repoview/postgresqldbserver11.group.html
Thanks,
Dmitry
Hi,
Today the following happened:
Found this error in my production log:
< 2018-10-11 13:31:52.587 CDT >ERROR: insert or update on table "file"
violates foreign key constraint "$1"
< 2018-10-11 13:31:52.587 CDT >DETAIL: Key (volume)=(155303) is not present in
table "volume".
< 2018-10-11 13
15 matches
Mail list logo
