Error dydl : image not found when trying to install pg on Catalina

I upgraded my system to Catalina 10.15.7 and now I get an error with dyld : image not found when trying to install postgresql : ➜ ~ brew install postgresql Running `brew update --preinstall`... ==> Auto-updated Homebrew! Updated 1 tap (homebrew/core). ==> Updated Formulae Updated 6 formul

Re: Help with large delete

I’m sending this again. I don’t see that it made it to the list but there is also new info here. > On Apr 16, 2022, at 10:33, Tom Lane > wrote: > > Perry Smith mailto:p...@easesoftware.com>> writes: >> Currently I have one table that mimics a file system. Each entry

Re: Help with large delete

Thank you TOM!!! So… I did: create index parent_id_index on dateien(parent_id); And now things are going much faster. As you can see, I had an index kinda sorta on the parent id but I guess the way I did it prevented Postgres from using it. > On Apr 17, 2022, at 06:58, Perry Smith wrote: >

Re: Error dydl : image not found when trying to install pg on Catalina

cecile rougnaux writes: > I upgraded my system to Catalina 10.15.7 and now I get an error with dyld : > image not found when trying to install postgresql : > dyld: Library not loaded: /usr/local/opt/icu4c/lib/libicui18n.70.dylib This seems like a bug in the Homebrew formula for postgresql, whi

Re: Require details that can we see the password history to a User account in PostgreSQL Database.

Dear Adrian, Yes, exactly. My query regarding an application user that when passwords were changed and what the previous values were? Kindly let us know the above information since this detail require for an internal auditing purpose. Thanks. Warm regards, M Sonai Muthu Raja Managed Delivery

Re: Require details that can we see the password history to a User account in PostgreSQL Database.

Dear Adrian, Thank you so much for the provided information. Warm regards, M Sonai Muthu Raja Managed Delivery Services - DBA Support M: +919003132734 II Floor, TIDEL Park, 4 Rajiv Gandhi Salai, Taramani, Chennai – 600 113 [cid:81f6183b-b8da-49ea-9fd6-fea0ef9db0ff] www.sifytechnologies.com

Facing issues with pgsql upgrade.

Hello All, I'm facing the following issue while upgrading pgsql 9.6 to pgsql 13. It's saying database "template0" "template1" does not exist on source 9.6, please advise. [image: image.png] [postgres@htf:/var/lib/pgsql]$ psql psql (9.2.24, server 9.6.24) WARNING: psql version 9.2, server v

Re: Facing issues with pgsql upgrade.

On 4/16/22 22:30, Ajay Kajla wrote: Hello All, I'm facing the following issue while upgrading pgsql 9.6 to pgsql 13. It's saying database "template0" "template1" does not exist on source 9.6, please advise. image.png From the below it looks like something/someone deleted the template0

Re: Facing issues with pgsql upgrade.

On Sun, Apr 17, 2022 at 8:53 AM Ajay Kajla wrote: > > I'm facing the following issue while upgrading pgsql 9.6 to pgsql 13. > > It's saying database "template0" "template1" does not exist on source > 9.6, please advise. > > > You might want to just forget doing a pg_upgrade migration and do a pg_

Re: Facing issues with pgsql upgrade.

On 4/17/22 19:11, Ajay Kajla wrote: Thanks Adrian, 1. What if we re-create template0 and template1? First I would determine what else might be missing? In psql what happens if you do: \l to get a list of databases? And can you connect to the databases other then postgres? 2. how to rest