Re: Enforce primary key on every table during dev?

Although for a short period the offending table would be there live without a PK. But IMO every table, in addition to PK, should have also natural unique keys as much as possible. Better safe than sorry. Thanks, Jeremy -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: normalizing a float array?

On 06/03/2018 18:12, Celia McInnis wrote: Hi - I can write a stored procedure to normalize float arrays, but is there a nicer way of doing this in postgresql? Last time I checked (1-2 yrs ago) no. -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Prefixing schema name

oes exactly what you think - namely because the default search_path will cause "user1" to appear first. Insert is more similar to Select than it is to Create - the object being inserted into must already exist David J. ​​ -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: primary key and unique index

can be based on a unique index to create a primary key but I also know it is possible to create several indexes on the same columns with the same order. Thanks Thomas -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Question about buffers_alloc in pg_stat_bgwriter view for monitoring

C.H. Freude | http://alvar.a-blast.org https://blog.alvar-freude.de/ https://www.wen-waehlen.de/ -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Autovacuum Problem

Stefan -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Autovacuum Problem

uld you want that? Do you have any control over the application? Any "special" patterns used in the app? 2018-04-03 8:49 GMT+02:00 Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>>: On 03/04/2018 09:36, Kein Name wrote: However no space seems to be freed to the s

Re: Autovacuum Problem

app is doing. IMHO you must prepare for a larger storage. After that you should monitor disk usage periodically to see if usage is stabilized or at least if the increase rate drops. 2018-04-03 9:39 GMT+02:00 Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>>: On 03/0

Re: Postgresql Split Brain: Which one is latest

updates to the postgres databases. The one with the latest timeline. Regards Vikas Sharma -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Login with LDAP authentication takes 5 seconds

s, or a hint, where I could do some further investigation? IPv4 vs IPv6 ? any strange timeouts? look in the postgresql logs for any messages. Also definitely ran wireshark, it'll tell you a lot on what's happening between postgresql and your LDAP . Thanks, Andy -- Achilleas Mantzi

Re: Microsoft buys GitHub, is this a threat to open-source

grate with a variety of common open source packages. Who hasn't missed sourceforge ? or ... freshmeat while we'are at it :) https://sourceforge.net/ -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Monitor repl slot size

/issues/907 but, is there any better way to do it? Any replacement for that function on postgres 10? Thanks a lot, Nicola -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Can't compile postgresql 11 on FreeBSD 11.1

greSQL under FreeBSD with only : ./configure --with-ldap But in my case I tend to fall back to gcc instead of the native clang/llvm . That might be his issue. regards, tom lane -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Can't compile postgresql 11 on FreeBSD 11.1

On 23/07/2018 09:22, Achilleas Mantzios wrote: On 17/07/2018 23:25, Tom Lane wrote: Adrian Klaver writes: On 07/17/2018 12:34 PM, Márcio Antônio Sepp wrote: I'm trying to compile PostgreSQL 11beta2 but this errors occur: checking readline.h usability... no Looks like you need whatev

ALTER ROLE SET search_path produced by pg_dumpall gives : ERROR: syntax error at or near "$" .

ic; psql -f pg_dumpall_out.sql : dynacom=# ALTER ROLE amura3 SET search_path TO $user, amuragents, public; ERROR:  syntax error at or near "$" Is this a bug or am I missing something ? -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: ALTER ROLE SET search_path produced by pg_dumpall gives : ERROR: syntax error at or near "$" .

On 30/07/2018 16:23, Adrian Klaver wrote: On 07/30/2018 05:57 AM, Achilleas Mantzios wrote: This is with PostgreSQL 10.4. How to reproduce : postgres@smadev:~% psql psql (10.4) Type "help" for help. Alter the role for search path : dynacom=# ALTER ROLE amura3 SET search_path

Re: ALTER ROLE SET search_path produced by pg_dumpall gives : ERROR: syntax error at or near "$" .

On 30/07/2018 16:51, Tom Lane wrote: Achilleas Mantzios writes: This is with PostgreSQL 10.4. How to reproduce : dynacom=# ALTER ROLE amura3 SET search_path TO "$user", amuragents, public; ALTER ROLE ... dynacom=> show search_path ;     search_path ---

Re: ALTER ROLE SET search_path produced by pg_dumpall gives : ERROR: syntax error at or near "$" .

On 30/07/2018 17:00, Tom Lane wrote: Achilleas Mantzios writes: On 30/07/2018 16:51, Tom Lane wrote: Hm, that's not happening for me: You (and Adrian) are right. This is due to our own tweaking (which I had forgotten). Sorry for the false alarm. It looks like your hack was to work a

Re: Postgres - search for value throughout many tables?

veryone, I want to aks if anyone knows is there a way to search for specific "value" throughout list of tables OR all tables in databse? Cheers, czezz -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Audit management

nominated user, could you recommend any extension or form that you believe is the best solution, I am currently testing pgaudit Pgaudit. That's what we use. It seems to be a really nice tool. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Achilleas Mantzi

Re: Audit management

), CRLF in the data. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Upgrade/Downgrade

an someone please help how to do this. >Unable to find anything online Why downgrade? Dump and restore should do the job, have you tried it? Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Upgrade/Downgrade

On 23/08/2018 22:40, Nikolay Samokhvalov wrote: On Thu, Aug 23, 2018 at 11:44 AM Joshua D. Drake mailto:j...@commandprompt.com>> wrote: On 08/23/2018 04:47 AM, Achilleas Mantzios wrote: > On 23/08/2018 14:30, Sonam Sharma wrote: >> No, I didn't. The version is

Re: A Timeseries Case Study: InfluxDB VS PostgreSQL

, critics, suggestions and corrections are very welcome Nice read! Wonder if you could repeat the tests on pgsql 10.5 and btree/BRIN. Regards, fabio pardi -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: PG8.3->10 migration data differences

cimal digits. Your difference is on the 8-th digit. When I check the 8.3 pg_dump file, it contains the pg83 correct values. Do you have any ideas, why different this values? Thx, Csaba -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Replication Issues

AL from replication slot but why i got the above ERROR , Why slot removed  the requested wal file , Could you please let me know the reason why it happened or did i miss something ? Thanks, Bhargav K -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Replication Issues

up and use the options "-S -X stream" of pg_basebackup. You then use the same slot in "recovery.conf". That way you cannot lose any WAL. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: SuperUser permission denied when creating table.

On 9/7/19 3:31 μ.μ., Dave Hughes wrote: Has anyone ran across something like this before? can you show your pg_dumpall -x --schema-only ? -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: SuperUser permission denied when creating table.

On 9/7/19 4:50 μ.μ., Dave Hughes wrote: Sure thing.  I attached it as a txt file.  Thanks for the help! PostgreSQL version? On Tue, Jul 9, 2019 at 9:29 AM Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>> wrote: On 9/7/19 3:31 μ.μ., Dave Hughes wrote: > > Ha

Re: PostgreSQL as a Service

back to my main question above. If I wanted to run a DBaaS shop with only PostgreSQL open source, how far away from being able to compete with AWS or Azure (or YugaByte for that matter) would I be? Thanks for any thoughts and opinions! Dirk -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Exclusion constraints on overlapping text arrays?

o the mailing list <mailto:agency-general-requ...@lists.sourceforge.net?body=subscribe> to learn more about AGENCY or follow the discussion. -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Exclusion constraints on overlapping text arrays?

On 30/8/19 10:20 π.μ., Achilleas Mantzios wrote: On 30/8/19 3:42 π.μ., Ken Tanzer wrote: Hi.  Using 9.6.14, I was setting up a table with this: EXCLUDE using gist (EXCLUDE using gist (grant_number_codes with &&) Where grant_numbers is a varchar[].  I get this error: ERROR:  d

Re: pgbouncer with ldap

e PAM's LDAP module to do what you want. Right, I had written a blog about it : https://severalnines.com/database-blog/one-security-system-application-connection-pooling-and-postgresql-case-ldap However, I always wished (since my first endeavors with pgbouncer) it was less complicated.

Re: pgbouncer with ldap

no experience with Aurora. He have been building from source for ages. On Mon, Sep 9, 2019, 6:46 AM Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>> wrote: On 9/9/19 12:41 μ.μ., Laurenz Albe wrote: > Christoph Moench-Tegeder wrote: >>> It has hba and via hba fi

Re: pgbouncer with ldap

Aurora DB service. Anyway I will give a try and let you know. On Thu, Sep 12, 2019 at 1:52 AM Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>> wrote: On 11/9/19 2:47 μ.μ., Ayub M wrote: Achilleas, for this setup to work are changes to postgresql.conf and pg_hba

Re: pgbouncer with ldap

enter you press. You might have to tweak data/pg_hba.conf as well in order to look for md5 passwords for this user from the pgbouncer machine. On Fri, Sep 13, 2019 at 6:50 AM Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>> wrote: On 13/9/19 10:19 π.μ., Ayub M wrote: Stumb

Re: Web users as database users?

enforced by the database. In this scenario, would it make sense to have a user account on the database to mirror the user account from the web app? Is that an unusual practice? I never regretted it. Just place pgbouncer in front and configure it right. -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom

Re: pgbouncer with ldap

. ldapsearch 2) /etc/ldap.conf : the conf file of libpam-ldap On Wed, Sep 18, 2019 at 9:48 AM Ayub M mailto:hia...@gmail.com>> wrote: Will do, thanks! On Wed, Sep 18, 2019, 4:55 AM Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>> wrote: Thanx I am really glad

Re: pgq is one of the most underrated pg related stuff

rn/issues>. Its kinda sad that we have late 2019 and LDAP foreign data wrapper support is no more. Luca -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Is my lecturer wrong about PostgreSQL? I think he is!

On 10/10/19 11:31 π.μ., Wim Bertels wrote: 3) Were there ever any problems with BSD? as far as i understand BSD and variants are very solid, so good for server use, not for desktop Desktop software might be a little old, but that does not mean that this is not usable. I run FreeBSD desk

Re: pgaudit log directory

either? pgaudit writes in the standard pgsql log. Can someone point me in the right direction? Thanks, Dave Hughes -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Exclude constraint on ranges : commutative containment : allow only complete containment

nt and economical way to express this. (besides writing a trigger which is always an option).| -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Exclude constraint on ranges : commutative containment : allow only complete containment

On 29/1/20 8:43 μ.μ., Michael Lewis wrote: If the new value does not overlap with any existing, allow. If it does overlap, then it must be fully contained by the existing element, or the existing element must be fully contained by it. Else, reject. Is that right? Exactly.

Re: Exclude constraint on ranges : commutative containment : allow only complete containment

On 29/1/20 8:32 μ.μ., Adrian Klaver wrote: On 1/29/20 8:12 AM, Achilleas Mantzios wrote: Hello Dear Postgresql ppl, I have a table with date ranges and need to express the following constraint : allow overlaps only if there is complete containment, e.g. allow values in rows like : [2020-01

Re: Exclude constraint on ranges : commutative containment : allow only complete containment

On 30/1/20 6:49 μ.μ., Adrian Klaver wrote: On 1/30/20 3:46 AM, Achilleas Mantzios wrote: On 29/1/20 8:32 μ.μ., Adrian Klaver wrote: On 1/29/20 8:12 AM, Achilleas Mantzios wrote: Hello Dear Postgresql ppl, I have a table with date ranges and need to express the following constraint : allow

Re: PL/pgSQL question about EXCEPTION clause & corrupt records

e to check for these kind of errors with a PL script? Or is there perhaps a better way to check for corrupt records in a database? Best regards, Nick Renders -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Rules versus triggers

eserve neither liberty nor safety."                                                 -- Benjamin Franklin -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: strange locks on PG 11 with Golang programs

reSQL but in golang libraries? Thank you for any suggestions Josef Machytka Berlin -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

easy way to acquire height / width from images (PNG, JPEG) stored as bytea?

Hello Dear List, we have a table holding email attachments as bytea, and we would like to filter out images of small dimensions, which are not of any value to our logic. I took a look at pg_image extension, tested it, and it proved problematic, it killed my 200+ days uptime FreeBSD box :( .

Re: easy way to acquire height / width from images (PNG, JPEG) stored as bytea?

On 17/4/20 4:09 μ.μ., Adam Brusselback wrote: Why not extract and store that metadata with the image rather than trying to extract it to filter on at query time? That way you can index your height and width columns to speed up that filtering if necessary. Yes I thought of that, but those are

Re: easy way to acquire height / width from images (PNG, JPEG) stored as bytea?

On 17/4/20 5:47 μ.μ., Steve Atkins wrote: If running an extension crashed your server you should look at how / why, especially if it corrupted your filesystem. That shouldn't happen on a correctly configured system, so the underlying issue might cause you other problems. Crashing postgresql,

Re: easy way to acquire height / width from images (PNG, JPEG) stored as bytea?

tackoverflow.com/questions/33602308/how-to-check-png-file-if-its-a-decompression-bomb Regards,  Imre Thank you  a lot Imre. Great info. Achilleas Mantzios <mailto:ach...@matrix.gatewaynet.com>> ezt írta (időpont: 2020. ápr. 17., P, 16:39): On 17/4/20 4:09 μ.μ., Adam Brussel

Re: serie of serie

On 18/4/20 10:18 π.μ., Olivier Leprêtre wrote: Hi, I would like to generate a serie of serie and didn’t find how.  With generate_series. I can generate a serie 1 1 1 2 2 2 3 3 3 But how can I repeat this serie several times ? 1 1 1 2 2 2 3 3 3 1 with foo as (select flo

Re: Oracle vs. PostgreSQL - a comment

part name, something sqlserver excels at. Maybe because SQL server does not have real databases but schemas instead ? This sucks security wise. -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Oracle vs. PostgreSQL - a comment

versions they solved this problem by the failover group concept which failovers all inter-related databases at one go. BTW Mysql treats databases and schemas as same (that's what it was few years ago) -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Oracle vs. PostgreSQL - a comment

On 5/6/20 5:19 μ.μ., Thomas Kellerer wrote: Achilleas Mantzios schrieb am 05.06.2020 um 14:05: Plus PG does not directly support cross database queries using 3 part name, something sqlserver excels at. Maybe because SQL server does not have real databases but schemas instead ? This sucks

Re: Multitenent architecture

/multitenancy-options-postgresql Thank you so much all. Regards, Vasu -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Creating many tables gets logical replication stuck

-- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: pgbouncer bug?

On 21/8/20 7:56 μ.μ., greigwise wrote: Not sure if this is the right place to post this, but if not someone please point me in the right direction. My issue is with pgbouncer 1.14. This does not seem to happen on 1.13. If I do a service pgbouncer restart, then anytime I try to connect to my

Re: Creating many tables gets logical replication stuck

created the very same problem during the latest attempts for reproduction but I did not focus on this scenario. The walsender process can get stuck. -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Doubt in pgbouncer

transaction mode (some PR's were rejected because of that). You might find this interesting : https://github.com/awslabs/pgbouncer-rr-patch regards, fabio pardi -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Can I get some PostgreSQL developer feedback on these five general issues I have with PostgreSQL and its ecosystem?

On 2/10/20 2:08 π.μ., tutilu...@tutanota.com wrote: On Thu, Sep 24, 2020 at 10:40 PM mailto:tutilu...@tutanota.com>> wrote: Well not partial as in incremental. Instead dump only some portion of the schema with or without its associated data. It's funny tha

What do you guys use for issue tracking, CI/CD and team management? any nice open source options?

/push, manages issues/projects/people ? I know I am asking a lot, any help welcome, thanks! -- Achilleas Mantzios DBA, Analyst, IT Lead IT DEPT Dynacom Tankers Mgmt

Re: What do you guys use for issue tracking, CI/CD and team management? any nice open source options?

On 16/4/22 6:39 π.μ., Michael Paquier wrote: On Thu, Apr 14, 2022 at 06:19:44PM +0300, Achilleas Mantzios wrote: What issue/bug tracking is PostgreSQL itself using? What continuous build system (CI/CD) is PostgreSQL itself using? Any tool that you ppl or the PostgreSQL infrastructure use that

pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity

s it, cept_report cept , dynacom.vessels vsl, machdefs md, cept_reportli mits ceptl where it.id=cept.id AND md.defid=ceptl.defid AND it.defid=md.defid AND it.vslwhid=vsl.id AND vsl.vs lstatus='Active' and md.application = 'Critical Equipment Performance Test' AND cept.systemdate>= (now()-'1 ye ar'::interval)  ORDER BY 1) select * from bar where NOT range @> val; -- good data here -- Achilleas Mantzios DBA, Analyst, IT Lead IT DEPT Dynacom Tankers Mgmt

Re: pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity

Thanks David Στις 19/7/22 17:19, ο/η David G. Johnston έγραψε: On Tuesday, July 19, 2022, Achilleas Mantzios wrote: ERROR:  cannot convert infinity to numeric -- has no problem testing against infinity select it.id <http://it.id> ,cept.value::numeric as val, nu

Re: pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity

Στις 19/7/22 17:23, ο/η Tom Lane έγραψε: "David G. Johnston" writes: On Tuesday, July 19, 2022, Achilleas Mantzios wrote: ERROR: cannot convert infinity to numeric The column cept.value contains an infinity. I see nothing unusual in any of these queries given that fact. If

Re: pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity

Thank you Adrian! Στις 19/7/22 18:36, ο/η Adrian Klaver έγραψε: On 7/19/22 03:38, Achilleas Mantzios wrote: I reformatted queries to see thing better. -- still has problem testing the range select it.id ,cept.value::numeric as val, numrange(ceptl.min_alarm::numeric,ceptl.max_alarm

Re: pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity

On 19/7/22 20:31, David G. Johnston wrote: On Tuesday, July 19, 2022, Achilleas Mantzios wrote: Thanks David Στις 19/7/22 17:19, ο/η David G. Johnston έγραψε: On Tuesday, July 19, 2022, Achilleas Mantzios wrote: ERROR:  cannot convert infinity to numeric

Re: pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity

On 19/7/22 20:32, Adrian Klaver wrote: On 7/19/22 10:26 AM, Achilleas Mantzios wrote: Thank you Adrian! Actually thank: https://sqlformat.darold.net/ Στις 19/7/22 18:36, ο/η Adrian Klaver έγραψε: On 7/19/22 03:38, Achilleas Mantzios wrote: I reformatted queries to see thing better

Re: PostgreSQL vs MariaDB

some commercial DBs lack. Thanks. Regards, /Inzamam Shafiq/ /Sr. DBA/ -- Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt

Re: doc sql-grant.html Synopsis error?

EMA twice ? -- Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt

Re: Guidance on INSERT RETURNING order

lect i.id from i order by id; +1 for this version! Sorry for the long email, Thanks Federico -- Achilleas Mantzios IT DEV - HEAD IT DEPT Dynacom Tankers Mgmt

Re: pg_basebackup / recovery

Στις 13/4/23 01:31, ο/η Michael Paquier έγραψε: On Wed, Apr 12, 2023 at 01:45:56PM +0300, Achilleas Mantzios - cloud wrote: On 4/12/23 12:32, Fabrice Chapuis wrote: During recovery process of a self contained backup, how postgres know to stop reading wal when consistency is reached? Because

Re: Copy data from DB2 (Linux) to PG

://pgloader.io/ Any other tool for this job? thanks. -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Logical replication hangs up.

rec/tot): 76/    76, tx:    5536495, lsn: 429/69E9CD00, prev 429/69E9CCB0, desc: DELETE off 83 KEYS_UPDATED , blkref #0: rel 1663/16421/38572 blk 40 The relation 38572 from list above is an ordinary non replicated table. Any help or advice how to diagnose/get it working is highly appreciated. Kind regards Ales Zeleny -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: LOG: incomplete startup packet

and the previous line should tell you the IP. Best Regards Paul -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

pgconf eu 2018 slides entry missing from https://wiki.postgresql.org/wiki/PostgreSQL_Related_Slides_and_Presentations

Hello, The pgconf eu 2018 entry is missing from https://wiki.postgresql.org/wiki/PostgreSQL_Related_Slides_and_Presentations . I am afraid the more time passes since the event the harder to get people post their slides there, so pls update this ASAP.

Re: PostgreSQL MVCC and alternative REDO implementation - my thoughts

On 18/11/18 2:04 μ.μ., Gerhard Wiesinger wrote: On 18.11.2018 12:14, Martín Marqués wrote: El 18/11/18 a las 04:49, Gerhard Wiesinger escribió: Hello, I just read that blog article and I think switching to REDO logic is not a good idea. I think you got it the other way around. Postgres im

Re: pgconf eu 2018 slides entry missing from https://wiki.postgresql.org/wiki/PostgreSQL_Related_Slides_and_Presentations

On 19/11/18 8:48 π.μ., Charles Clavadetscher wrote: Hello Achilleas -Original Message- From: Achilleas Mantzios Sent: Sonntag, 18. November 2018 12:23 To: pgsql-gene...@postgresql.org Subject: pgconf eu 2018 slides entry missing from https://wiki.postgresql.org/wiki

Re: pgconf eu 2018 slides entry missing from https://wiki.postgresql.org/wiki/PostgreSQL_Related_Slides_and_Presentations

;a=summary Patches very much accepted. :) Thanks! Stephen -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Reg: Query for DB growth size

i get the query or steps for how to check the Database growth in postgres. Thanks in advance. select pg_size_pretty(pg_database_size(current_database())); -- *Andreas Joseph Krogh* -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Transition Tables doesn´t have OID

On 1/12/18 6:51 μ.μ., PegoraroF10 wrote: ok then, help me to find alternatives to it. As I sad, sometimes whe change our PK, so using OID would be a smart way to have a join between old and new transition tables and we would like to use transition tables because each statement is a lot faster t

Re: Database corruption in cascaded replica, "pg_xact/003A" doesn't exist, reading as zeroes"

og file Any comments regarding the cascaded replication procedure or database corruption detection or resolution are welcome. Best regards, Dejan Petrovic ISL Online -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: finding out what's generating WALs

able to alert on absolute thresholds, does this always make sense? What's a good threshold to alert on? Regarding you wals in pg_wal,  a good threshold could be anything more than a e.g. 10% increase from wal_keep_segments with a trend to go up. If this number goes up chances are s

Re: why would postgres be throttling a streaming replication slot's sending?

On 12/12/18 3:45 μ.μ., Chris Withers wrote: On 11/12/2018 14:48, Achilleas Mantzios wrote: On 11/12/18 4:00 μ.μ., Chris Withers wrote: I'm looking after a multi-tenant PG 9.4 cluster, and we've started getting alerts for the number of WALs on the server. It'd be great to un

Re: logical replication resiliency

see no reason not to use it. You can have a look at an article I wrote here : https://severalnines.com/blog/using-postgresql-logical-replication-maintain-always-date-readwrite-test-server Thanks, Istvan -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Thoughts on row-level security for webapps?

tern for SQL security? Any gotchas relying on RLS? -- Siggy Bilstein CTO ofAyuda Care <https://www.ayudacare.com> Book some time <https://calendly.com/siggy-cto> with me! -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Use bytearray for blobs or not?

-- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Use bytearray for blobs or not?

On 4/1/19 6:02 μ.μ., Rob Sargent wrote: On 1/4/19 4:48 AM, Achilleas Mantzios wrote: On 4/1/19 1:41 μ.μ., Thomas Güttler wrote: Some months ago I wrote a little application with Python+Django which stores blob data in bytearrays. It works. In the future there will be a lot more traffic, and

Re: the installation of pgadmin4 makes me weep in frustration

thanks robert -- Robert Rottermann CEO 031 333 10 20 rob...@redo2oo.ch <mailto:rob...@redo2oo.ch> Sickingerstrasse 3, 3014 Bern <http://maps.apple.com/?q=Sickingerstrasse 3,3014 Bern> https://Redo2oo.ch <https://redo2oo.ch> *Ihr Partner wenn es um ERP Lösungen geht.*

Re: Oracke BLOB to Postgres BYTEA using ora2pg

mp all images (assuming again we are dealing with images here), then loop over each row and do the same as above. But it is essential that you know what those values represent. Are they pdf docs? images? binaries? octet-streams? Thank you for your help, -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: Barman versus pgBackRest

tal to full) transparently and asynchronously, e.g.via cron. I have read about the --repo-hardlink option. " This gives the appearance that each backup is a full backup at the file-system level " So could we just take a first full backup and then switch permanently to incr backups? -- Ac

Re: Barman versus pgBackRest

On 17/1/19 4:12 μ.μ., Jehan-Guillaume (ioguix) de Rorthais wrote: On Thu, 17 Jan 2019 13:09:18 +0200 Achilleas Mantzios wrote: Hello, One strong point of barman IMHO is transparently converting an incremental backup to a full backup for retention purposes, so retention specification is far

Re: Upgrading from 9.2.15 to 9.4.20

et under /run/postgresql/.s.PGSQL.50432 make sure that the dir is there as well. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: PostgreSQL logical replication depends on WAL segments?

y logical replication depends on some old WAL segments? Today's data seem to work perfectly although there cannot be all WAL segments for today available on the logical master. But I am unable to publish older data... Thanks for help. Josef Machytka -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

Re: PostgreSQL logical replication depends on WAL segments?

us runtime configuration params act on the number of WALs kept until the whole transfer of snapshot is done. Because only after the whole snapshot is transferred logical replication workers start to transfer WAL logs reflecting changes done from the moment snapshot was taken... jm -- Achilleas Mantz

Re: PostgreSQL logical replication depends on WAL segments?

On 22/1/19 8:59 μ.μ., Jeremy Finzel wrote: On Tue, Jan 22, 2019 at 12:52 PM Andres Freund > wrote: Hi, On 2019-01-22 11:10:27 -0600, Jeremy Finzel wrote: > P.S. do heed the advice of the others and get more familiar with the docs > around WAL arch

Re: PostgreSQL logical replication depends on WAL segments?

On 22/1/19 10:18 μ.μ., Jeremy Finzel wrote: On Tue, Jan 22, 2019 at 2:16 PM Jeremy Finzel > wrote: any one of those WAL files will not be archived and recycled as long as it no longer needed by a replication slot :(.  s/no longer/still.  I meant to sa

Re: PostgreSQL logical replication depends on WAL segments?

On 23/1/19 5:26 π.μ., Jeremy Finzel wrote: On Tue, Jan 22, 2019 at 8:19 PM Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>> wrote: On 22/1/19 10:18 μ.μ., Jeremy Finzel wrote: On Tue, Jan 22, 2019 at 2:16 PM Jeremy Finzel mailto:finz...@gmail.com>> wrote:

  1   2   3   >