postgres module in msvc

Hi there and thx for reading and answering if you can A few years ago, I wrote a pg module in C on gcc/linux. This module works fine, and I'm striving to port on windows postgres edb, I compiled the corresponding .dll wirh both mingw54 and msvc 2022, but got postgres crashes. I also trie

LDAP authentication slow

This is PostgreSQL 9.5 -- We just enabled LDAP(S) authentication (to an Active Directory server) for a certain grouping of users pg_hba.conf #... hostssl all +ldap_group 0.0.0.0/0 ldap ldaptls="1" ldapserver=" hostssl all all 0.0.0.0/0 md5 #... I'm getting complaints from the users authent

Re: LDAP authentication slow

On Wed, May 30, 2018 at 12:04 PM, Stephen Frost wrote: > Greetings, > > * C GG (cgg0...@gmail.com) wrote: > > This is PostgreSQL 9.5 -- We just enabled LDAP(S) authentication (to an > > Active Directory server) for a certain grouping of users > > You really shouldn

Re: LDAP authentication slow

On Wed, May 30, 2018 at 2:50 PM, Stephen Frost wrote: > Greetings, > > * C GG (cgg0...@gmail.com) wrote: > > On Wed, May 30, 2018 at 12:04 PM, Stephen Frost > wrote: > > > What's the reason for wishing for them to "be able to type in a > > > pa

Re: LDAP authentication slow

On Wed, May 30, 2018 at 5:43 PM, Adrian Klaver wrote: > On 05/30/2018 01:41 PM, C GG wrote: > >> >> >> > Please let me be clear, this is not a question about whether or not to use >> passwords. This is a question of how to determine the cause of and remedy a

Re: LDAP authentication slow

On Wed, May 30, 2018 at 6:31 PM, Tim Cross wrote: > > C GG writes: > > > On Wed, May 30, 2018 at 2:50 PM, Stephen Frost > wrote: > > > >> Greetings, > >> > >> * C GG (cgg0...@gmail.com) wrote: > >> > On Wed, May 30, 2018 at 12:0

Re: Insert UUID GEN 4 Value

On Thu, May 31, 2018 at 12:45 AM, tango ward wrote: > On Thu, May 31, 2018 at 12:06 PM, Rob Sargent > wrote: > >> >> >> On May 30, 2018, at 9:57 PM, tango ward wrote: >> >> On Thu, May 31, 2018 at 11:53 AM, tango ward >> wrote: >> >>> On Thu, May 31, 2018 at 11:51 AM, Laurenz Albe >> > wrote:

PANIC: could not open critical system index 2662

erly shut down; automatic recovery in progress LOG: record with zero length at C/8C7E28D0 LOG: redo is not required LOG: database system is ready to accept connections LOG: autovacuum launcher started Attempt to connect again, and you get the same set of messages. What other ways can you think

Re: PANIC: could not open critical system index 2662

On Sat, Aug 4, 2018 at 11:13 AM, Tom Lane wrote: > C GG writes: > > When trying to restart the PostgreSQL 9.2 database for our JIRA > > installation, we're getting > > "PANIC: could not open critical system index 2662" ... I've tried > various >

DROP CASCADE transitive dependencies

...PostgreSQL 9.5... `DROP SCHEMA blah;` reports all the dependent objects and advises to `DROP SCHEMA blah CASCADE;` ... Will DROP ... CASCADE traverse the entire dependency tree for each of the dependent objects (potentially dropping something unintended), or will it stop at the first level and

Re: DROP CASCADE transitive dependencies

On Mon, Dec 3, 2018 at 1:26 PM Tom Lane wrote: > C GG writes: > > ...PostgreSQL 9.5... > > `DROP SCHEMA blah;` reports all the dependent objects and advises to > `DROP > > SCHEMA blah CASCADE;` ... > > > Will DROP ... CASCADE traverse the entire dependency t

Bind Parameter is Too Big

I support a system where staff use a PowerBuilder 2019R3 app that enters data into a Postgres 12 database, generates SQL statements for the data and saves them as text files. Staff uses another PB2019R3 app to populate a Sybase ASE 15.7 database with the generated SQL statement files. Other staf

RE: Bind Parameter is Too Big

Director North Dakota Public Service Commission 600 E Boulevard Ave Dept 408 13th Floor Bismarck, ND 58505-0480 Phone: 701-328-4075 -Original Message- From: Adrian Klaver Sent: Thursday, September 01, 2022 3:46 PM To: Kluzak, Matthew C. ; pgsql-general@lists.postgresql.org Subject: Re: Bind

RE: Bind Parameter is Too Big

idn't have an explanation either. -Original Message- From: Tom Lane Sent: Thursday, September 01, 2022 4:03 PM To: Kluzak, Matthew C. Cc: Adrian Klaver ; pgsql-general@lists.postgresql.org Subject: Re: Bind Parameter is Too Big * CAUTION: This email originated from an outside

GIN INdex is not used with && operator for a text array index

HI Team Sorry for the spam. We have Postgres DB where the list of addresses are stored and for a given complete address trigram of addresses are stored in a column which is a text array. after looking at the list of operators that are available for gin index I decided to use array_ops operator.

PostgreSQL Automatic Failover Windows Server

HI, I am Heljeeve from India working as a DB Administratror. We are a company doing projects on solutions for lottery system worldwide, and been in the industry for the past 20 years. Currently we are doing projects in Windows environments ( MS SQL SERVER DATABASE ), as we required high availabil

Querying a table with jaccard similarity with 1.6 million records take 12 seconds

Hi Team We have encountered a problem in our testing environment. I have a scenario where I am running a similarity match for an address I have created a table with following number of records 1603423 We are using pg_similarity extension in postgresql version is 13. And I have created GIN index

Re: Querying a table with jaccard similarity with 1.6 million records take 12 seconds

rds, > Ninad Shah > > > On Thu, 2 Sept 2021 at 16:39, balasubramanian c r > wrote: > >> Hi Team >> >> We have encountered a problem in our testing environment. >> I have a scenario where I am running a similarity match for an address >> I ha

Re: Querying a table with jaccard similarity with 1.6 million records take 12 seconds

HI Tom/Ninad My bad I didn't explain my use case properly. The use case is to find the best string similarity for a given address against the list of addresses in the table. Initially I tried a similarity function provided by the pg_trgm extension. But the similarity scores were not satisfactory. L

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

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

Voluntary Product Assessment For pgAdmin 8.3

To whom it may concern, Your product, pgAdmin 8.3, is a candidate technology for use within the U.S. General Services Administration (GSA) enterprise environment. Technologies under review by GSA’s Office of the Chief Technology Officer (OCTO) must be accompanied by a completed Voluntary Product A

Postgres and alias

Hi, I am migrating a database from Sybase to PostgreSql 12. This select in sybase works for me, but with postgresql it accuses me "THERE IS NO COLUMN ls_numero" select '1234567890' as ls_number, substr (ls_number, 3, 3); Is it possible to get information from an alias in postg

Postgres and alias

original- De: Stelios Sfakianakis [mailto:sgs...@gmail.com] Enviado el: jueves, 27 de agosto de 2020 12:59 Para: Fontana Daniel C (Desartec S.R.L.) CC: pgsql-general@lists.postgresql.org Asunto: Re: Postgres and alias Hmm, how about: SELECT substr (ls_number, 3, 3) FROM (VALUES('1234567890

Schema in trigger in logical replication

Using postgres 12.5 in DBA schema, this trigger is executed when the table is updated through a logical replication. Why is it necessary to name the schema for it to work? When I update the table manually, if it Works. Example. This trigger function does not work CREATE FUNCTION dba.ft_pos_sync_