Re: Could not load server certificate file "server.crt": No such file or directory.

2022-08-12 Thread howardnews
set ssl on. Check postgresql.conf to verify. If you don't want SSL on then set to off. If you want it on and need a certificate see: https://www.postgresql.org/docs/14/ssl-tcp.html#SSL-CERTIFICATE-CREATION You were right. Many thanks Howard.

Is ODBC list dead?

2022-08-12 Thread Igor Korot
Hi, If the list IS dead - where can I get help on the topic... Thank you.

Re: Could not load server certificate file "server.crt": No such file or directory.

2022-08-12 Thread Adrian Klaver
On 8/12/22 10:02 AM, howardn...@selestial.com wrote: Hi, Running 14.4.1 on Mac OSX on M1 and found that the postgres daemon had not started. It was running fine previously. When I ran the following command line: sudo -u postgres /Library/Postgresql/14/bin/postmaster -D

Could not load server certificate file "server.crt": No such file or directory.

2022-08-12 Thread howardnews
Hi, Running 14.4.1 on Mac OSX on M1 and found that the postgres daemon had not started. It was running fine previously. When I ran the following command line: sudo -u postgres /Library/Postgresql/14/bin/postmaster -D /Library/Postgresql/14/data I get the following error: 2022-08-12

Scale 19x presentations

2022-08-12 Thread Lawrence Layhee
Hi Stephen Frost, You gave a great presentation at scale 19x and indicated you would provide the sides. Would it be possible to obtain them or post them on the scale 19x website. Thanks Larry Lawrence Layhee Database Administration Midrange Computing Division Los Angeles County Internal

RE: Migrating PostgreSQL Stored Procedures to MSSQL 2019 for example

2022-08-12 Thread Joel Rabinovitch
Hi, When we did our migration from SQL Server to PostgreSQL, we mainly used two tools: sqlserver2pgsql for most of our schema-related changes. You can find that here: https://github.com/dalibo/sqlserver2pgsql. AWS Schema Conversion Tool (SCT) for migrating views and stored

Call for Volunteers - pgconf.nyc 2022

2022-08-12 Thread Andreas 'ads' Scherbaum
PGconf.NYC 2021 takes place in New York City, September 22-23. If you've frequented previous PostgreSQL conferences, you've seen enthusiastic volunteers who have helped make the event a pleasant experience for all our visitors. If you want to be a part of this great team, here's your chance to

Migrating PostgreSQL Stored Procedures to MSSQL 2019 for example

2022-08-12 Thread Scott Simpson
Hi, I need to migrate many PostgreSQL Stored Procedures and functions to MSSQL. I can find anything online that seems to handle this task. Are there any tools that you have that can do this job? Kind Regards Zellis | Scott Simpson | Senior Engineer