and db-server_B?
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
think that the subscriber is down and will accumulate WALs
till some replication client is connected to it (which will not happen since the subscriber points to the standby).
Thanks!
Radoslav Nedyalkov
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
logical replication which should solve this I assume,
but it does not fit the schedule at the moment.
KR
Mikael Gustavsson
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
solutions. Will
post a link as soon as it gets published.
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
ster is low. On slave I can see the "logical replication worker" process is taking about 70% CPU
time on a single core, machine has 16 cores.
Is there a setting I am missing here? Any ideas appreciated.
Boris
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
On Mon, Feb 25, 2019 at 8:08 AM Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>> wrote:
On 25/2/19 8:52 π.μ., Boris Sagadin wrote:
Doing an initial replica and trying to find a bottleneck, Ubuntu 16.04,
NVMe disks, PgSQL v10.7, AWS. With binary replication, DB is replicated at
mpare
speed.
Please note that ppl here tend to not encourage top posting. Generally It's ok
for business emails elsewhere, but here straight quoting is better and more
accurate.
On Mon, Feb 25, 2019 at 9:51 AM Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>> wrote:
On 21/2/19 9:28 π.μ., Achilleas Mantzios wrote:
On 21/2/19 9:17 π.μ., Julie Nishimura wrote:
Does anyone use this solution? any recommenations?
Thanks!
Barman will fit most requirements. PgBackRest excels when WAL traffic goes on 10 files/day or more. I have written an article, not yet
barman and
pgbackrest would support it out of the box.
Just my 2c,
Edson Richter
/Enviado do meu Telefone LG/
-- Mensagem original------
*De: *Achilleas Mantzios
*Data: *qua, 27 de fev de 2019 06:40
*Para: *pgsql-general@lists.postgresql.org
<mailto:pgsql-general@lists.postgresql.org>;
On 27/2/19 4:16 μ.μ., David Steele wrote:
On 2/27/19 2:31 PM, Achilleas Mantzios wrote:
On 27/2/19 1:58 μ.μ., rich...@simkorp.com.br wrote:
Just to notice, I d o use backup from standby and WAL archive from standby. It is
possible. But you have to configure standby with option of wal archive
On 27/2/19 5:04 μ.μ., Edson Carlos Ericksson Richter wrote:
Em 27/02/2019 09:31, Achilleas Mantzios escreveu:
On 27/2/19 1:58 μ.μ., rich...@simkorp.com.br wrote:
Just to notice, I d o use backup from standby and WAL archive from standby. It is
possible. But you have to configure standby with
On 27/2/19 6:52 μ.μ., Mark Fletcher wrote:
On Wed, Feb 27, 2019 at 1:39 AM Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>> wrote:
Hello, as promised here is my blog :
https://severalnines.com/blog/current-state-open-source-backup-management-postgresql
Nice blog po
*
14 Rodborough Road, Frenchs Forest NSW 2086, Australia
*T* +61 2 9452 9027
na...@fast.au.fujitsu.com <mailto:na...@fast.au.fujitsu.com>
fastware.com.au <http://fastware.com.au/>
*From:*Achilleas Mantzios
*Sent:* Wednesday, 27 February 2019 8:40 PM
*To:* pgsql-general@lists.postgresql.or
te)
bytea. Keeping those in the filesys and trying to keep filesys in sync with the db is a PITA. Also dont know what happens in the transactional dept (ACID) with lo_* large objects. In most cases bytea
are just fine.
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
manne
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
://www.techmahindra.com/Disclaimer.html externally http://tim.techmahindra.com/tim/disclaimer.html internally within TechMahindra.
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom
and FreeIPA LDAP with our production PostgreSQL servers, I have tested
with openldap as well, so I guess chances are that it will work with yours.
Regards
Tarkeshwar
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
> Adrian Klaver
> > adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>
<mailto:adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>>
> <mailto:adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>
<mailto:adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>>>
> >
> >
> >
> > --
> >
> >
> >
> > Thanks,
> > Prakash.R
> > PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure
> Team On
> > call : +91-8939599426
>
>
> --
> Adrian Klaver
> adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>
<mailto:adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>>
>
>
>
> --
>
>
>
> Thanks,
> Prakash.R
> PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On
> call : +91-8939599426
--
Adrian Klaver
adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>
--
Thanks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call :
+91-8939599426
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
anks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call :
+91-8939599426
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
privileges on both
tables/schemas.
Kind regards
Thiemo
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
k making the sender-side loop busy, which prevents
keepalive packet from sending.
regards.
--
Kyotaro Horiguchi
NTT Open Source Software Center
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
gger-based replication systems (like Slony or Londiste or others) need a
connection or flow from subscriber to the provider ?
Thanks in advance
- Météo-France -
PALAYRET JACQUES
DCSC/MBD
jacques.palay...@meteo.fr
Fixe : +33 561078319
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
lain this behavioure?
if you bypass systemctl then systemd has no way to tell if the service is up or
down just by grep.
Best regards!
izum
Domen Šetar
/Computer Systems Support/
IZUM – Institute of Information Science| Prešernova ulica 17 | 2000 Maribor
|Slovenia/
/T: +386 2 2
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
ώτηση, νόμιζα είναι παγκόσμια λίστα μιλάμε αγγλικά ή ελληνικά;;;
oopps I just thought the greek list got resurrected, sorry, anyways thanks.
Tasos
*Sent:* Friday, June 07, 2019 at 11:44 AM
*From:* "Achilleas Mantzios"
*To:* pgsql-general@lists.postgresql.org
*Subject:* Re: Snowball Ste
-3TB.
Thanks for your help..!!!
Regards,
Pawan
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
, 2019 at 09:00:38AM +0300, Achilleas Mantzios wrote:
> On 10/6/19 7:36 π.μ., Pawan Sharma wrote:
>> What is the best way to upgrade from PostgreSQL 9.6 to PostgreSQL
>> 11 instead of pg_upgrade.
>
> why not pg_upgrade ? If the size is near the 3TB mark as y
ate the trigger function as SECURITY DEFINER and with a specific search_path. That didn't help either.
By now I am thinking there must be something missing in pglogical.
Thanks,
Torsten
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
On 24/6/19 12:20 μ.μ., Rahul Chordiya wrote:
Hi,
Sorry for delayed response.
Hello, did you use gcc or clang/llvm?
I would suggest trying with gcc.
*
*
*
*
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
to look at : pg_partitioned_table , pg_inherits
or just enable log_statement , issue \d+ and look at the SQL produced.
Or just do :
select inhrelid::regclass from pg_inherits where inhparent = 'your partitioned
table'::regclass;
Best,
Glenn
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
> In my case there is a fairly expensive INSERT Trigger ON EACH ROW, which
I would like to avoid.
The insert trigger will only be fired if an INSERT actually takes place.
If INSERT ON CONFLICT results in an UPDATE (or a DO NOTHING), no INSERT
trigger will be fired.
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
if any data is changed which was already copied over then it might be lost.
Regarding 2) you could setup a trigger on the original table which would also
replicate INSERTS, DELETES and UPDATES to the new table.
Any other approaches/alternatives?
--
Regards,
Ayub
--
Achilleas Mantzios
IT
s and libreoffice Impress. What tools
would you suggest ? What's your setup ?
Thank you!
Achilleas Mantzios
IT DEV - HEAD
IT DEPT
Dynacom Tankers Mgmt
Στις 22/10/23 10:06, ο/η Matthias Apitz έγραψε:
El día domingo, octubre 22, 2023 a las 08:50:10a. m. +0300, Achilleas Mantzios
escribió:
Hello All
I am going to give a talk about PostgerSQL, so I'd like to ask you people
what do you use for your presentations, also I have no idea ho
Στις 23/10/23 17:35, ο/η Tom Lane έγραψε:
Achilleas Mantzios - cloud writes:
someone added this section about inheritance :
Don't use table inheritance
That's one person's opinion. (Well, they're not alone in it, but
it's just an opinion not a considered communi
Στις 23/10/23 17:01, ο/η Alvaro Herrera έγραψε:
On 2023-Oct-23, Achilleas Mantzios - cloud wrote:
I believe this text is false on too many accounts. So, what's the consensus
about Inheritance in PostgreSQL, I am going to give a talk on it in November
and I wouldn't like to adverti
Στις 23/10/23 17:07, ο/η Christophe Pettus έγραψε:
On Oct 23, 2023, at 04:45, Achilleas Mantzios - cloud
wrote:
I believe this text is false on too many accounts. So, what's the consensus
about Inheritance in PostgreSQL, I am going to give a talk on it in November
and I wouldn'
Στις 23/10/23 19:54, ο/η Alvaro Herrera έγραψε:
On 2023-Oct-23, Achilleas Mantzios wrote:
I find PostgreSQL inheritance a great feature. The caveats are the same
since a long time, nothing changed in that regard, but as you say, the
implementation/limitations exist in native table partitioning
Στις 23/10/23 20:06, ο/η Laurenz Albe έγραψε:
On Mon, 2023-10-23 at 19:49 +0300, Achilleas Mantzios wrote:
Tom Lane wrote:
But there are valid use-cases where you
actually do want more columns in the child tables than the parent.
also data departmentalization, consolidation, multi-tenancy
Στις 23/10/23 19:58, ο/η Achilleas Mantzios έγραψε:
Στις 23/10/23 19:54, ο/η Alvaro Herrera έγραψε:
On 2023-Oct-23, Achilleas Mantzios wrote:
I find PostgreSQL inheritance a great feature. The caveats are the same
since a long time, nothing changed in that regard, but as you say, the
as well, I have to say. PostgreSQL
was presented as catching up MySQL in terms of usage/growth.
In some future similar events I'd love to prepare a better and more
current presentation for the local Greek community!
Στις 23/10/23 14:45, ο/η Achilleas Mantzios - cloud έγραψε:
Hello All
i
the community
can understand and refrain from giving external links for downloading
files. Many people won't click on your URL or hit the download button.
...
--
Achilleas Mantzios
IT DEV - HEAD
IT DEPT
Dynacom Tankers Mgmt
or a 2TB table conversion) :
https://www.percona.com/blog/performing-etl-using-inheritance-in-postgresql/
CG
--
Achilleas Mantzios
IT DEV - HEAD
IT DEPT
Dynacom Tankers Mgmt
Στις 22/11/23 15:14, ο/η CG έγραψε:
On Wednesday, November 22, 2023 at 01:20:18 AM EST, Achilleas Mantzios
wrote:
Στις 21/11/23 20:41, ο/η CG έγραψε:
I have a very large PostgreSQL 9.5 database that still has very large
tables with oids. I'm trying to get rid of the oids with as l
Στις 27/11/23 16:51, ο/η CG έγραψε:
On Wednesday, November 22, 2023 at 12:38:54 PM EST, Achilleas Mantzios
wrote:
Στις 22/11/23 15:14, ο/η CG έγραψε:
On Wednesday, November 22, 2023 at 01:20:18 AM EST, Achilleas Mantzios
<mailto:a.mantz...@cloud.gatewaynet.com> wrote:
Στις
Στις 7/3/24 17:13, ο/η Karsten Hilbert έγραψε:
Am Thu, Mar 07, 2024 at 04:56:18PM +0200 schrieb Achilleas Mantzios - cloud:
Python IMHO is too advanced, too rich,
Python _is_ powerful but it needn't be difficult.
weird indentation rules
A matter of taste IMO.
no simple for loop
R
Στις 7/3/24 18:25, ο/η Pavel Stehule έγραψε:
čt 7. 3. 2024 v 16:59 odesílatel Christophe Pettus
napsal:
> On Mar 7, 2024, at 06:56, Achilleas Mantzios - cloud
wrote:
> So, I ask, have there been any efforts to bring PL/PGSQL to the
terminal?
Strictly speaki
Στις 7/3/24 18:44, ο/η Robert Treat έγραψε:
On Thu, Mar 7, 2024 at 11:26 AM Pavel Stehule wrote:
čt 7. 3. 2024 v 16:59 odesílatel Christophe Pettus napsal:
On Mar 7, 2024, at 06:56, Achilleas Mantzios - cloud
wrote:
So, I ask, have there been any efforts to bring PL/PGSQL to the terminal
Στις 7/3/24 21:29, ο/η Adrian Klaver έγραψε:
On 3/7/24 10:13, Achilleas Mantzios wrote:
Στις 7/3/24 18:44, ο/η Robert Treat έγραψε:
I am not talking for fun. I am talking about the future programmers
of this world. Teaching Python or C to them upon arrival to the
classes seems so wrong in
ce part would be nice
to be handled in a more elegant manner, e.g. by an option in pg_dump to
dump only sequences, for "nearly zero" downtime upgrades, this step
should happen rapidly at the switchover.
Regards,
Koen De Groote
--
Achilleas Mantzios
IT DEV - HEAD
IT DEPT
Dynacom Tankers Mgmt (as agents only)
with my verification?
Thanks in advance &
Best regards,
Manuel
--
Achilleas Mantzios
IT DEV - HEAD
IT DEPT
Dynacom Tankers Mgmt (as agents only)
not sure how to
populate it.
am using PostgreSQL 13.xx in Debian.
In addition to the COMMENT advised by PostgreSQL friends above, you
might put your schema into some version control system, such as git, so
you can have all the info : why something was added/changed, by whom,
what for, etc.
il against the log and then implement some logic using
NOTIFY , ideally you want your procedure to be interrupted rather than
do polling.
Thanks,
Dennis
--
Achilleas Mantzios
IT DEV - HEAD
IT DEPT
Dynacom Tankers Mgmt (as agents only)
own try to cancel any query. The plpgsql routine should be
canceled without problems.
fast mode will have this effect. smart mode not, from my testing. The
running queries do not get interrupted in smart shutdown.
Thanks
On Fri, Jul 5, 2024 at 4:57 PM Achilleas Mantzios
wrote:
Στις 6/7/24 09:22, ο/η Pavel Stehule έγραψε:
so 6. 7. 2024 v 8:19 odesílatel Pavel Stehule
napsal:
so 6. 7. 2024 v 8:06 odesílatel Achilleas Mantzios
napsal:
Στις 6/7/24 08:39, ο/η Pavel Stehule έγραψε:
so 6. 7. 2024 v 1:36 odesílatel Dennis White
nt rows on the same data page.
--
Achilleas Mantzios
IT DEV - HEAD
IT DEPT
Dynacom Tankers Mgmt (as agents only)
Hi
for remote DDL execution (such as CREATE TABLE) is dblink my only option?
thanks
Στις 9/9/24 18:40, ο/η Tom Lane έγραψε:
Adrian Klaver writes:
On 9/9/24 03:24, Achilleas Mantzios - cloud wrote:
And the thing is that this creation via DDL is inside our design.
Certain users create some backup tables of the public data in their own
schema (via our app), then do some
Στις 10/9/24 20:22, ο/η Laurenz Albe έγραψε:
On Tue, 2024-09-10 at 12:20 +0300, Achilleas Mantzios - cloud wrote:
On 9/10/24 00:09, Laurenz Albe wrote:
On Mon, 2024-09-09 at 16:14 +0300, Achilleas Mantzios - cloud wrote:
The below runs on PostgreSQL 16.4
We are trying to implement a certain
Hello
I am imagining a system that can parse papers from various sources
(web/files/etc) and in various formats (text, pdf, etc) and can store
metadata for this paper ,some kind of global ID if applicable, authors,
areas of research, whether the paper is "new", "highlighted",
"historical", ty
Στις 5/6/21 1:52 μ.μ., ο/η Laura Smith έγραψε:
‐‐‐ Original Message ‐‐‐
On Saturday, 5 June 2021 10:49, Achilleas Mantzios
wrote:
Hello
I am imagining a system that can parse papers from various sources
(web/files/etc) and in various formats (text, pdf, etc) and can store
metadata
Στις 5/6/21 6:34 μ.μ., ο/η Adrian Klaver έγραψε:
On 6/5/21 2:49 AM, Achilleas Mantzios wrote:
Hello
I am imagining a system that can parse papers from various sources
(web/files/etc) and in various formats (text, pdf, etc) and can store
metadata for this paper ,some kind of global ID if
) with postgresql.
On Sat, 5 Jun 2021 at 5:14 PM Laura Smith
<mailto:n5d9xq3ti233xiyif...@protonmail.ch>> wrote:
Sent with ProtonMail Secure Email.
‐‐‐ Original Message ‐‐‐
On Saturday, 5 June 2021 12:14, Achilleas Mantzios
mailto:ach...@matrix.gatewaynet.co
Στις 5/6/21 8:03 μ.μ., ο/η Adrian Klaver έγραψε:
On 6/5/21 9:56 AM, Achilleas Mantzios wrote:
Στις 5/6/21 6:34 μ.μ., ο/η Adrian Klaver έγραψε:
On 6/5/21 2:49 AM, Achilleas Mantzios wrote:
Hello
I am imagining a system that can parse papers from various sources
(web/files/etc) and in
Στις 5/6/21 10:12 μ.μ., ο/η Adrian Klaver έγραψε:
On 6/5/21 10:39 AM, Achilleas Mantzios wrote:
Στις 5/6/21 8:03 μ.μ., ο/η Adrian Klaver έγραψε:
On 6/5/21 9:56 AM, Achilleas Mantzios wrote:
Στις 5/6/21 6:34 μ.μ., ο/η Adrian Klaver έγραψε:
On 6/5/21 2:49 AM, Achilleas Mantzios wrote
a
smarter way to achieve this in PostgreSQL than simply relying on logs
and commit timestamps?
You mean like trying to correlate pg_class.xmin with some timestamp via
track_commit_timestamp or other means?
Luca
--
Achilleas Mantzios
DBA, Analyst, IT Lead
IT DEPT
Dynacom Tankers Mgmt
On 25/11/21 6:12 μ.μ., Shaozhong SHI wrote:
Function difference not found.
Should an extension created for finding it?
fuzzystrmatch
Regards,
David
--
Achilleas Mantzios
DBA, Analyst, IT Lead
IT DEPT
Dynacom Tankers Mgmt
gree with you all of them should be deducted to a single letter s. Firefox's
find recognizes all three (Σ,σ,ς) as the same letter.
Thanks,
- jj
--
Achilleas Mantzios
DBA, Analyst, IT Lead
IT DEPT
Dynacom Tankers Mgmt
any damage caused
by any virus transmitted by this email. Thank you for your cooperation.
--
Achilleas Mantzios
DBA, Analyst, IT Lead
IT DEPT
Dynacom Tankers Mgmt
exactly the business as far data transfers and emails are concerned. It would be hard to uniformly manage data
transfers and emails in/out in a plain TCP/IP setup (rsync, ftp, etc, sendmail/exim4/postfix or other MTA).
--
Achilleas Mantzios
DBA, Analyst, IT Lead
IT DEPT
Dynacom Tankers Mgmt
t;id";
ELSE
DELETE FROM "BlockedItemAO" WHERE "SeenPosRef" = NEW."id";
END IF;
RETURN NEW;
END;
$BODY$
LANGUAGE plpgsql
COST 100;
DROP TRIGGER IF EXISTS block_item_cancel ON "SeenPosDO";
CREATE TRIGGER block_item_cancel
AFTER UPDATE OF "quantityCanceled"
ON "SeenPosDO"
FOR EACH ROW
WHEN ( NEW."providerRef" <> 1
AND
(
NEW."quantityCanceled" IS DISTINCT FROM OLD."quantityCanceled"
)
)
EXECUTE PROCEDURE block_item_cancel();
--
Achilleas Mantzios
DBA, Analyst, IT Lead
IT DEPT
Dynacom Tankers Mgmt
UPDATE "BlockedItemAO" SET
>>"blockedItem" = blockedItemLevel,
>>"modificationDate" = now()
>>WHERE "SeenPosRef" = NEW."id";
>>ELSE
&g
On 10/12/21 12:56 μ.μ., Marc Mamin wrote:
>
>-Original Message-
>From: Achilleas Mantzios
>Sent: Freitag, 10. Dezember 2021 11:36
>To: pgsql-general@lists.postgresql.org
>Subject: Re: What is the best way to redefine a trigger? (lock issue)
On 10/12/21 1:24 μ.μ., o1bigtenor wrote:
On Fri, Dec 10, 2021 at 3:24 AM Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>> wrote:
Hi
we are running some 140 remote servers (in the 7 seas via satellite
connections), and in each one of them we run:
- jboss
- post
all of what you paid for it. I have pile of software installed on my main
use system - - - I'm looking
for good stuff that works and far too much stuff in the programming world is
hype and not function!!)
Thanks, this is more than true.
Regards
--
Achilleas Mantzios
DBA, Analyst, IT Lead
IT DEPT
Dynacom Tankers Mgmt
Hi Adrian
On 10/12/21 6:01 μ.μ., Adrian Klaver wrote:
On 12/10/21 01:24, Achilleas Mantzios wrote:
Hi
The idea for future upgrades is to containerize certain aspects of the
software. The questions are (I am not skilled in docker, only minimal contact
with lxd) :
- is this a valid use
Hi Michael, Adrian
On 10/12/21 11:28 μ.μ., Adrian Klaver wrote:
On 12/10/21 12:06, Michael Lewis wrote:
On Fri, Dec 10, 2021, 2:24 AM Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>> wrote:
Hi
we are running some 140 remote servers (in the 7 seas via satellite
conne
ubles because of unreliable system setup in the past, that I'd
hate to repeat the same (or similar) mistakes again.
--
Achilleas Mantzios
DBA, Analyst, IT Lead
IT DEPT
Dynacom Tankers Mgmt
Hi Rainer,
On 13/12/21 11:50 π.μ., Rainer Duffner wrote:
Am 10.12.2021 um 13:01 schrieb Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>>:
On 10/12/21 1:24 μ.μ., o1bigtenor wrote:
On Fri, Dec 10, 2021 at 3:24 AM Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com&g
Hi Berto,
On 13/12/21 3:03 μ.μ., Bèrto ëd Sèra wrote:
On Mon, 13 Dec 2021 at 12:41, Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>> wrote:
Hmm, I don't know about that. The hardware is given (existing) and limited.
You are like the 2nd person who warned about com
ion of pgsql on the ships.
So apps are much more frequently upgraded than the system of pgsql.
I will check out rolling upgrades with kubernetes. (are we talking BDR here?)
On Mon, Dec 13, 2021, 11:03 AM Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>> wrote:
Hi Berto,
On 13/12/21 5:55 μ.μ., Adrian Klaver wrote:
On 12/13/21 03:41, Achilleas Mantzios wrote:
Hi Rainer,
On 13/12/21 11:50 π.μ., Rainer Duffner wrote:
So Docker is NOT free? Please share your thoughts? I am a complete noob.
Take a look here:
https://www.docker.com/pricing
Thank you Adrian
Thank you Rainer,
I'll have to play a little bit myself, and read some serious docs about it, in
order to fully comprehend your thoughts.
I'll revisit your positions I hope.
On 13/12/21 5:11 μ.μ., Rainer Duffner wrote:
Am 13.12.2021 um 12:41 schrieb Achilleas Mantzios
Στις 2/1/22 2:23 μ.μ., ο/η ourdiaspora έγραψε:
Recipients,
A table was created:
CREATE TABLE exampletable (
name varchar(200)
);
Table 'exampletable' _already_ contains data, e.g. 'Jane Bloggs'
A new table was created with inheritance of 'exampletable':
Please could someone explain why the
Στις 4/1/22 5:47 μ.μ., ο/η Avi Weinberg έγραψε:
Is it possible to specify the publication name to be refreshed in case
I do not want to refresh all publications of the subscription?
Something like:
alter subscription subscription_name refresh publication publication_name
Here is the method:
Quadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
17-12-08&utm_source=Sailthru&utm_medium=email&utm_campaign=InfoWorld%20App%20Dev%20Report%202017-12-08&utm_term=infoworld_developer
Nice article :)
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
does pgbench generate and use? thats totally configurable with commandline parameters, from a few dozen
kilobytes to many gigabytes.
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
on in thier work and it will simplify the process. Percentage calculation is considered a basic math operation and I think postgresql
should support it as a build-in function.
Seems like easy to implment isn't it?
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
On 20/12/2017 21:42, Mike Feld wrote:
Is this the only alternative to secure authentication since Postgres does not
support secure ldap (ldaps)?
Have you checked out : |ldaptls||| parameter ?
https://www.postgresql.org/docs/10/static/auth-methods.html#AUTH-LDAP
--
Achilleas Mantzios
IT DEV
nabled trigger, then by setting session_replication_role to replica will
prevent the trigger from firing. This could be useful in the code where you execute SQL originating from the master, in order not to send those back and cause an endless loop.
Thanks,
Luca
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
are trying
to solve.
Why recreate triggers, indexes and functions after server startup instead of
leaving them?
Why create needless traffic?
Konrad
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
On 31/01/2018 15:22, Konrad Witaszczyk wrote:
On 01/31/2018 14:03, Achilleas Mantzios wrote:
On 31/01/2018 14:45, Konrad Witaszczyk wrote:
Hi,
I'm considering changing my database schema upgrade routines to recreate
functions and all objects depending on them (e.g. triggers, views) just
dont make heavey use of RULEs, but I think they have their place.
David J.
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
Στις 16/10/24 22:55, ο/η Ron Johnson έγραψε:
On Wed, Oct 16, 2024 at 3:37 PM Andy Hartman
wrote:
I am very new to Postgres and have always worked in the mssql
world. I'm looking for suggestions on DB backups. I currently have
a DB used to store Historical information that has imag
Στις 16/10/24 23:02, ο/η Ron Johnson έγραψε:
On Wed, Oct 16, 2024 at 4:00 PM Achilleas Mantzios
wrote:
Στις 16/10/24 22:55, ο/η Ron Johnson έγραψε:
On Wed, Oct 16, 2024 at 3:37 PM Andy Hartman
wrote:
I am very new to Postgres and have always worked in the mssql
Στις 16/10/24 19:47, ο/η Tom Lane έγραψε:
Bruce Momjian writes:
On Wed, Oct 16, 2024 at 06:16:57PM +0200, mb...@mbork.pl wrote:
`ps auxe` shows all processes with their environments, no?
I think that only shows for super-user.
I believe it depends on your platform --- some BSDen are pretty
Στις 22/10/24 18:54, ο/η Colin 't Hart έγραψε:
Hi,
This works in Postgres 15:
pg15> create function json_test(out value text, out json jsonb)
returns record
language sql
as
$$
select null::text, null::jsonb;
$$
;
CREATE FUNCTION
pg15> select * from json_test();
┌───┬──┐
│ value │ jso
Στις 8/11/24 20:16, ο/η Christophe Pettus έγραψε:
On Nov 8, 2024, at 10:12, jayesh thakare wrote:
Can we upgrade postresql from 13 to 15.4 directly?
Can we upgrade postgresql from 13 to 16 directly?
Yes.
Ideally how many major version can we jump to from older version ?
There's no practi
Στις 16/11/24 18:09, ο/η Adrian Klaver έγραψε:
On 11/16/24 03:15, Achilleas Mantzios wrote:
Στις 16/11/24 12:55, ο/η Max Ulidtko έγραψε:
Greetings, group!
I'm trying to understand a low-level issue. Am evaluating a new
client library for Postgres; it's not particular
101 - 200 of 271 matches
Mail list logo
