SSL error on install of PEM during Posgres install

I am getting the following error message during install of PEM while installing Posgres. [cid:da2b6d5e-c3b0-430a-98e0-dac72d0aba23] How can I fix this?

PEM install error

While installing PostgreSQL I am getting this error message during the PEM server portion. Do I need the PEM server? If so, what is the solution? Thanks! [cid:b414e51e-598a-44bf-951a-ce754c0fa77d]

Re: Intermittent errors when fetching cursor rows on PostgreSQL 16

I'm getting a strange error message when I try to insert a date using the view/edit grid in pgadmin. See below. I've tried quotes, no quotes and various formats. The column type is clearly "date." [cid:4ff69cfe-2efa-4636-8dde-6230512706f7] Mark Brady, Ph.D. Deputy Chief Data Officer, TRMC am

Re: Duplicate Key Values

/author/markjbrady<https://amazon.com/author/markjbrady> From: mark bradley Sent: Friday, March 7, 2025 9:34 AM To: Adrian Klaver Cc: pgsql-general Subject: Re: Duplicate Key Values This is what MS Copilot has to say about this apparent bug where Postgres i

Re: Duplicate Key Values

I hesitate to just delete my tables and start over because this error will reoccur. Best regards, Mark Brady amazon.com/author/markjbrady<https://amazon.com/author/markjbrady> From: Adrian Klaver Sent: Thursday, March 6, 2025 3:34 PM To: mark bradley Cc:

Re: Duplicate Key Values

Wouldn't that be nice 🙂 Best regards, Mark Brady amazon.com/author/markjbrady<https://amazon.com/author/markjbrady> From: Adrian Klaver Sent: Friday, March 7, 2025 10:55 AM To: mark bradley Cc: pgsql-general Subject: Re: Duplicate Key Values On 3

Re: Duplicate Key Values

I tried adding a dummy column with different values and then deleting one, as you suggested. Got the same message. Mark Brady, Ph.D. Deputy Chief Data Officer, TRMC amazon.com/author/markjbrady<https://amazon.com/author/markjbrady> From: mark bradley

Re: Duplicate Key Values

unique > no-nulls-allowed index on the column(s), so no other index is needed.) > > Can you show the table definition? > > Anyway, you /should/ be able to delete one of the duplicate node_id > records by specifying another column with a different value; > > On Wed, Mar

Re: Duplicate Key Values

tables. I will reenter the data, make a backup, and then try your further extended suggestions. Best regards, Mark Brady amazon.com/author/markjbrady<https://amazon.com/author/markjbrady> From: Adrian Klaver Sent: Friday, March 7, 2025 3:25 PM To: mark br

Re: Duplicate Key Values

The rows that were preserved in the nodes table were the ones that were not dups originally. Best regards, Mark Brady amazon.com/author/markjbrady<https://amazon.com/author/markjbrady> From: Adrian Klaver Sent: Tuesday, March 11, 2025 10:56 AM To: mark b

Re: Duplicate Key Values

b REINDEX TABLE node; Also reindexed table with node_id as a foreign key in the same way. Best regards, Mark Brady amazon.com/author/markjbrady<https://amazon.com/author/markjbrady> From: Adrian Klaver Sent: Tuesday, March 11, 2025 11:12 AM To: mark b

Re: Duplicate Key Values

_ From: Adrian Klaver Sent: Tuesday, March 11, 2025 12:00 PM To: mark bradley Cc: pgsql-general Subject: Re: Duplicate Key Values On 3/11/25 08:16, mark bradley wrote: A) 1) Please do not top post. Either inline or bottom post. It makes things like the below easier to follow. I wrote the po

Re: Duplicate Key Values

to create a simple database from scratch and see if I can duplicate this behavior. Best regards, Mark Brady amazon.com/author/markjbrady<https://amazon.com/author/markjbrady> From: Adrian Klaver Sent: Tuesday, March 11, 2025 3:37 PM To: mark bradley C

Re: Duplicate Key Values

com/author/markjbrady> From: Adrian Klaver Sent: Thursday, March 13, 2025 12:05 PM To: mark bradley ; Ron Johnson ; pgsql-general Subject: Re: Duplicate Key Values On 3/13/25 08:56, mark bradley wrote: > >Postgresql does not assume / default to inheri

Re: Duplicate Key Values

74] Where node_id is a foreign key in dataset, and node_type is not. Best regards, Mark Brady amazon.com/author/markjbrady<https://amazon.com/author/markjbrady> From: Adrian Klaver Sent: Thursday, March 13, 2025 12:05 PM To: mark bradley ; Ron Johnson ; pg

Duplicate Key Values

Although I did not enter them, somehow duplicate primary key values have appeared in one of my tables. I can't remove the offending rows because the key is a foreign key in another table. What to do? Mark Brady, amazon.com/author/markjbrady

Re: Duplicate Key Values

Adrian & Ron, Thank you for your assistance. Best regards, Mark Brady amazon.com/author/markjbrady<https://amazon.com/author/markjbrady> From: Adrian Klaver Sent: Thursday, March 13, 2025 1:03 PM To: mark bradley ; Ron Johnson ; pgsql-general S