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
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
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,
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
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,
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
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,
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
, 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
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
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
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
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
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
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
15 matches
Mail list logo
