Re: Re: Enabling checksums on a streaming replica

On Wed, Jun 26, 2019 at 02:08:19PM -0400, Brad Nicholson wrote: > In testing, it doesn't appear to matter. I've ensured that I've generated > some full page writes (confirmed via pg_waldump), and those apply > fine. Full pages writes are first written from shared buffers to WAL, where their

Re: patch 11.2 to 11.4

Hi Fabrizo, After applying the update command getting this error , postg...@shacoyuhss001.enterprisenet.org:/home/postgres ==> psql psql (11.4, server 11.3) Type "help" for help. postgres=# postgres=# select version(); version

Re: pg_dump (COPY) hanging intermittently

Ben Snaidero writes: > Do these stack traces shed help at all? None worth mentioning :-(. Can you rebuild with debug symbols? regards, tom lane

Re: pg_dump (COPY) hanging intermittently

On Thu, Jun 27, 2019 at 2:34 PM Tom Lane wrote: > Ben Snaidero writes: > > I am running into a strange issue with Postgres 10 when using pg_dump > with > > the directory format and jobs parameter set it intermittently hangs. > Seems > > to occur less frequently the lower I set the jobs

Re: pg_dump (COPY) hanging intermittently

Ben Snaidero writes: > I am running into a strange issue with Postgres 10 when using pg_dump with > the directory format and jobs parameter set it intermittently hangs. Seems > to occur less frequently the lower I set the jobs parameter but does happen > eventually even when set to 2 (could not

pg_dump (COPY) hanging intermittently

Hi, I am running into a strange issue with Postgres 10 when using pg_dump with the directory format and jobs parameter set it intermittently hangs. Seems to occur less frequently the lower I set the jobs parameter but does happen eventually even when set to 2 (could not reproduce when jobs=1).

Re: Postgresql 12 Beta2 Crashes for any Insert/Update

On Thu, Jun 27, 2019 at 1:28 AM Mohsen Bande wrote: > i have a working database in PG 12 Beta 1. today i upgraded it to Beta 2. > everything goes fine and server is up and running. but trying to > INSERT/UPDATE anything, server crashes: Is it possible for you to send us a stacktrace?

Re: 9.6.11- could not truncate directory "pg_serial": apparent wraparound

Hi, Got this issue again. Settings on the platform (PG 9.6.11): max_pred_locks_per_transaction = 3000 max_connections = 800 Despite the fact that documentation says: > with the exception of fast-path locks, each lock manager will deliver a consistent set of results I've noticed the following: 1.

Re: In-depth commercial postgresql training

Em qui, 27 de jun de 2019 às 10:47, Marcelo Lacerda < marceloslace...@gmail.com> escreveu: > Our company is looking for commercial training in postgresql. We want a > training option that's as in-depth as possible (going as far as being able > to read and patch postgresql source code). Is there

In-depth commercial postgresql training

Our company is looking for commercial training in postgresql. We want a training option that's as in-depth as possible (going as far as being able to read and patch postgresql source code). Is there any company that offers something like that? Another important thing to mention is that due to

Re: patch 11.2 to 11.4

Thanks for your support. On Thu, Jun 27, 2019, 18:58 Fabrízio de Royes Mello wrote: > > Em qui, 27 de jun de 2019 às 05:35, Prakash Ramakrishnan < > prakash.ramakrishnan...@nielsen.com> escreveu: > >> Hi Team, >> >> I done the installation using yum poostgresql 11 server method now i need >> to

Re: patch 11.2 to 11.4

Em qui, 27 de jun de 2019 às 05:35, Prakash Ramakrishnan < prakash.ramakrishnan...@nielsen.com> escreveu: > Hi Team, > > I done the installation using yum poostgresql 11 server method now i need > to update or apply the patch using repo file how to do this 11.2 to 11.4 > please share me the steps

Re: migrating from Oracle to PostgreSQL 11

On Wed, 26 Jun 2019 19:12:07 +0530 Hitesh Chadda wrote: > Hi PostgresSQL Support, > > I have to migrate from Oracle 11g to PostgresSQL 11.4. Please suggest > best solution for doing the migration. Bit of a broad topic for an answer. Other than "carefully", there isn't enough of a question to

Re: pg_receivelwal vs synchronous

Hi Magnus, On 6/27/19 8:37 AM, Magnus Hagander wrote: What am I missing here ? I believe your problem is remote_apply. pg_receivewal never *applies* any WAL, so it just updates the write and flush locations. Notice how the replay_lsn remains NULL. So you need synchronous_commit to be 'on'

Re: pg_receivelwal vs synchronous

On Wed, Jun 26, 2019 at 5:06 PM Jesper Pedersen wrote: > Hi, > > PostgreSQL 11.4 > > Given, > > postgresql.conf: > > wal_level = replica > synchronous_commit = remote_apply > synchronous_standby_names = '*' > > > CREATE ROLE repluser WITH LOGIN REPLICATION PASSWORD 'mypwd'; >

patch 11.2 to 11.4

Hi Team, I done the installation using yum poostgresql 11 server method now i need to update or apply the patch using repo file how to do this 11.2 to 11.4 please share me the steps . -- Thanks, Prakash.R

Postgresql 12 Beta2 Crashes for any Insert/Update

i have a working database in PG 12 Beta 1. today i upgraded it to Beta 2. everything goes fine and server is up and running. but trying to INSERT/UPDATE anything, server crashes: =# select id from user where id=0; id 0(1 row)=# UPDATE user SET is_deleted = true WHERE id = 0; psql: server

Re: migrating from Oracle to PostgreSQL 11

Hi, I think you can start from: - https://wiki.postgresql.org/wiki/Oracle_to_Postgres_Conversion - https://severalnines.com/blog/migrating-oracle-postgresql-what-you-should-know - http://ora2pg.darold.net/ - https://pgxn.org/dist/orafce/ Regards, Enrico Il 26/06/2019 15:42, Hitesh

migrating from Oracle to PostgreSQL 11

Hi PostgresSQL Support, I have to migrate from Oracle 11g to PostgresSQL 11.4. Please suggest best solution for doing the migration. Regards H.Kumar