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
> > > --+--+---+---+---+-+--+-+---
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
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
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
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
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
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
On 2020-Aug-03, Alvaro Herrera wrote:
> > lsn | checksum | flags | lower | upper | special | pagesize |
> > version | prune_xid
> > --+--+---+---+---+-+--+-+---
> > A0A/99BA11F8 | -215 | 0 | 180 | 7240 | 8176
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
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
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
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
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
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
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
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
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
17 matches
Mail list logo
