Re: PostgreSQL Kerberos Authentication

On 1/30/18 11:13, HIRTZ Jorge Alberto TENARIS wrote: > [postgres@hostname data]$ psql  -h hostname -U usern...@domain.com postgres > > psql: GSSAPI continuation error: Unspecified GSS failure.  Minor code > may provide more information > > GSSAPI continuation error: Server not found in Kerberos d

Re: session_replication_role meaning?

On 1/30/18 02:48, Luca Ferrari wrote: > Hi all, > now this should be trivial, but I cannot udnerstand what is the > purpose of session_replication_role > > or better, when I should use it in a way di

Re: pg10 logical replication set schema

On 1/30/18 08:47, Gabriel Furstenheim Milerud wrote: >     create table test_table_replication (a int); >     create publication test_table_replication_pub for table > test_table_replication; >   create table some_schema.test_table_replication (a int); >   create subscription test_table_replicatio

Re: How to Optimize pg_trgm Performance

Hi Igal, 29.01.2018 02:42, Igal @ Lucee.org пишет: I want to use pg_trgm for auto-suggest functionality.  I created a Materialized View with the information that I need, with the relevant columns being (keywords text, rank int). keywords is the column from which I build the tri-grams, and ra

Re: Working with JSONB data having node lists

On Tue, Jan 30, 2018 at 2:47 PM, geoff hoffman wrote: > JSONB fields are very attractive for our current use, particularly as > straight key-value pairs in the JSONB data; > > but we are having trouble finding documentation on how to query lists (of > scalars or objects) in nodes of the JSONB dat

Re: Alter view with dependence without drop view!

Elson Vaz schrieb am 30.01.2018 um 14:40: Hello! I want make change in one view that have dependence view's, so when i try to make change i'm block because of this, what is the best solution?? This can easily be dealt with when using a schema management tool. We use Liquibase for this and t

Re: ERROR: invalid memory alloc request size 1073741824

On 01/30/2018 10:43 PM, Jan Wieck wrote: > > > On Tue, Jan 30, 2018 at 12:35 PM, Stefan Blanke > mailto:stefan.bla...@framestore.com>> wrote: > > Hello, > > We've tripped over an error when doing a "COPY.. TO STDOUT WITH > BINARY" query. > > "ERROR:  invalid memory alloc requ

Re: Alter view with dependence without drop view!

> > I want make change in one view that have dependence view's, so when i try > to make change i'm block because of this, what is the best solution?? Just to be clear, there are some changes you can make, some you can't. Basically you can't change the definition of existing columns in the view. B

Working with JSONB data having node lists

JSONB fields are very attractive for our current use, particularly as straight key-value pairs in the JSONB data; but we are having trouble finding documentation on how to query lists (of scalars or objects) in nodes of the JSONB data. ~~~ I have the table as follows: CREATE TABLE public.cont

Re: ERROR: invalid memory alloc request size 1073741824

On Tue, Jan 30, 2018 at 12:35 PM, Stefan Blanke < stefan.bla...@framestore.com> wrote: > Hello, > > We've tripped over an error when doing a "COPY.. TO STDOUT WITH BINARY" > query. > > "ERROR: invalid memory alloc request size 1073741824" > (exactly 1GB) > I have my money on a corrupted TOAST en

Re: ERROR: invalid memory alloc request size 1073741824

On 01/30/2018 06:35 PM, Stefan Blanke wrote: > Hello, > > We've tripped over an error when doing a "COPY.. TO STDOUT WITH BINARY" > query. > > "ERROR:  invalid memory alloc request size 1073741824" > (exactly 1GB) > > So a palloc() call is failing on the AllocSizeIsValid() check. > > Does anyo

Re: Streaming replication: replicant server not starting (9.4.4, Win 2008)

Hi Tim, You have to enable hot_standby=on parameter on the replica server. See the below link. https://wiki.postgresql.org/wiki/Hot_Standby Regards, Ibrahim. 2018-01-30 21:16 GMT+03:00 Tim Bowden : > I've inherited a PG 9.4.4 install on Win 2008 that I'm wanting to > stream from (abt 80Gb on dis

Streaming replication: replicant server not starting (9.4.4, Win 2008)

I've inherited a PG 9.4.4 install on Win 2008 that I'm wanting to stream from (abt 80Gb on disk).  Everything seems to be working from the "master" side. I have an AMI of the master host (a vmware instance in our soon to close data centre) that has been spun up in AWS (replicant).  In it's "defaul

Re: Alter view with dependence without drop view!

On Tue, Jan 30, 2018 at 12:48 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Tue, Jan 30, 2018 at 8:34 AM, bto...@computer.org < > bto...@broadstripe.net> wrote: > >> >> When this procedure got old, I started using a script created using >> pg_dump and pg_restore, as initially out

RE: PostgreSQL Kerberos Authentication

Thanks Poul, According to official documentation parameters like ldap, and suffix in pg_hba.conf are for LDAP Authentication not for Kerberos/GSSAPI. In fact the authentication through LDAP works fine in our environment but not for Kerberos… Do you know if the principal in Active Directory KDC

Re: Alter view with dependence without drop view!

On Tue, Jan 30, 2018 at 8:34 AM, bto...@computer.org wrote: > > When this procedure got old, I started using a script created using > pg_dump and pg_restore, as initially outlined here: > > ​Yeah, the short answer is PostgreSQL doesn't make it possible to edit "middle" views without having the co

Re: Alter view with dependence without drop view!

One way I have approached this problem is: 1) Use PgAdmin attempt the change. 2) Examine the error report PgAdmin displays that identifies which dependent views are preventing your progress. 3) Wrap your original DDL from step 1 within the DROP and CREATE DDL associated with the closest dep

ERROR: invalid memory alloc request size 1073741824

Hello, We've tripped over an error when doing a "COPY.. TO STDOUT WITH BINARY" query. "ERROR: invalid memory alloc request size 1073741824" (exactly 1GB) So a palloc() call is failing on the AllocSizeIsValid() check. Does anyone know if this a safety catch we are tripping with a bad query

Re: pgAdmin 4 loading shapefiles

On 01/30/2018 03:32 AM, Findlay, Thomas C wrote: Hello, How do you load GIS shapefiles into a pgAdmin database, using pgAdmin 4? AFAIK there is no pgAdmin database, you are loading into a Postgres database. I have done this in pgAdmin 3 using the PostGIS Shapefile loader, but can’t seem

Many Backends stuck in wait event IPC/ParallelFinish

Hi, We just had an incident on one of our non-production databases where 14 unrelated queries were all hung in wait event IPC / ParallelFinish. We had systematically called pg_cancel/terminate_backend on all other backends except these (and the autovacuum process mentioned below) to make sure t

Re: PostgreSQL Kerberos Authentication

you need til tell Postgresql/pg_hba.conf the AD kerberos server name ldap = kerberos.domain.com and suffix@domain.com Then create the users(is in fact a role) as the owner of a database. Hereafter the user could just write psql after login and after password auhtentication the user/role

PostgreSQL Kerberos Authentication

Hello All, I am trying to configure PostgreSQL9.6 (On Centos 7.4) with Kerberos (Active Directory) via GSSAPI authentication and I'm getting the following error: [postgres@hostname data]$ psql -h hostname -U usern...@domain.com postgres psql: GSSAPI continuation error: Unspecified GSS failure.

Re: Information on savepoint requirement within transctions

On Tue, Jan 30, 2018 at 8:25 AM, Rakesh Kumar wrote: > > > > I'm not sure about the terminology here, though, because the Transaction > > Tutorial (https://www.postgresql.org/docs/9.6/static/tutorial- > transactions.html) > > speaks of "aborted" transactions, while you use the term "failed" here.

Re: Information on savepoint requirement within transctions

> > I'm not sure about the terminology here, though, because the Transaction > Tutorial > (https://www.postgresql.org/docs/9.6/static/tutorial-transactions.html) > speaks of "aborted" transactions, while you use the term "failed" here. Purely from a user point of view, shouldn't "aborted" mean a

Re: session_replication_role meaning?

On Tue, Jan 30, 2018 at 3:36 AM, Laurenz Albe wrote: > Luca Ferrari wrote: > > now this should be trivial, but I cannot udnerstand what is the > > purpose of session_replication_role > > or better, when I should use it in a way different from 'origin'. > > It is used to enable or disable triggers

Re: PG Sharding

Using citusdb enterprise, you can replicate the table shards. Here is the link to the documentation: https://docs.citusdata.com/en/v7.2/reference/user_defined_functions.html#replicate-table-shards Regards, Thomas 2018-01-30 12:18 GMT+01:00 Matej : > As already said. It's missing 2 level shardi

pg10 logical replication set schema

Hi, I've been following https://hackernoon.com/postgresql-logical-replication-86df5b51cc5a to set up logical replication. I've created the table in master and publication create table test_table_replication (a int); create publication test_table_replication_pub for table test_table_replic

pgadmin 4 shapefile loader

Hello, How do you load GIS shapefiles into a pgAdmin database, using pgAdmin 4? I have done this in pgAdmin 3 using the PostGIS Shapefile loader, but can't seem to find this in version 4. Thank you, Thomas

Alter view with dependence without drop view!

Hello! I want make change in one view that have dependence view's, so when i try to make change i'm block because of this, what is the best solution?? thank you!! best regard Elson Vaz

Re: CannotAcquireResourceException in Junit

On Tue, 2018-01-30 at 15:41 +0530, Abhra Kar wrote: > Hi, >Sorry for late reply. Below options I tried --- > 1>pg_terminate_backend --> Successful execution. > 2> Increase max_connection to 900 in > /var/lib/pgsql/9.5/data/postgresql.conf .After modify restart psql > service--- > servic

pgAdmin 4 loading shapefiles

Hello, How do you load GIS shapefiles into a pgAdmin database, using pgAdmin 4? I have done this in pgAdmin 3 using the PostGIS Shapefile loader, but can't seem to find this in version 4. Thank you, Thomas

Re: PG Sharding

As already said. It's missing 2 level sharding and is restricted with SPOF. BR Matej 2018-01-30 12:05 GMT+01:00 Rakesh Kumar : > > > > >We are looking for multi tenancy but at scale. That's why the sharding > and partitioning. It depends how you look at the distributed part. > > Citusdb. >

Re: PG Sharding

>We are looking for multi tenancy but at scale. That's why the sharding and >partitioning. It depends how you look at the distributed part. Citusdb.

Re: CannotAcquireResourceException in Junit

Hi, Sorry for late reply. Below options I tried --- 1>pg_terminate_backend --> Successful execution. 2> Increase max_connection to 900 in /var/lib/pgsql/9.5/data/postgresql.conf .After modify restart psql service--- service postgresql-9.5 start service postgresql-9.5 stop Then execute se

Re: PG Sharding

We are looking for multi tenancy but at scale. That's why the sharding and partitioning. It depends how you look at the distributed part. BR Matej 29. jan. 2018 17.50 je oseba "Rakesh Kumar" napisala: > > > > On Jan 29, 2018, at 09:34 , Matej wrote: > > > > Hi Everyone. > > > > We are looking

Re: Information on savepoint requirement within transctions

On 30.01.2018 03:07, David G. Johnston wrote: > ​So, my first pass at this. Nice, thank you. > + These are of particular use for client software to use when executing > + user-supplied SQL statements and want to provide try/catch behavior > + where failures are ignored. Personally, I'd rewor

Re: session_replication_role meaning?

Luca Ferrari wrote: > now this should be trivial, but I cannot udnerstand what is the > purpose of session_replication_role > or better, when I should use it in a way different from 'origin'. It is used to enable or disable triggers. By default, tables are created with all triggers enabled, which

Re: session_replication_role meaning?

On 30/01/2018 09:48, Luca Ferrari wrote: Hi all, now this should be trivial, but I cannot udnerstand what is the purpose of session_replication_role or better, when I should use it in a way differe

Re: Information on savepoint requirement within transctions

David G. Johnston wrote: > > > It may be worth updating the docs here... > > > So, my first pass at this. I'm probably going a bit outside what would > normally be covered in the SQL > Command section but it does feel right at first blush. > > Also attached; not compiled. > > As a bug fix I've