Feature Request: Support for Cloud Managed PostgreSQL Integration

[spawar-apex]

What's the problem this feature will solve?
We request the addition of native support for integrating cloud-managed PostgreSQL databases in Faraday. This capability will help users leverage scalable, secure, and managed database services offered by cloud providers (e.g., AWS RDS for PostgreSQL, Google Cloud SQL for PostgreSQL, Azure Database for PostgreSQL) to enhance the scalability, security, and manageability of Faraday deployments.

Describe the solution you'd like

1. Configuration Options:
   • Implement a feature in Faraday allowing users to input connection credentials (host, port, username, password, SSL settings) for their cloud-managed PostgreSQL instance.
   • Add options for environment variable-based credentials for deploying in CI/CD and containerized setups.
2. Secure Connections:
   • Ensure integration supports secure connections, including SSL/TLS certificates.
3. Testing/Validation:
   • Include validation checks to ensure cloud PostgreSQL connections are correctly established.
   • Add error handling for configuration issues, downtime, or regional connectivity concerns.
4. Documentation:
   • Provide documentation for configuring Faraday to connect with popular cloud-managed PostgreSQL providers.
   • Include examples for AWS RDS, Google's Cloud SQL, and Azure Database for PostgreSQL.

Use Case:

A cybersecurity consulting firm uses Faraday to deliver vulnerability scanning and reporting services to clients. Their Faraday installations frequently handle high-value data that requires strong reliability and disaster recovery mechanisms.

Problem Solved:

• Cloud-managed PostgreSQL services often offer automated backups, point-in-time recovery for databases, and replication for high availability, reducing risks of data loss in critical consulting environments.
• These features are difficult to maintain (or require additional resources) on local databases, especially for small-to-medium businesses that lack specialized database administrators.

Alternative Solutions

Additional context
Examples of cloud-managed PostgreSQL services the integration may target:

• Amazon RDS for PostgreSQL
• Google Cloud SQL for PostgreSQL
• Azure Database for PostgreSQL

[ezk06eer]

Hi @spawar-apex,

Thank you for your request,

At this time, we do not plan to introduce native configuration or direct integration for cloud-managed PostgreSQL instances within Faraday Community. While we recognize the value such support could bring especially in enhancing scalability, reliability, and ease of management for consulting environments. Our current development focus remains on core functionalities that benefit the broader user base.

That said, we’d like to suggest some alternative approaches that may meet your needs in the interim:

Custom Configuration via Existing PostgreSQL Support
Faraday already supports connecting to remote PostgreSQL instances. You can configure secure external connections to your cloud-hosted database by supplying connection credentials (host, port, user, password, and SSL options) in the existing configuration files or via environment variables in containerized setups.
here

SSL/TLS Connectivity
Faraday supports SSL connections with PostgreSQL. You can establish encrypted communication with cloud providers by properly configuring certificate paths in your postgresql.conf or connection string.

Community and Documentation Contributions
While we may not provide official documentation for each cloud provider at this time, we welcome contributions or shared examples from the community. These could be incorporated into our public documentation for broader visibility and shared benefit.

We appreciate your feedback and encourage you to continue sharing your use cases with us! it helps shape future development priorities. If you encounter specific issues when connecting Faraday to a cloud-managed PostgreSQL service using the above methods, we’d be happy to assist you through our support channels.

Get in touch with us for anything you may need: https://faradaysec.com/get-started/

Thank you again for helping us improve Faraday.