Re: Multiple connections over VPN password fail error

> On 9 Feb 2024, at 08:41, Sanjay Minni wrote: > while trying to make multiple connects with different role names to a single > database over VPN i faced a password error issue when trying to connect a > send user > It seems I had to change this line in pg_hba.conf and it worked: > >`# IPv

Multiple connections over VPN password fail error

Hi All while trying to make multiple connects with different role names to a single database over VPN i faced a password error issue when trying to connect a send user It seems I had to change this line in pg_hba.conf and it worked: `# IPv4 external connections thru VPN #TYPE DATABASE U

Re: Migrate schemas

On 2/8/24 16:18, Lorusso Domenico wrote: Hello guys, I have 4 schemas with cross references (e.g.: a function refers to a rowtype of a table of another schema, or a table invokes a function). Backup schemas by pgadmin the resulting script doesn't follow the correct order to ensure the object

Migrate schemas

Hello guys, I have 4 schemas with cross references (e.g.: a function refers to a rowtype of a table of another schema, or a table invokes a function). Backup schemas by pgadmin the resulting script doesn't follow the correct order to ensure the object creations. There is a way to tell postgresql

Re: archive command doesnt work

On Thu, 2024-02-08 at 21:28 +0100, Alpaslan AKDAĞ wrote: > Now I am confused. In Primary pg_is_in_recovery() should be false and in > standby node should be true. Am I wrong? Right. I guess I got confused which is your primary and which is your standby. That's normal in the context of switchover

Re: Partitioning options

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 easy to add partitions and balance the partitions segments.

Re: Clarification regarding managing advisory locks in postgresql

On Thu, Jan 25, 2024 at 5:44 AM Sasmit Utkarsh wrote: > Therefore, locks acquired in one process (or transaction) do not directly > affect locks in another process (or transaction). > Ummaybe if you describe the exact problem you are trying to solve with advisory locks, we can find the best

Re: Partitioning options

> > Out of curiosity, As OP mentioned that there will be Joins and also > filters on column Customer_id column , so why don't you think that > subpartition by customer_id will be a good option? I understand List > subpartition may not be an option considering the new customer_ids gets > added slowl

Re: archive command doesnt work

Thank you very much. I got my answer and also read from the documentation. Primary and standby both seem fine. Best Regards Alpaslan On Thu, Feb 8, 2024 at 9:39 PM Mateusz Henicz wrote: > Hey, > Yes, it is. > > https://www.postgresql.org/docs/current/runtime-config-wal.html#GUC-ARCHIVE-MODE >

Re: archive command doesnt work

Hey, Yes, it is. https://www.postgresql.org/docs/current/runtime-config-wal.html#GUC-ARCHIVE-MODE czw., 8 lut 2024 o 21:35 Alpaslan AKDAĞ napisał(a): > Hello Mateusz > > Thank you for your answer. > > If it is like that, there is not any problem. I tried to find an > explanation that hot standby

Re: archive command doesnt work

Hello Mateusz Thank you for your answer. If it is like that, there is not any problem. I tried to find an explanation that hot standby archive wal files or not but I couldn't. Is this information from the Documentation? Best Regards, Alpaslan On Thu, Feb 8, 2024 at 9:24 PM Mateusz Henicz wrot

Re: Partitioning options

On 2/8/24 1:43 PM, veem v wrote: On Thu, 8 Feb 2024 at 20:08, Greg Sabino Mullane > wrote: Should we go for simple daily range partitioning on the transaction_date column? This one gets my vote. That and some good indexes. Hello Greg, Ou

Re: archive command doesnt work

Now I am confused. In Primary pg_is_in_recovery() should be false and in standby node should be true. Am I wrong? Thanks and regards Alpaslan On Thu, Feb 8, 2024 at 9:10 PM Laurenz Albe wrote: > On Thu, 2024-02-08 at 09:23 +0100, Alpaslan AKDAĞ wrote: > > Thank you for your answer. > > > > I ha

Re: archive command doesnt work

czw., 8 lut 2024 o 21:10 Laurenz Albe napisał(a): > On Thu, 2024-02-08 at 09:23 +0100, Alpaslan AKDAĞ wrote: > > Thank you for your answer. > > > > I have checked the pg_is_in_recovery() and here are the results > > from primary and hot stand by server. > > > > Primary (old standby ): > > select

Re: archive command doesnt work

On Thu, 2024-02-08 at 09:23 +0100, Alpaslan AKDAĞ wrote: > Thank you for your answer. > > I have checked the pg_is_in_recovery() and here are the results > from primary and hot stand by server. > > Primary (old standby ): > select pg_is_in_recovery(); >  pg_is_in_recovery > --- >

Re: Partitioning options

On Thu, 8 Feb 2024 at 20:08, Greg Sabino Mullane wrote: > On Thu, Feb 8, 2024 at 12:42 AM sud wrote: > ... > >> The key transaction table is going to have ~450 Million transactions per >> day and the data querying/filtering will always happen based on the >> "transaction date" column. >> > ... >

Re: Clarification regarding managing advisory locks in postgresql

On Thu, Jan 25, 2024 at 4:44 AM Sasmit Utkarsh wrote: > Okay Thanks. Also please help me understand the below scenarios > > From the above statement, I understand is (please correct if I'm wrong > here), When we fork a client process, each process gets its own database > connection or transaction

Re: Fwd: pgadmin not opening in concurrent sessions

On 2/8/24 07:27, Siraj G wrote: Hello! I installed PgAdmin4 8.2 in a Windows platform, for all the users. The issue we are having is, if any user launches it, nobody else can launch it. Eg., userB logs in and launches PgAdmin, it gets launched. Now if UserA and UserB tried to login, they get n

Fwd: pgadmin not opening in concurrent sessions

Hello! I installed PgAdmin4 8.2 in a Windows platform, for all the users. The issue we are having is, if any user launches it, nobody else can launch it. Eg., userB logs in and launches PgAdmin, it gets launched. Now if UserA and UserB tried to login, they get nothing, no event/response from Windo

Re: Partitioning options

On Thu, Feb 8, 2024 at 12:42 AM sud wrote: ... > The key transaction table is going to have ~450 Million transactions per > day and the data querying/filtering will always happen based on the > "transaction date" column. > ... > Should we go for simple daily range partitioning on the transaction

Re: How to do faster DML

On Thu, Feb 8, 2024 at 12:12 AM Lok P wrote: > Rearranging the table columns by typlen desc, didn't give much storage > space reduction. > It's not so much "biggest to smallest" as making sure you don't have any gaps when you move from one data type to another. You may have not had any "holes" o

cookiecutter template for Postgres extensions

Hi all, I built a cookiecutter template for Postgres extensions. This cookiecutter prompts for some basic extension metadata (e.g., name, Postgres version) and then automatically generates the necessary boilerplate files. These include: * Standard extension files (Makefile, .control, c, .h

Re: Error on create extension pgcrypto. Undefined symbol "EVP_bf_ecb"

> On 7 Feb 2024, at 18:53, Marco Aurelio wrote: > > I changed the path and now the correct version of openssl appears in the > config.log, even so, after recompiling and reinstalling both postgresql and > the pgcrypto contrib, when trying to create the extension in a database I > continue to r

Re: archive command doesnt work

Hello Laurenz, Thank you for your answer. I have checked the pg_is_in_recovery() and here are the results from primary and hot stand by server. Primary (old standby ): select pg_is_in_recovery(); pg_is_in_recovery --- f (1 row) hot standby(old primary): select pg_is_in_recover