change_qgis_layer_Source.py

from qgis.core import QgsProject, QgsDataSourceUri

project = QgsProject.instance()

old_host = "10.130.0.3"
new_host = "development.com"

for layer_id, layer in project.mapLayers().items():
    if layer.providerType() == 'postgres':
        uri = QgsDataSourceUri(layer.source())
        
        if uri.host() == old_host:
            current_uri = uri.uri()
            new_uri = current_uri.replace(f"host={old_host}", f"host={new_host}")     
            layer.setDataSource(new_uri, layer.name(), 'postgres')
            print(f"Updated layer: {layer.name()}")
project.write()

print("All layers have been updated and the project has been saved.")