Will Hartung writes:
> I am trying to load data in to a table with a jsonb field that is indexed
> as gin (field jsonb_path_ops).
>
> It's a large table, and I'm loading it 100K rows at a time. Eventually, it
> would be 30M+ rows in the table.
>
> Originally I simply loaded the table and then t
Dear all
What about following „Rapid App Development Tools"?
* OpenXava (Java): https://www.openxava.org/ate/visual-studio-lightswitch
* Radzen (.NET): https://www.radzen.com/visual-studio-lightswitch-alternative/
* Other: https://aurelia.io/ (JS) or CUBA https://www.cuba-platform.com/ (Java)
:St
I am trying to load data in to a table with a jsonb field that is indexed
as gin (field jsonb_path_ops).
It's a large table, and I'm loading it 100K rows at a time. Eventually, it
would be 30M+ rows in the table.
Originally I simply loaded the table and then tried to create the index,
but it neve
Alvaro Herrera writes:
> On 2019-May-17, Tom Lane wrote:
>> The good news is that the underlying ALTER TABLE bug is fixed in 11.3.
>> The bad news is that your database is probably toast anyway --- an update
>> won't undo the catalog corruption that is causing the WAL replay crash.
>> I hope you h
On 2019-May-17, Tom Lane wrote:
> The good news is that the underlying ALTER TABLE bug is fixed in 11.3.
> The bad news is that your database is probably toast anyway --- an update
> won't undo the catalog corruption that is causing the WAL replay crash.
> I hope you have a recent backup to restor
Hi,
On 2019-05-17 09:30:05 -0400, Tom Lane wrote:
> The good news is that the underlying ALTER TABLE bug is fixed in 11.3.
> The bad news is that your database is probably toast anyway --- an update
> won't undo the catalog corruption that is causing the WAL replay crash.
> I hope you have a recen
>Get a second machine, set it up to be as identical to the existing machine as
>you can - aside from it not >being near death - and migrate "production" to it.
>
>Then on the machine described above install v10 and whatever else you need for
>staging/testing and then >once everything checks ou
>>I spent most of yesterday trying to get 9.6.13 installed from the PostgreSQL
>>Yum repository and finally >>got it working with the initdb stuff stored on a
>>non-default dedicated partition (RAID10 array) only to >>find that psql
>>didn't work and was complaining about a missing libpq.so.5.
Daulat Ram writes:
> My Postgres 11.2 container is not started due to the below error message. It
> is in streaming replication environment.
> 2019-05-17 06:41:19.954 UTC [11] FATAL: SMgrRelation hashtable corrupted
Yes, this is probably the same issue reported in
https://www.postgresql.org/m
Hello.
Thanks for the answer.
Can frequent database operations cause getting a standby server behind? Is
there a way to avoid this situation?
I checked that walsender works well in my test if I set
wal_sender_timeout at least to 5 second.
Best regards,
Andrei Yahorau
From: Kyotaro HORIG
Hi,
I am currently building a PostgreSQL cluster with physical replication. I want
to disable full_page_writes as the underlaying filesystem (ZFS) prevents
partial page writes.
I would like to use pg_rewind for faster reintegration of diverted nodes but
pg_rewind refuses to act if full_page_wri
11 matches
Mail list logo
