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

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: 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 >

PANIC: could not open critical system index 2662

This comes at the end of a long cascade of problems stemming from a lightning strike to our datacenter causing our battery backup systems to fail, and overvoltage from the commercial power company to damage our storage arrays which run some services and contain our on-site backups. No problem, rig

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:

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: 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 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 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

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