Re: What's your experience with using Postgres in IoT-contexts?
> I want to have long term storage and access to individual telegrams An IOT is not designed for that. It is used for control or delivery of data to a server. You could have a PostgreSQL-client in the IOT but an MQ might be better. Long term storage also means backup and recovery and I don't think you have that planned for your IOT. ./hans
LDAP, single sign on from Windows client
Hi I have a Linux server which is setup with authentication via LDAP against a Windows A/D. In pg_hba I have host ... ldap ldapserver=example.org ldapprefix="" ldapsuffix="@example.org" The user is also created in PostgreSQL but without a password. I can then login with psql from a Windows client with a user defined in the AD. But the problem is that psql asks for a password. Is it possible to make a single sign-on without the password prompt? The Linux (Ubuntu) has been joined to the domain with "realm" but it doesn't seem to change anything. best regards Hans Schou
Re: Regex for Word space Word space Word ....
On Tue, Nov 23, 2021 at 11:51 AM Shaozhong SHI wrote: > I tried nested regex '[[A-Z][a-z] ]+[[A-Z][a-z]]' but it did not work. > [A-Z][a-z]+ +[A-Z][a-z]+ will match 'Hello World', but not 'Hello world'. Is that what you want? Try this instead [A-Za-z]+ +[A-Za-z]+ And try also this editor to learn regex https://regex101.com/ ./hans
