crt.sh

Hi Team, I get the following error while trying to fetch domain names via psql. Query used = SELECT

Hello, Is it possible to search cert.sh to find all subdomains and domains with a given keyword? For

Thank you, that seems to have solved it. On Monday, June 17, 2024 at 6:57:55 PM UTC+2 r...@sectigo.

[I just noticed that I replied privately by mistake; resending to the list] Hi Noam. > May I get

Hi Jordan. This happens when users are hammering the replica DBs that power crt.sh:5432. pg_bouncer

Looks like my last reply was directly to you and not to the entire group. Apologies for that. On

Agreed. It certainly breaks the principle of least surprise...! On Wed, 24 Jan 2024 at 17:07, Matthew

Very interesting Sergio. Yes, I had worked out the page sizes quite quickly. I suspect the

Hi Lukas. Thanks for the suggestion. I'll bear it in mind. > I realize of course that

No, I'm afraid there's no documented method for mirroring the database, and we don't

Hi Andrew. PgBouncer, the database connection pooler that sits in front of the crt.sh:5432 servers,

Thanks for the info! On Tuesday, November 28, 2023 at 6:14:46 AM UTC-5 r...@sectigo.com wrote: The

Hi Yaser. Sorry about that. Should be fixed now. (Broken by https://github.com/crtsh/certwatch_db/

This makes sense now. Thank you, Matthew. On Friday, November 17, 2023 at 11:07:31 AM UTC-7 Matthew

Correction: If the answer is primarily hashing (and not the query), then I wonder... On Thursday,

> Although changing this function is trivial, it would also be necessary to rebuild the Full Text

Hi Mike. I did play with pg_trgm a few years ago. IIRC, it was just too slow for crt.sh's use

Hi. This question was asked previously in https://groups.google.com/g/crtsh/c/BdN126Ls3qI/m/

Works now, thanks! On 25.10.2023 16:21, 'r...@sectigo.com' via crt.sh wrote: Hi. This User-

The expiration counting backlog has now gone, so I've removed the "Population counts are

Hi Asad. The crt.sh web interface doesn't currently support that type of search. However, you can

Hi Aayush. Since you've already got "showSQL=Y" in the URL, you can scroll to the

Hi Rob, I also use ZFS and checked the disk size and it was almost the same for both tables, I will

> I'm wondering if you'd be potentially open to a PR for adding a new libx509pg C function

> Speaking of which, I'm a bit confused as to why: > x509_tbscert_strip_ct_ext(c2.

Hi David. Thanks for the heads up. This shouldn't be a problem. On Tuesday, August 8, 2023 at 12:

On Monday, July 24, 2023 at 12:01:56 PM UTC+12 Matthew McPherrin wrote: We (Let's Encrypt) are

You'll also find that the replicas are behind a pgbouncer in statement-pooling mode, with very

As an alternative, Censys does index country, so you could use a certificate search there like:

Hey Rob, Thanks for the insight regarding the issue. Yes indeed there is a significant improvement in