Re: Do we need a way to moderate mailing lists?

#x27;t aware of it and switched it of now. matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub ¡Con Cuba no te metas! «» Don't mess with Cuba! «» Leg Dich nicht mit Kuba an! http://www.cubade

Re: Do we need a way to moderate mailing lists?

take the decision of purging or not a mail based on its subject, and after open a mail based of things like top postings (these get purged without further reading). I know the mail subjects I was involved or on which I answered or which I initiated. matthias -- Matthias Apitz, ✉ g...@unixare

Re: Do we need a way to moderate mailing lists?

used text >> terminals and may not have any Internet access. > > yes, those were the days! :-) As for people using computers > these days, I often wish I could go back in time. :-P > > Cheers, > Paul > > This was my first Internet around 1990: a 1200 baud mode

Re: How to post to this mailing list from a web based interface

post a reply from web. Everyone is free to use whatever he/she wants. For me a we based MUA would be the worst thing ever. matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub ¡Con Cuba no te metas! «»

kernel.shmmax and kernel.shmall for Linux server

921504606846720 kernel.shmmax = 18446744073709551615 kernel.shmmni = 4096 The values are coming from # cat /boot/sysctl.conf-5.3.18-24.46-default ... kernel.shmmax = 0x # SHMALL = SHMMAX/PAGE_SIZE*(SHMMNI/16) kernel.shmall = 0x0f00 Any hints for real values? matthia

existing row not found by SELECT ... WHERE CTID = ?

100 on line 2531: no data found on line 2531 Why is this? Thanks matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub

Re: existing row not found by SELECT ... WHERE CTID = ?

El día martes, mayo 24, 2022 a las 10:47:11 -0400, Tom Lane escribió: > Matthias Apitz writes: > > We have a C-written program, written in ESQL/C, of our LMS where the logic > > crawls with FETCH through a hit list and does UPDATE on some rows which > > match certain condi

Re: existing row not found by SELECT ... WHERE CTID = ?

one process after the other). We're trying to figure out with the customer if something else was started/running at this time between 23:11 and 23:21, to shut this off in the future. Is it possible that the PostgreSQL 13.1 server does something by its own to invalidate the rowid?

Re: existing row not found by SELECT ... WHERE CTID = ?

El día Mittwoch, Mai 25, 2022 a las 12:51:02 +0200, Laurenz Albe escribió: > On Wed, 2022-05-25 at 11:21 +0200, Matthias Apitz wrote: > > Is it possible that the PostgreSQL 13.1 server does something by its own to > > invalidate the rowid? > > No. PostgreSQL may remove a

Re: existing row not found by SELECT ... WHERE CTID = ?

El día Wednesday, May 25, 2022 a las 11:21:44AM +0200, Matthias Apitz escribió: > El día martes, mayo 24, 2022 a las 12:11:49 -0400, Tom Lane escribió: > > > Laurenz Albe writes: > > > It may well be that somebody deleted or updated a few rows between the > >

Re: existing row not found by SELECT ... WHERE CTID = ?

HOLD and this conflicts with FOR UPDATE. And this is not easy to change in our generic generated DB-layer for all the ~400 tables. matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub

Re: existing row not found by SELECT ... WHERE CTID = ?

s cumulates in the night. The time window between creating the CURSOR and missing the CTID is only 42 seconds and I can not imagine that any other concurrent process is updating such fee rows at midnight. Could exist any other reason why a row changes its CTID? Full VACUUM is not used either. Thanks

Re: existing row not found by SELECT ... WHERE CTID = ?

again for a SELECT for the CTID. Can this work? matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub

function currtid2() in SQL and ESQL/C to get the new CTID of a row

(0,13)'::tid)' like the SELECT was just an echo function. Is this function currtid2() not meant to be used in ESQL/C? Or did we something wrong in ESQL/C? I read as well in some posting that the functions currtid2() and currtid() should be removed... Is there some better way to get t

Re: accessing postgres from c++

al sources. matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub May, 9: Спаси́бо освободители! Thank you very much, Russian liberators!

Re: function currtid2() in SQL and ESQL/C to get the new CTID of a row

ut on line 2540: correctly got 0 tuples with 78 fields raising sqlcode 100 on line 2540: no data found on line 2540 Why is currtid2() returning the old CTID? Looking from another SQL session the CITD of the row is indeed (671803,23), i.e. changed. Thanks matthias -- Matthias Apitz, ✉ g..

Re: function currtid2() in SQL and ESQL/C to get the new CTID of a row

El día miércoles, junio 22, 2022 a las 08:39:31 +0200, Matthias Apitz escribió: > > EXEC SQL SELECT currtid2(:table ::text, :oldCTID ::tid) INTO :newCTID; > > > > ... > > Hello Tom, > > We came accross cases where the above SELECT returns as :newCTID the > s

lifetime of the old CTID

-- (29036,11) i.e. the function now only returns it argument. and not the new CTID anymore. Why is this? And what triggers exactly that the old CTID can't be used anymore? Thanks matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub

Re: lifetime of the old CTID

El día Dienstag, Juli 05, 2022 a las 10:40:40 +0200, Laurenz Albe escribió: > On Tue, 2022-07-05 at 09:51 +0200, Matthias Apitz wrote: > > We're using the SQL function currtid2() to get the new CTID of a row > > when this was UPDATEd. > > > > Investigating cases

Re: lifetime of the old CTID

El día Dienstag, Juli 05, 2022 a las 10:40:40 +0200, Laurenz Albe escribió: > On Tue, 2022-07-05 at 09:51 +0200, Matthias Apitz wrote: > > We're using the SQL function currtid2() to get the new CTID of a row > > when this was UPDATEd. > > > > Investigating cases

Re: lifetime of the old CTID

id); > >   currtid2  > > > >  (29036,11) > > Right. Heap-Only tuples can also vanish without autovacuum; that is why I > suspected it might have been that. Hi Laurenz, ist there any way to keep/freeze such tuples until the run of the next autovaccum? Some ki

Re: lifetime of the old CTID

e current ctid based on the old one, but as we see this does not help always. Thanks matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub

Re: lifetime of the old CTID

El día martes, julio 05, 2022 a las 10:44:23p. m. -0700, Christophe Pettus escribió: > > > > On Jul 5, 2022, at 22:35, Matthias Apitz wrote: > > Internally, in the DB layer, the read_where() builds the row list matching > > the WHERE clause as a SCROLLED CURSOR of

Re: lifetime of the old CTID

El día Mittwoch, Juli 06, 2022 a las 11:45:14 +0200, Karsten Hilbert escribió: > Am Wed, Jul 06, 2022 at 08:18:42AM +0200 schrieb Matthias Apitz: > > > > On first glance, it appears that you are using the ctid as a primary key > > > for a row, and that's highly

Re: lifetime of the old CTID

El día miércoles, julio 06, 2022 a las 03:53:54p. m. +0200, Peter J. Holzer escribió: > On 2022-07-06 14:26:00 +0200, Matthias Apitz wrote: > > DB layer must LOCK the row for update. It does so using the CTID. Of > > course there is a key in the row (d01gsi, the signature of the

Re: lifetime of the old CTID

El día miércoles, julio 06, 2022 a las 02:33:42p. m. -0500, Ron escribió: > On 7/6/22 01:18, Matthias Apitz wrote: > [snip] > > Ofc, each table has its own primary key(s), used for example for the > > SELECT ctid, * FROM d01buch WHERE ... > > > > As I said, we came

a database can be created but not droped

hy is this? matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub

Mysterious performance degradation in exceptional cases

or whatever). Any ideas about this? matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub

Re: Mysterious performance degradation in exceptional cases

El día miércoles, septiembre 14, 2022 a las 07:19:31a. m. -0700, Adrian Klaver escribió: > On 9/14/22 01:31, Matthias Apitz wrote: > > > > We have a C-written application server which uses ESQL/C on top > > of PostgreSQL 13.1 on Linux. The application in question alway

Re: Mysterious performance degradation in exceptional cases

El día jueves, septiembre 15, 2022 a las 08:40:24a. m. -0700, Adrian Klaver escribió: > On 9/14/22 22:33, Matthias Apitz wrote: > > El día miércoles, septiembre 14, 2022 a las 07:19:31a. m. -0700, Adrian > > Klaver escribió: > > > > > On 9/14/22 01:31, Matthias

Re: Mysterious performance degradation in exceptional cases

El día domingo, septiembre 18, 2022 a las 07:47:32a. m. -0700, Adrian Klaver escribió: > On 9/18/22 02:30, Matthias Apitz wrote: > > El día jueves, septiembre 15, 2022 a las 08:40:24a. m. -0700, Adrian Klaver > > escribió: > > > > > On 9/14/22 22:33, Matthi

NULL values and Java JDBC

Hello, Columns may contain NULL values. The ecpg for pre-compiling ESQL/C code has an option to let return NULL values in CHAR columns as empty strings "" and INTEGER as INT_MIN (-0x7fff - 1) values. Is there a similar option for Java JDBC? Thanks matthias -- Matthias

Re: NULL values and Java JDBC

El día viernes, septiembre 30, 2022 a las 09:56:07a. m. -0600, Rob Sargent escribió: > On 9/30/22 09:46, Matthias Apitz wrote: > > Hello, > > > > Columns may contain NULL values. The ecpg for pre-compiling ESQL/C code > > has an option to let return NULL values in CH

Re: Mysterious performance degradation in exceptional cases

El día Mittwoch, September 14, 2022 a las 10:31:26 +0200, Matthias Apitz escribió: > > We have a C-written application server which uses ESQL/C on top > of PostgreSQL 13.1 on Linux. The application in question always serves > the same search in a librarian database, given to the

PostgreSQL server "idle in transaction"

xecParams [6978] [15.11.2022 11:05:50:174]: ecpg_free_params on line 543: parameter 1 = hc_z39t_report [6978] [15.11.2022 11:05:50:174]: ecpg_process_output on line 543: correctly got 0 tuples with 1 fields -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub

Re: PostgreSQL server "idle in transaction"

El día Dienstag, November 15, 2022 a las 10:28:11 -0500, Tom Lane escribió: > Adrian Klaver writes: > > On 11/15/22 04:28, Matthias Apitz wrote: > >> I have below the full ESQL/C log and do not understand, why the > >> PostgreSQL server is thinking "idle

Re: PostgreSQL server "idle in transaction"

El día Dienstag, November 15, 2022 a las 10:28:11 -0500, Tom Lane escribió: > Adrian Klaver writes: > > On 11/15/22 04:28, Matthias Apitz wrote: > >> I have below the full ESQL/C log and do not understand, why the > >> PostgreSQL server is thinking "idle

names of the WAL files

Hello, Is there some interpretation of the names of the WAL files available? Thanks matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub

Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours

gt; > /dev/null 2>&1 & > > Had no idea somebody can add something like this externally... Please post the content of this script. matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub

Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours

ell code in detail, this is clear evidence of an attack. You must purge the full operating system and reinstall it from scratch with better credentials of Linux and later PostgreSQL. matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key

How do the Linux distributions create the Linux user/group "postgres"?

ot; before creating the cluster. As nowadays there are a lot of setup such things in bigger installations, like LDAP or AD, etc. I'd like to know how other installations for Linux deal with this? Thanks matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/

Re: How do the Linux distributions create the Linux user/group "postgres"?

El día Montag, Januar 09, 2023 a las 08:15:33 -0500, Joe Conway escribió: > On 1/9/23 07:41, Matthias Apitz wrote: > > Please note: I'm talking about the user and group "postgres" in the > > Linux OS and not in the PostgreSQL server. > > > > We're

PostgreSQL DBA training

(and having expressed that I'm not a novice im matters of PostgreSQL) I'm looking for a good DBA course, if possible face to face and not online. Any pointer are welcome. I'm located in Germany, near Munich. Thanks in advance matthias -- Matthias Apitz, ✉ g...@unixarea.de, ht

database postgres not found

| -1 | 14343 | 479 | 1 | 1663 | (1 row) What does this mean? Thanks matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub

moving a database to a new 15.1 server

ount(*) from dbo.counter; count --- 41 i.e. I have to specify the schema 'dbo' to access the tables. What I am missing here in this move? matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub

ERROR: deadlock detected

the Linux PID, correct? Thanks matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub

Re: How to verify postrgresql download on windows?

e that, so how else can i verify the download You can't. You should ask EDB for MD5 or SHA256. Or you should reject those binaries. matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub No euro for t

Missing pg_config on SuSE SLES 12 for PostgreSQL 10

r | The Programs Needed to Create and Run a-> | package | postgresql_anonymizer10 | Anonymization & Data Masking for Postgr-> | package | split_postgres_dump | Break a PostgreSQL dump file into pre-d-> | package What I do missing to get 'pg_con

Re: Missing pg_config on SuSE SLES 12 for PostgreSQL 10

On Sat, 27 Apr 2019 12:41:07 +0200, Laurenz Albe wrote: > Matthias Apitz wrote: >> I'm investigating on a SuSE Linux SLES 12 server if we could add support >> for PostgreSQL 10 to our Library Management System (currently >> running on top >> of Oracle 12 an

Re: Missing pg_config on SuSE SLES 12 for PostgreSQL 10

El día sábado, abril 27, 2019 a las 11:00:53a. m. +, Matthias Apitz escribió: > >> To get Perl's DBD::Pg compiled now I really do need the pg_config tool, > >> but I can't figure out how to get it. I see the following RPM (the ones > >&

Re: Missing pg_config on SuSE SLES 12 for PostgreSQL 10

El día sábado, abril 27, 2019 a las 06:22:00a. m. -0700, Adrian Klaver escribió: > On 4/27/19 12:58 AM, Matthias Apitz wrote: > > Hello, > > > > I'm investigating on a SuSE Linux SLES 12 server if we could add support > > for PostgreSQL 10 to our Library Managem

Re: Missing pg_config on SuSE SLES 12 for PostgreSQL 10

El día sábado, abril 27, 2019 a las 02:39:54p. m. +0100, Andrew Gierth escribió: > >>>>> "Matthias" == Matthias Apitz writes: > > Matthias> There is no cmd 'pg_config'. Can I compile this from source? > > Some distros separate out a &#x

Re: Missing pg_config on SuSE SLES 12 for PostgreSQL 10

El día sábado, abril 27, 2019 a las 04:11:06p. m. +0200, Christoph Moench-Tegeder escribió: > ## Matthias Apitz (g...@unixarea.de): > > > To get Perl's DBD::Pg compiled now I really do need the pg_config tool, > > but I can't figure out how to get it. I see the foll

Re: Missing pg_config on SuSE SLES 12 for PostgreSQL 10

El día Monday, April 29, 2019 a las 10:24:34AM +0200, Christoph Moench-Tegeder escribió: > ## Matthias Apitz (g...@unixarea.de): > > > The server in question is SLES12-SP3 and I can't update to SP4 at the > > moment. I have installed the following pkg: > > >

Re: Missing pg_config on SuSE SLES 12 for PostgreSQL 10

nfig /usr/bin/pg_config and all (C, ESQL/C, ...) seems to be fine. Why exists this mess with the 'PGDG' packages at all? Thanks for your help in any case. Regards matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key:

Re: Back Slash \ issue

on a Linux or any other UNIX (or even Cygwin on Windows) through a sed-Kommand to do the necessary changes, like echo 'bla\foo' | sed 's/\\//' bla\\foo matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://ww

Re: Back Slash \ issue

;s why I said: > What about piping the data on a Linux or any other UNIX (or even Cygwin on > Windows) > through a sed-Kommand to do the necessary changes, like ... i.e you could use Windows for this. Or transfer the data for processing to a Linux system, and back for loading. matthi

Migrating database(s) from Sybase ASE 15.7 to PostgreSQL 10.6 on Linux

o) and with hex representation of the BLOB data. This seems to fit nicely with PostgreSQL's COPY command. Any known pitfalls? Btw: We're investigating MySQL too, but this seems to be from the list now for not having an ESQL/C interface. Regards matthias -- Matthias Apitz,

Re: Migrating database(s) from Sybase ASE 15.7 to PostgreSQL 10.6 on Linux

El día Friday, May 03, 2019 a las 07:38:23AM -0500, Ron escribió: > On 5/3/19 6:56 AM, Matthias Apitz wrote: > >Hello, > > > >We're investigating the migration of our LMS (Library Managment System) > >from Sybase ASE 15.7 to PostgreSQL 10.6. The used database in

Two small questions re/ COPY CSV data into table

tool which escapes the delimiter as '\|', i.e. putting a backslash before the delimiter. I found no way that COPY understands this excaping. Any ideas? Thanks matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.

Re: Two small questions re/ COPY CSV data into table

e line looks like: 0|1| cat $1 \| lpr -Pprinter |3|4 I do load this now with COPY in mode TEXT and modify the data before with: sed 's/|/\v/g' < table-from-Sybase | sed 's/\\\v/|/g' > table-for-copy Works fine. matthias -- Matthias Apitz, ✉ g...@unixarea.de,

Re: Two small questions re/ COPY CSV data into table

the example above a pipe of two UNIX cmd). Do you do UNIX? matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub May, 9: Спаси́бо освободители! Thank you very much, Russian liberators!

Re: Two small questions re/ COPY CSV data into table

of columns did not matched. I will provide tomorrow the exact input line, the exact COPY command and the error. matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub May, 9: Спаси́бо освободители! Thank you very much, Russian liberators!

Re: Two small questions re/ COPY CSV data into table

El día Tuesday, June 04, 2019 a las 07:20:54PM +0200, Matthias Apitz escribió: > El día Tuesday, June 04, 2019 a las 05:56:49PM +0100, Andrew Gierth escribió: > > > If you use COPY ... WITH DELIMITER '|' (i.e. text mode, not CSV mode) > > then the \| is accepted

Re: Inserting into the blob

have \\x in front of it. The file was just in "user land", i.e. COPY tablename FROM 'myfile' matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub May, 9: Спаси́бо осво

encryption of specific columns

Hello, I've read the 10.x handbook, chapter 18.8. about the various encryption options. One question remains: If I encrypt a column, for example the birthdate of PII data, is this still searchable with SELECT * FROM table WHERE birthdate = 07.12.1955; Thanks matthias -- Mat

DBD::Pg (version 3.16.3) returns EMPTY char columns as 'undef'

; in the writing of a CSV-like export files. Ofc NULL values in the database are something else as '' char strings. How this must be distinguished with DBD::Pg? Thanks matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub

Re: DBD::Pg (version 3.16.3) returns EMPTY char columns as 'undef'

warning is printed for this perl line 1196: ~sisis/sc/dbtool < unl 2>&1 | grep 1196 Use of uninitialized value $row_ary[2] in concatenation (.) or string at /home/sisis/sc/dbtool.pl line 1196. Thanks again and Kind Regards matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub

Re: error: connection to server on socket...

0 0.0.0.0:54320.0.0.0:* LISTEN tcp6 0 0 :::5432 :::*LISTEN unix 2 [ ACC ] STREAM LISTENING 22000/tmp/.s.PGSQL.5432 We normaly use the TCP/IP port 5432 to connect to the server. matthias -- Mat

Re: PostgreSQL listens on localhost?

g_hba.conf Thanks matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub

Re: Will PostgreSQL 16 supports native transparent data encryption ?

; > > will either. > > > > That's disappointing, since TDE makes PCI audits that much simpler. > > > There's ongoing work happening for TDE support and we'd love to hear > from folks who would like to see it included. You can expect an updated > patch s

Re: Will PostgreSQL 16 supports native transparent data encryption ?

El día jueves, septiembre 07, 2023 a las 12:33:06 -0400, Stephen Frost escribió: > * Matthias Apitz (g...@unixarea.de) wrote: > > > > > > There's ongoing work happening for TDE support and we'd love to hear > > > from folks who would like to see it include

Re: Is data import from Oracle table to Postgres table in Ora2pg consecutive or random?

llest to largest? AFAIK, a simple SELECT in PostgreSQL without an ORDER BY will return the rows in random order. matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub

How to investigate deadlocks

] CONTEXT: while locking tuple (38,57) in relation "d03geb" 2023-09-30 16:50:50.951 CEST [18117] STATEMENT: fetch hc_d03geb The shown PIDs for sure are the ones of the Pos backend proc (on Linux). Is there any chance to investigate it further? Thanks matthias -- Matthias

Re: Presentation tools used ?

ric/tools/s5/ An example presentation done with s5 is here: http://www.unixarea.de/LiHab2013/ To go through the slides just do a click in the browser. HIH matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de

REINDEX in tables

the issue that the number of rows in some of the above tables has increased. Is this possible? Thanks matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub I am not at war with Russia. Я не воюю с Россией

Re: REINDEX in tables

El día miércoles, octubre 25, 2023 a las 11:33:11 +0200, Andreas Kretschmer escribió: > Am 25.10.23 um 11:24 schrieb Matthias Apitz: > > We have a client who run REINDEX in certain tables of the database of > > our application (on Linux with PostgreSQL 13.x): > > > >

pg_basebackup

server says something about "replication", we do pg_basebackup? Some more information: - wal_sender_timeout has default value (60s) - backup target is a local file, not a network storage - the Linux SLES 15 server is good equipped - nothing is logged in /var/log/messages Any

Re: Two started cluster on the same data directory and port

o rm -r main_old/ > >   or > > sudo cp -r main_old > > Arrgh. > > sudo mv -r main_old > > Memo to self don't eat lunch and copy/paste at same time. Hmmm purism@pureos:~$ uname -s Linux purism@pureos:~$ mv -r foo bar mv: invalid option -- '

Re: Filled Postgres server as Docker image

he image for debugging/testing; I plan to have a similar PostgreSQL server outside the image, with loaded database. Shut this down and create a tar archive of the full server which then will be COPY'ed into the image at build time and scripts in /entrypoint.d will arange everything. ma

/usr/local/sisis-pap/pgsql-15.1/bin/postmaster SIGSEGV in podman container on MacOS

RedHat runs fine on RedHat and also on SuSE Linux when the container gets pushed from RedHat to SuSE, i.e. without rebuilding it. -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub I am not at war with Russia. Я не во

Re: SUSE repositories not longer available

nd all attachments. Interesting signature :-) You have sent a confidential message to a mailing list with many subscribers and which will be visible in the archive for the world until the end of it (which could be soon). matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de

Re: Connection remains idle for more than 15 minutes, then the connection drops by IPVS setting in k8s kube-proxy

t; only. > " > > Is there any other alternative approach using some configuration files from > client side? An option could be to run the connection through an SSH tunnel and use there the sshd(8) config parameter ClientAliveInterval. HIH matthias -- Matthias Api

update to 16.2

from Sybase and Oracle to PostgreSQL). But I think, producing the dump with the old version, setup new cluster and load the dump with the 16.2 sql command will work. Any comments? matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key

Re: update to 16.2

El día viernes, marzo 08, 2024 a las 12:56:16 -0800, Christophe Pettus escribió: > > > > On Mar 8, 2024, at 00:53, Matthias Apitz wrote: > > It does not say definitely that for all other versions a dump/restore is > > required. > > You cannot just replace t

soft lockup - CPU#16 stuck for 3124s! [postmaster:2273]

WALs could have caused the locks? Just to make sure that we hit the beast. matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub

Re: soft lockup - CPU#16 stuck for 3124s! [postmaster:2273]

El día viernes, marzo 22, 2024 a las 01:31:43p. m. -0400, Ron Johnson escribió: > On Fri, Mar 22, 2024 at 1:27 PM Tom Lane wrote: > > > Matthias Apitz writes: > > > We have a PostgreSQL 15.1 server in production at a customer for some > > > weeks (migrated from

mystery with postgresql.auto.conf

on/pg_tde.control": No such file or directory. HINT: The extension must first be installed on the system where PostgreSQL is running. How was this option set into the file postgresql151/data/postgresql.auto.conf? And I did not do this by hand, I wasn't even aware until today that th

Re: mystery with postgresql.auto.conf

1) Type "help" for help. sisis=# ALTER SYSTEM SET shared_preload_libraries = 'pg_tde'; ALTER SYSTEM sisis=# and the file gets modified :-( Why it does not give an error because the shared lib isn't there? matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub

problem loading shared lib pg_tde.so

libssh.so.4 | grep EVP_KDF EVP_KDF_CTX_new_id EVP_KDF_ctrl EVP_KDF_CTX_free EVP_KDF_derive I have a complete different OpenSSL 3.0.x environment: all OpenSSL consumers use /usr/local/sisis-pap.sp01/lib/libssl.so.3, also PostgreSQL and pg_tde have been compiled against this; and this runs fine with 'pg_tde&#

Re: problem loading shared lib pg_tde.so

El día lunes, mayo 06, 2024 a las 07:45:52 -0700, Adrian Klaver escribió: > On 5/6/24 07:42, Adrian Klaver wrote: > > On 5/6/24 04:05, Matthias Apitz wrote: > > > > > I see three different versions of OpenSSL: > > > > OPENSSL_1_1_1d  -- From er

Re: problem loading shared lib pg_tde.so

El día martes, mayo 07, 2024 a las 07:07:22 +0200, Matthias Apitz escribió: > # ls -l /usr/local/sisis-pap/lib/libcurl* > -rw-r--r-- 1 bin bin 1315526 May 6 10:29 /usr/local/sisis-pap/lib/libcurl.a > -rwxr-xr-x 1 bin bin1004 May 6 10:29 /usr/local/sisis-pap/lib/libcurl.la > -rwx

Re: Postgres :- Could not open R2DBC Connection

reactor.core.publisher.FluxOnErrorResume$ResumeSubscriber.onError(FluxOnErrorResume.java:94) > at > co.elastic.apm.agent.reactor.TracedSubscriber.onError(TracedSubscriber.java:126) > at > reactor.core.publisher.MonoFlatMap$FlatMapMain.onError(MonoFlatMap.java:172) > at > co.elastic.apm.agent.reactor.Traced

Re: Support of Postgresql 15 for Sles15Sp6

s that SUSE > themselves build, your third option is to build from source. We always configured and compiled from source on SuSE SLES12 since 11.x and now 15.1 and 16.2 on SuSE SLES15 SP5 (which runs also on SP6). Said this, is also depends if the pre-build RPM were configured for OpenSS

Size of PostgreSQL backup ./. Sybase DUMP

cause of the difference? Can the backup somehow be checked without doing a recovery-restore in a new server? Thanks matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub ¡Con Cuba no te metas! «» Don&#

Re: Size of PostgreSQL backup ./. Sybase DUMP

El día viernes, abril 16, 2021 a las 03:59:09p. m. +0200, Laurenz Albe escribió: > On Fri, 2021-04-16 at 15:47 +0200, Matthias Apitz wrote: > > We migrated a customer from Sybase ASE 15.7 to PostgreSQL 11.10, both on > > Linux server. With Sybase you create DUMP of only

client waits for end of update operation and server proc is idle

EST [26827] LOG: unerwartetes EOF auf Client-Verbindung mit einer offenen Transaktion What else could be checked for this? Any hints about this issue? Thanks matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub

Re: client waits for end of update operation and server proc is idle

nexpected EOF client) are logged by other PostgreSQL server processes, not invloved here, and caused by killing other clients with 'kill -9'. matthias -- Matthias Apitz, ✉ g...@unixarea.de, http://www.unixarea.de/ +49-176-38902045 Public GnuPG key: http://www.unixarea.de/key.pub ¡Con Cuba no te metas! «» Don't mess with Cuba! «» Leg Dich nicht mit Kuba an! http://www.cubadebate.cu/noticias/2020/12/25/en-video-con-cuba-no-te-metas/

Re: client waits for end of update operation and server proc is idle

El día viernes, abril 23, 2021 a las 11:32:02a. m. +0200, Matthias Apitz escribió: > El día viernes, abril 23, 2021 a las 10:48:24a. m. +0200, Laurenz Albe > escribió: > > > > The serverlog has around this time (sorry for German): > > > > > > 202

Re: client waits for end of update operation and server proc is idle

El día domingo, abril 25, 2021 a las 01:54:49p. m. +0200, Matthias Apitz escribió: >From the collected data, I tend to say: this must be a bug in the Pos > server... > At the end of the day, it turned out that out client caused the problem. Because we were hunting some other issue, t

<    1   2   3   >