2020年8月4日(火) 14:54 Stelios Sfakianakis :
> On 4 Aug 2020, at 06:25, Ian Lawrence Barwick wrote:
>
> 2020年8月4日(火) 1:24 Stelios Sfakianakis :
>
> Hi,
>
>>> I am trying to implement a FDW in Postgres for accessing a web api and I
>>> would like to keep information like for example the total number
Hi!
We are experiencing a strange situation with an AWS Aurora postgres
instance.
The database steadily grows in size, which is expected and normal.
After enabling logical replication, the disk usage reported by AWS metrics
increases much faster then the database size (as seen by \l+ in psql). The
Hello,
First time writing here, I hope this is the right place to ask this kind of
question. I've been working with PostgreSQL for a while now but i've just
found out that PostgreSQL marks my transaction for ROLLBACK and even stops
the execution of the transaction if an error occurs.
I'm a Java d
På tirsdag 04. august 2020 kl. 10:44:36, skrev Urko Lekuona mailto:u...@arima.eu>>:
Hello,
First time writing here, I hope this is the right place to ask this kind of
question. I've been working with PostgreSQL for a while now but i've just found
out that PostgreSQL marks my transaction for R
Urko Lekuona schrieb am 04.08.2020 um 10:44:
> First time writing here, I hope this is the right place to ask this
> kind of question. I've been working with PostgreSQL for a while now
> but i've just found out that PostgreSQL marks my transaction for
> ROLLBACK and even stops the execution of the
There may be lot of wal files or the size of log files in pg_log might be
huge. "du -sh *" of data directory holding the database might help.
Regards,
Seenu.
On Tue, Aug 4, 2020 at 2:09 PM Chris Borckholder <
chris.borckhol...@bitpanda.com> wrote:
> Hi!
>
> We are experiencing a strange situat
Thank you again, I have another question in order to make sure I have a clear
understanding:
> On 4 Aug 2020, at 11:24, Ian Lawrence Barwick wrote:
>
> The hash table is specific to each running backend so will only be
> accessed by that process.
>
> Pre-loading a shared library just gives th
We are using python on top of Postgresql / PostGIS, for a vehicle
tracking system.
THis is quite data intensive, and we have some 'interesting' GIS queries
where we see where a vehicle or fleet has stopped within specific areas,
where it has traveled, any incidents along the way and much more.
Pos
We use Postgresql, python and PostGIS.
Nearly all our data access is via Postgres functions, both DML and
queries. Our system is a vehicle GPS tracking and business
function analysis system, with quite a lot of data.
Most of our reports require accessing hundreds to 100s of thousands of
records f
On 2020-Aug-03, Alvaro Herrera wrote:
> > lsn | checksum | flags | lower | upper | special | pagesize |
> > version | prune_xid
> > --+--+---+---+---+-+--+-+---
> > A0A/99BA11F8 | -215 | 0 | 180 | 7240 | 8176
Hi,
I am working on providing HA for replication, using automation scripts.
My set up consists of two nodes, Master and Slave. When master fails, The slave
is promoted to master.
In case of sync replication, we do not check if the data is up-to-date on slave.
But in case of async replication, ho
The following alter table with default set to very large text used to work
in Postgres 10 but fails in Postgres 12 with *ERROR: row is too big: size
12960, maximum size 8160*
create table test (id int);
alter table test1 add column license text DEFAULT ''
The following two variants works in P
On Wed, 5 Aug 2020 at 08:36, Raj Gandhi wrote:
> The following alter table with default set to very large text used to work in
> Postgres 10 but fails in Postgres 12 with ERROR: row is too big: size 12960,
> maximum size 8160
I didn't go to the trouble of debugging this, but I imagine this is
Great, thanks David for the explanation.
On Tue, Aug 4, 2020 at 4:59 PM David Rowley wrote:
> On Wed, 5 Aug 2020 at 08:36, Raj Gandhi wrote:
> > The following alter table with default set to very large text used to
> work in Postgres 10 but fails in Postgres 12 with ERROR: row is too big:
> si
Hi everyone,
I'm using postgres 11.4
I have a configuration in which there's one subscriber (slave) node which
subscribes to several (4) publisher nodes (master).
I noticed one of the master servers keeps lagging behind. I noticed that the
replication worker on the master keeps failing on timeou
I am guessing you used pg_pathman or other extensions in addition to postgis?Postgis use SPI_exec() to execute sql statement "SELECT proj4text FROM public.spatial_ref_sys WHERE srid = 4326 LIMIT 1” in each worker progress in postgres parallel query, pg_pathman will r
At Tue, 4 Aug 2020 09:53:36 -0400, Alvaro Herrera
wrote in
> On 2020-Aug-03, Alvaro Herrera wrote:
>
> > > lsn | checksum | flags | lower | upper | special | pagesize |
> > > version | prune_xid
> > > --+--+---+---+---+-+--+-+---
17 matches
Mail list logo
