Cloud SQL PostgreSQL logs error: missing password_validation_* functions coming from cloudsqladmin

[Sultan_Achmad]

Hi,

I’m running a PostgreSQL instance on Cloud SQL and recently noticed a lot of errors in the logs coming from the cloudsqladmin user. The errors look like this:

ERROR: function password_validation_get_validation_latencies(reset => boolean) does not exist
STATEMENT: SELECT * FROM password_validation_get_validation_latencies(reset => false)

ERROR: function password_validation_get_login_latencies(reset => boolean) does not exist
STATEMENT: SELECT * FROM password_validation_get_login_latencies(reset => false)

ERROR: function password_validation_get_policy_errors(reset => boolean) does not exist
STATEMENT: SELECT * FROM password_validation_get_policy_errors(reset => false) WHERE reason != 'OK'

ERROR: function password_validation_get_login_errors(reset => boolean) does not exist
STATEMENT: SELECT * FROM password_validation_get_login_errors(reset => false) WHERE reason != 'OK'

Here’s what i found:

• these functions doesn’t appear to be available.
• The queries are being run automatically by the internal cloudsqladmin user every 30 seconds.

Questions:

1. Should I just ignore these errors, or is there a way to create function for my instance?

2. If this is a Cloud SQL bug (monitoring trying to call missing functions), is there a fix or a way to suppress these log entries?

Instance details:

• Cloud SQL PostgreSQL (PostgreSQL 14)

• Region: asia-northeast1-c

Thanks in advance!

[klimadata]

Hi,
Thanks for reporting, same issue here.
I have set password policy, but errors persist. Also, the dashboard shows an error.
Instance details:

• Cloud SQL >> PostgreSQL 17.5
• Region: us-central1-c

[joseph_athman-1]

Same issue for us as well. Started yesterday.

[Sarath_Mohan]

Same issue for us as well. Started yesterday.

[Smiley]

Have the same issue:

DB version: PostgreSQL 17.5
Region: **us-central1-c

It just randomly started firing errors:

ERROR:  function password_validation_get_login_latencies(reset => boolean) does not exist at character 15`

In sum it’s 16.966k for me - in couple days, how can we fix that?

[kbozeki]

Same issue. Started 2025-08-18T09:09:43.722374Z

[ScottHall]

+1

[Lion7de]

+1

[joseph_athman-1]

I confirmed with Google that they know about the issue and are working on a fix and expect it to be complete within 2 weeks.

[Spitfire]

Same issue here, but only on one of our instances.

[Akshit_shah]

The errors occur because the password validation functions are not defined in the database. Check if the required extension/plugin is installed and available in the current schema, or adjust queries accordingly.

[kbozeki]

Seems fixed. Stopped at 2025-08-25T19:05:09.062852013Z