. jan. 30., Cs, 17:20):
On Thu, Jan 30, 2020 at 04:51:02PM +0100, Durumdara wrote:
> Is there any advance when I split updates? I'm in one transaction.
In this case - no. The benefit of split updates is when you're not in
single transaction.
Why would you want
ingle error will rollback the entire operation.
COPY also uses it's own method for transferring data. For all the
details see:
https://www.postgresql.org/docs/12/protocol-flow.html#PROTOCOL-COPY
matthias
--
Adrian Klaver
adrian.kla...@aklaver.com
.
My guess is because it just a minor version upgrade and all its doing is
upgrading the binaries.
George
--
Adrian Klaver
adrian.kla...@aklaver.com
(0,1) |11 | 1 |
(0,3) |12 | 4 | 02/02/2020 13:03:21
(2 rows)
NOTE: UPDATE 1 and ctid change.
Any body can help with some hint ? Also I want to know why my first
function does not work, probably loop is happened if trigger does not
stop update to be sent to table on r
e the
methods available here:
https://www.postgresql.org/docs/12/auth-pg-hba-conf.html
--
Adrian Klaver
adrian.kla...@aklaver.com
closest one can achieve
Make a connection from pgAdmin and see.
is to have a daemon process wake up every 1 min or so and terminate any pgadmin
app.
I can do a lot of damage in a minute.
--
Adrian Klaver
adrian.kla...@aklaver.com
tical SQL' by Anthony
DeBarros.)
A second question is: When I try to edit anything in pgAdmin, sometimes
it won't let me edit the code. I then refresh the database in the left
pane and then it allows me to edit the SQL in the query pane.
Thank you for any help you may provide.
Chris
it doesn't change to 'running'.
What does the Windows system log show when you do this?
On Mon, Feb 3, 2020 at 3:26 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 2/3/20 12:20 PM, Chris Charley wrote:
> I just got my Windows 10 computer in N
wer-is-and-how-you-can-use-it/
--
Adrian Klaver
adrian.kla...@aklaver.com
4:02 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 2/3/20 12:54 PM, Chris Charley wrote:
> /What does the Windows system log show when you do this?/
>
> I don't know where to find this log (for Windows 10)
>
I'm not a
However,
I'm not sure why the above issue occurred.
LOCK TABLE containers IN SHARE ROW EXCLUSIVE MODE;
Does anyone have any ideas?
Thanks,
Doug
--
Adrian Klaver
adrian.kla...@aklaver.com
sed_weight_check)
WHERE uid = in_uid
Thanks,
Doug
On Mon, Feb 3, 2020 at 4:49 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 2/3/20 1:43 PM, Doug Roberts wrote:
> Hello,
>
> I'm having an issue where a process in Post
On 2/3/20 3:16 PM, Chris Charley wrote:
I tried items you suggested (1-5), but could find no helpful info.
Well in that case I would try a reinstall.
Thanks for your help and going the extra mile!
On Mon, Feb 3, 2020 at 4:23 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>&
=0. So the
reset recirc function with take a UID (1000 for example) and use
that to remove 1000=x from all of the recirc counts for all of
the containers that have 1000=x.
We are currently using PG 12.0.
Thanks,
Doug
On Mon, Feb 3, 2020
Doug
On Mon, Feb 3, 2020 at 6:21 PM Tom Lane <mailto:t...@sss.pgh.pa.us>> wrote:
Adrian Klaver mailto:adrian.kla...@aklaver.com>> writes:
> Please reply to list also.
> On 2/3/20 2:18 PM, Doug Roberts wrote:
>> Here is what the reset recirc fu
he error there.
--
Adrian Klaver
adrian.kla...@aklaver.com
7;s meta commands, either.
Except they can be found by doing \?
-1
-1 from me.
Thank you for voting.
--
Adrian Klaver
adrian.kla...@aklaver.com
mployee;
END; $$
LANGUAGE 'plpgsql';
Can you pls help! I did more researches but no luck.
Thanks!
--
Adrian Klaver
adrian.kla...@aklaver.com
ter if it is just
"DEALLOCATE" or "DEALLOCATE PREPARE".
We put in the count statement to make sure the prepared statement still
existed and only issued the "DEALLOCATE" if ps_count is greater then
zero.
Does anybody know why it is giving this syntax error?
TIA,
Rob
--
Adrian Klaver
adrian.kla...@aklaver.com
the same. is there any
complication on this?
Not that I am aware of. To learn more about it's purpose:
https://www.postgresql.org/docs/12/protocol-replication.html
thx
--
Adrian Klaver
adrian.kla...@aklaver.com
logged:
Has anyone noticed anything like this before? Any idea how to fix this?
Was the upgrade on the same machine?
Or was the machine also upgraded/updated?
I ask as there have been similar reports having to with changes in glibc
version affecting collation.
Best regards,
Nick
/Generating_a_stack_trace_of_a_PostgreSQL_backend
We upgraded over the weekend because we experienced a crash on our
production server with “toast” issues as result.
Thanks in advance,
Marc
--
Adrian Klaver
adrian.kla...@aklaver.com
Marc
On 8 Feb 2020, at 22:18, Adrian Klaver wrote:
On 2/8/20 12:28 PM, Marc wrote:
Adrian,
Everything was a clean install ( MacOS Mojave and Postgres )
Export and import were done with the latest version of PGAdmin.
Please advise if we can provide you wit
ade because the old and new clusters will not be
running at the same time. However, when checking an old running server,
the old and new port numbers must be different."
Have I missed an option?
Not a required one. Best way to find out is to run --check.
Rich
--
Adri
nd data respectively.
Rich
--
Adrian Klaver
adrian.kla...@aklaver.com
On 2/10/20 4:07 PM, Rich Shepard wrote:
On Mon, 10 Feb 2020, Adrian Klaver wrote:
What it is saying is -b and -d are pointing at binary and data
directories
that are incompatible. You need to make sure that:
/usr/lib64/postgresql/11/bin/
and
/var/lib/pgsql/11/data
are actually pointing at
o the EntityFramework6.Npgsql community
Thanks!
Vikram
--
Adrian Klaver
adrian.kla...@aklaver.com
On 2/11/20 5:43 AM, Rich Shepard wrote:
On Mon, 10 Feb 2020, Adrian Klaver wrote:
So you already have 11 and 12 instances of Postgres running?
Adrian,
No. Both 11 and 12 are installed; neither is running. I have a cron job
that
runs pg_dumpall every weekday night
If so why use
On 2/11/20 8:35 AM, Vikram Sah wrote:
Got it sir, but unfortunately they have not provided any solution for
the last 5 days.
Where have you asked besides here?
Thanks
On Tue, 11 Feb 2020, 10:12 pm Adrian Klaver, <mailto:adrian.kla...@aklaver.com>> wrote:
On 2/11/20 3:56 A
On 2/11/20 9:00 AM, Rich Shepard wrote:
On Tue, 11 Feb 2020, Adrian Klaver wrote:
The above runs the psql client not the server. It is a way of determining
what version binaries /usr/lib64/postgresql/11/bin/ actually contains.
Adrian,
Aha! Running the command taught me a couple of valuable
ANTED BY %s", fmtId(grantor));
}
fprintf(OPF, ";\n");
Andrus.
--
Adrian Klaver
adrian.kla...@aklaver.com
your new cluster.
Jason Ralph
--
Adrian Klaver
adrian.kla...@aklaver.com
ULL. For more information see:
Thanks for the helpful response @Adrian Klaver,
Let me try to rephrase my question,
If a table has bloat before the upgrade, autvacuum was not aggressive enough,
once pg_upgrade is complete, the same table will contain the same amount of
bloat(dead tuples)? Mean
nt to output the bloat ratio instead (how many times larger
the relation is compared to how large it should be),..."
So I'm pretty sure bloat is where tbloat > 1.0.
Best,
*Jason Ralph*
*From:* Michael Lewis
*Sent:* Thursday, February 13, 2020 1:02 PM
*To:* Adrian Klaver
*Cc:*
On 2/13/20 12:45 PM, Jason Ralph wrote:
@Adrian Klaver,
I was concerned with the 1.4 value of tbloat and wastedbytes value, then again
the last autovacuum was at 2020-02-13 02:25:22.533372-05 and I took this
snapshot at 3:44PMEST. So it may be ok, what do you think?
What is your concern
ould start by looking in the system log to see what it records when
the service tries to start on reboot.
Thanks,
Jason
--
Jason M. Swails
--
Adrian Klaver
adrian.kla...@aklaver.com
On 2/13/20 9:02 PM, Adrian Klaver wrote:
On 2/13/20 7:54 PM, Jason Swails wrote:
Hi,
I've been struggling with a strange (to me) issue for awhile. I have
PostgreSQL 11.6 installed on my Ubuntu machine with the data directory
living on a different drive than the one mounted on /.
On 2/17/20 7:17 AM, Jason Swails wrote:
On Sun, Feb 16, 2020 at 8:51 AM Peter J. Holzer <mailto:hjp-pg...@hjp.at>> wrote:
On 2020-02-13 21:03:48 -0800, Adrian Klaver wrote:
> On 2/13/20 9:02 PM, Adrian Klaver wrote:
> > On 2/13/20 7:54 PM, Jason Swails wro
till be rebuilt. Adding or removing a system oid
column also requires rewriting the entire table. Table and/or index
rebuilds may take a significant amount of time for a large table; and
will temporarily require as much as double the disk space."
Thanks!
Jeremy
--
Adrian Klaver
adrian.kla...@aklaver.com
IST [2051] STATEMENT: SELECT
pgpool_pgctl('stop', 's')
what I can do please
Probably best to ask here:
https://www.pgpool.net/mailman/listinfo/pgpool-general
--
Adrian Klaver
adrian.kla...@aklaver.com
Y) in order for created policies
to be applied."
__
Marc
--
Adrian Klaver
adrian.kla...@aklaver.com
cond being the else above. See here [1]
John
[1] - https://www.postgresql.org/docs/current/functions-conditional.html
--
Adrian Klaver
adrian.kla...@aklaver.com
ame of the sender, nor anything else in this message is intended
to constitute an electronic signature unless a specific statement to the
contrary is included in this message. /
--
Adrian Klaver
adrian.kla...@aklaver.com
led on the machine?
Brian
-Original Message-----
From: Adrian Klaver
Sent: Tuesday, February 18, 2020 3:49 PM
To: Bellrose, Brian ;
pgsql-general@lists.postgresql.org
Subject: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1
On 2/18/20 11:39 AM, Bellrose, Brian wrote:
In the
installed?
Brian
-Original Message-
From: Adrian Klaver
Sent: Tuesday, February 18, 2020 4:19 PM
To: Bellrose, Brian ;
pgsql-general@lists.postgresql.org
Subject: Re: [EXTERNAL]: Re: pglogical install errors openSUSE Leap 42.1
On 2/18/20 12:54 PM, Bellrose, Brian wrote:
Yes, I understand
need to play Whack-a-Mole with
devel libraries.
I am curious how you got to 9.4.25 via an update, given that this
Postgres version was released well past the OS EOL?
Brian
-Original Message-
From: Adrian Klaver
Sent: Tuesday, February 18, 2020 4:41 PM
To: Bellrose, Brian ;
pgsql
. Moving all these to RHEL 8.1 and Postgres 11.7. Going to
use pglogical to try and reduce downtime.
Well that is interesting:
https://build.opensuse.org/project/show/home:vjt:ifad
a UN agency:
https://www.ifad.org/en/about
Brian
--
Adrian Klaver
adrian.kla...@aklaver.com
on update.
Not sure that a BEFORE trigger will work for that anyway as it will not
have submitted the data yet for ON CONFLICT resolution.
Ted
--
Adrian Klaver
adrian.kla...@aklaver.com
accessing the other function.
This led me to the assumption that the database was “somehow” damaged.
Thanks,
Albrecht.
--
Adrian Klaver
adrian.kla...@aklaver.com
nning, and terminate them.
--
Adrian Klaver
adrian.kla...@aklaver.com
.
Andrus.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 2/20/20 1:03 PM, Ted Toth wrote:
On Thu, Feb 20, 2020 at 2:32 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
On 2/20/20 12:17 PM, Ted Toth wrote:
> I'm a little confused why the before insert trigger fires al all but
> since it does is ther
ity Intelligence Update for Microsoft Endpoint Protection - KB 2461484
with different version numbers.
So did the issue show up after the above updates?
image
Andrus.
--
Adrian Klaver
adrian.kla...@aklaver.com
er is psqlODBC driver 09.00.0101,
which I believe is pre-libpq, so libpq connections seem to work.
--
Adrian Klaver
adrian.kla...@aklaver.com
erver
Previously, libpq was only used for authentication. Using it for
all communication lets us remove a lot of duplicated code. libpq is now
required for building or using libpq.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 2/20/20 2:48 PM, Ron wrote:
On 2/20/20 4:35 PM, Adrian Klaver wrote:
On 2/20/20 2:29 PM, Andrus wrote:
Hi!
>Then what changes were done recently, in particular ODBC-related.
Same psqlODBC driver 09.00.0101 has worked 10 years.
Previously I logged into this server long time ago and then
d without error.
Andrus.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 2/21/20 9:55 AM, Albrecht Dreß wrote:
Am 20.02.20 21:41 schrieb(en) Adrian Klaver:
It would be nice to know what:
[snip]
represented in:
Dropping and re-creating the function is actually the last operation in
the script. The function is /very/ simple (just a wrapper to hide all
);
drop_table is defined as
CREATE OR REPLACE FUNCTION drop_table(TEXT)
RETURNS VOID STRICT LANGUAGE plpgsql AS $$
BEGIN
EXECUTE 'DROP TABLE ' || $1;
EXCEPTION WHEN UNDEFINED_TABLE THEN
RETURN;
END;
$$;
Andrus.
--
Adrian Klaver
adrian.kla...@aklaver.com
ndle_pgres_error]902: error message=server
closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
(137)
Andrus.
*From:* Justin
*Sent:* Friday, February 21, 2020 8:44 PM
*To:* Andrus
*Cc:* Alvaro Herrera ; A
process to reset the stats.
See here:
https://www.postgresql.org/docs/12/monitoring-stats.html
Table 27.20. Additional Statistics Functions
It details what your options are.
Thanks.
Postggen.
--
Adrian Klaver
adrian.kla...@aklaver.com
Edson
--
Adrian Klaver
adrian.kla...@aklaver.com
isedb |
(1 row)
conndb=# select schemaname,tablename,tableowner,tablespace from
pg_tables where tablename='company_new';
schemaname | tablename | tableowner | tablespace
+-+--+
conndb | company_new | enterprisedb |
--
On 2/22/20 10:05 AM, Edson Richter wrote:
*De:* Adrian Klaver
*Enviado:* sábado, 22 de fevereiro de 2020 14:33
*Para:* Edson Richter ; pgsql-general
*Assunto:* Re: Replication: slave server has 3x
y mostly from well in the past?
Regards,
Edson
>
>
> Edson
>
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Adrian Klaver
adrian.kla...@aklaver.com
x27;t just check the value.
I'd like to do a raise NOTICE, if the default portion of the coalesce fires.
Anyone have a good way to accomplish this?
No.
--
Adrian Klaver
adrian.kla...@aklaver.com
send semicolon before SELECT
statement.
Andrus.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 2/22/20 11:23 AM, Edson Richter wrote:
*De:* Adrian Klaver
*Enviado:* sábado, 22 de fevereiro de 2020 16:16
*Para:* Edson Richter ; pgsql-general
*Assunto:* Re: Replication: slave server has 3x
to say the hand writing is
on the wall and it is time to upgrade software.
https://stackoverflow.com/questions/60357505/how-to-fix-psqlodbc-driver-regression-to-get-error-message-details
Andrus.
--
Adrian Klaver
adrian.kla...@aklaver.com
from postgres log file.
Postgres 12.2 and latest psqlODBC driver 12.01. are used.
psqlODBC is called from Visual FoxPro
What does the log_error_verbosity setting in postgresql.conf show?
Andrus.
--
Adrian Klaver
adrian.kla...@aklaver.com
icate that the streaming is working?
Yes, streaming is working properly (as stated above).
Thanks,
Edson Richter
--
Adrian Klaver
adrian.kla...@aklaver.com
On 2/22/20 3:28 PM, Ron wrote:
On 2/22/20 5:12 PM, Adrian Klaver wrote:
On 2/22/20 2:39 PM, Andrus wrote:
[snip]
This is a different issue and involves a product VFP that is EOL 5-10
years depending on support package. I'm going to say the hand writing
is on the wall and it is ti
. That can be corrected with an
ANALYZE. The questions I have are:
What is the issue you are trying to deal with?
Also why do you think resetting the stats will fix it?
Thanks,
Postgann.
On Sat, Feb 22, 2020 at 10:47 PM Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
O
ut application shows only
ERROR: insert or update on table "rid" violates foreign key constraint
"rid_yhik_fkey"
I don't have an answer for you. There maybe someone else on this list
that could help, though I think your best bet would be to ask the
question again o
On 2/23/20 8:04 AM, Edson Richter wrote:
*De:* Adrian Klaver
*Enviado:* sábado, 22 de fevereiro de 2020 20:34
*Para:* Edson Richter ; pgsql-general
*Assunto:* Re: Replication: slave server has 3x
On 2/23/20 10:19 AM, Adrian Klaver wrote:
On 2/22/20 6:40 PM, postggen2020 s wrote:
Thanks Adrian.
I am aware about the functions. Here need is, can we use this?.or is
there any known effects after firing the functions?.
Yes the stats counters will be reset to 0, which means the planner will
ion change with
the upgrade?
2) How was the server installed from packages(if so from where?) or from
source?
3) The configuration for LDAP in pg_hba.conf.
4) Pertinent information from the Postgres log.
5) Pertinent information from the system log.
Regards,
Mani.
--
Adrian Klaver
[unknown],db=[unknown] LOG:
connection received: host=xx.xx.xx.xx port=58524
2020-02-24 21:58:31 MST [117632]:
application=[unknown],host=xx.xx.xx.xx(58524),user=Someuser,db=test_db
LOG: connection authorized: user=Someuser database=test_db
We also have a local .ldaprc file
.
T8071_ADD_DM and old.ivo_sts_cd != 10 and old.ivo_sts_cd != 3;
end if;
RETURN NEW;
END
$function$;
Can someone please help where I am missing ..
Does the table dbo.t8096_cai_ivo_exc have the field ivo_sts_cd?
Thanks,
Sonam
--
Adrian Klaver
adrian.kla...@aklaver.com
ove to quickly. I do not see a SET, nor am
I clear what table you are trying to UPDATE.
end if;
RETURN NEW;
END
$function$;
Can someone please help where I am missing ..
Thanks,
Sonam
--
Adrian Klaver
adrian.kla...@aklaver.com
On 2/25/20 9:08 AM, Alban Hertroys wrote:
On 25 Feb 2020, at 17:53, Adrian Klaver wrote:
On 2/25/20 12:01 AM, Sonam Sharma wrote:
I have a trigger, like many other triggers that fire after
update and checks a field of the OLD set. For some reason this trigger throw
this error:
ERROR
?
Regards,
Mani.
On Tue, 25 Feb, 2020, 9:24 pm Adrian Klaver, <mailto:adrian.kla...@aklaver.com>> wrote:
On 2/24/20 9:07 PM, Mani Sankar wrote:
Please reply to list also.
Ccing list.
> Hi Adrian,
>
> Thanks for replying. Below are the
could also turn up the logging detail in Postgres to see if it
reveals anything.
Regards,
Mani.
--
Adrian Klaver
adrian.kla...@aklaver.com
2.0.42), 64-bit
PostgreSQL 12.1 on x86_64-apple-darwin16.7.0, compiled by Apple LLVM
version 8.1.0 (clang-802.0.42), 64-bit
--
Adrian Klaver
adrian.kla...@aklaver.com
On 2/26/20 11:37 AM, Albrecht Dreß wrote:
Sorry for the late reply, I've been on a short vacation…
Am 21.02.20 21:44 schrieb(en) Adrian Klaver:
1) From your original post what does the below mean?:
-- add several db functions
One trigger function, plus two “normal” ones, all (yet) u
lto:i...@arcict.com> www.arcict.com
<http://www.arcict.com>
tel. : +32 (0)2 466 50 00 fax. : +32 (0)2 466 88 33
--
Adrian Klaver
adrian.kla...@aklaver.com
?
Asked and answered:
https://www.postgresql.org/message-id/CAKFQuwY=wxxlzbjmv5ulk4p4b5sf+fnzxwthp-ugere-nxe...@mail.gmail.com
--
Adrian Klaver
adrian.kla...@aklaver.com
-+--
1 | 5896a9e3efa53027873d7999e58904ae | TRGEB
2 | 9f9677c32a64b6eae73759a69e1acfff | TFQHG
3 | 5aefda5b498215065e01ba697d79caee | KYBZS
4 | 1605b7fa54fef9bdc5c49f9b79810e07 | EUDML
5 | 4ba59880c1c67bca1d1f184bda5350b6 | RFPGO
regards, tom lane
--
Adrian Klaver
adrian.kla...@aklaver.com
hat I
need t do this in the docs, but I can't quite figure out if I can get this
down to what column(s) a given trigger will modify. Is this possible?
Before you get too far into this I would look at RLS:
https://www.postgresql.org/docs/12/ddl-rowsecurity.html
--
Adrian Kl
On 3/2/20 12:28 PM, stan wrote:
On Mon, Mar 02, 2020 at 11:02:54AM -0800, Adrian Klaver wrote:
On 3/2/20 10:59 AM, stan wrote:
I need to implement a fairly fine grained security model. Probably a bit
finer that I can do with the standard ownership functionality.
My thinking on this is to
}
}
My question here is: How I could get a copy of the document
ftp://sqlstandards.org/SC32/SQL_Registry/
Any copy available here in this list? Thanks
All I could find:
https://grokbase.com/t/perl/dbi-users/074q99ddsn/registry-of-values-for-ansi-x3-135-and-iso-iec-9075-sql-standards
matthias
--
Adrian Klaver
adrian.kla...@aklaver.com
to to the appropriate ones, but
unfortunately to the best of my knowledge, I cannot INSERT/UPDATE a table
through a view.
Am I suffering from a lack of knowledge here?
Yes:
https://www.postgresql.org/docs/12/sql-createview.html
Updatable Views
--
Adrian Klaver
adrian.kla...@aklaver.com
x27;t supported will it ever be? What are
the reasons for not supporting the Graphical Query Builder? Why was it
supported in pgAdmin III and not pgAdmin 4?
You might get an answer sooner on this list:
https://www.postgresql.org/list/pgadmin-support/
Thanks.
--
Adrian Klaver
adrian.kla...@aklaver.com
On 3/3/20 1:32 PM, stan wrote:
Please reply to list also.
Ccing list
On Tue, Mar 03, 2020 at 10:48:29AM -0800, Adrian Klaver wrote:
On 3/3/20 9:42 AM, stan wrote:
On Mon, Mar 02, 2020 at 01:44:52PM -0700, David G. Johnston wrote:
On Mon, Mar 2, 2020 at 1:28 PM stan wrote:
Envision a table
On 3/3/20 3:06 PM, David G. Johnston wrote:
On Tue, Mar 3, 2020 at 3:48 PM Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote:
The link was for automatically updateable views. If you want to do
something more involved then see:
https://www.postgresql.org/docs
-+--
olleg | olleg
public | postgres
(2 rows)
I believe this is the latest information on public schema handling:
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=5955d934194c3888f30318209ade71b53d29777f
--
Adrian Klaver
adrian.kla...@aklaver.com
ase into
spreadsheet via ODBC.
Do you use a programming language?
If so use its libraries to pull data out and into CSV or directly into a
spreadsheet.
Your inputs are highly appreciated.
Regards,
Postgadm.
--
Adrian Klaver
adrian.kla...@aklaver.com
th pg_cron.
Bearing in mind the possible problems of connection saturation or
massive IO spikes, I'd be grateful to learn of any thoughts on how to
negotiate this problem.
Rory
--
Adrian Klaver
adrian.kla...@aklaver.com
On 3/4/20 2:22 PM, Rory Campbell-Lange wrote:
On 04/03/20, Adrian Klaver (adrian.kla...@aklaver.com) wrote:
On 3/4/20 2:04 PM, Rory Campbell-Lange wrote:
We have many databases of the same type separated for data governance
reasons. They, however, share the same web front-end code.
Presently
committing at the same moment. They will still
be out of synch somewhat, but this would reduce the degree.
--
Adrian Klaver
adrian.kla...@aklaver.com
1201 - 1300 of 4934 matches
Mail list logo
