Re: Partitioning options

2024-02-09 Thread Marc Millas
On Thu, Feb 8, 2024 at 10:25 PM Justin wrote: > Hi Sud, > > Would not look at HASH partitioning as it is very expensive to add or > subtract the number of partitions. > > Would probably look at a nested partitioning using customer ID using > range or list of IDs then by transaction date, Its

Re: Multiple connections over VPN password fail error

2024-02-09 Thread Laurenz Albe
On Fri, 2024-02-09 at 15:04 +0530, Sanjay Minni wrote: > for the second user/role over vpn > even with md5 I get the error:  > P3Error PostgreSQL password authentication failed for user "" > am only able to connect if method is "trust". Why is this so > >   # IPv4 external connections thru VPN >  

Re: Multiple connections over VPN password fail error

2024-02-09 Thread Sanjay Minni
Hi, for the second user/role over vpn even with md5 I get the error: P3Error PostgreSQL password authentication failed for user "" am only able to connect if method is "trust". Why is this so # IPv4 external connections thru VPN #TYPE DATABASE USER ADDRESS METHOD host all

Re: Multiple connections over VPN password fail error

2024-02-09 Thread Sanjay Minni
so why do I get a password error when i try to connect 2 users over VPN from the same machine to the same host with the following settings in pg_dba.conf - how to find the issue ( user1:user1pwd@ & user2:user2pwd@ ) # IPv4 external connections thru VPN #TYPE DATABASE USER ADDRESS METHOD