🐘 PostgreSQL Password Generator

🔑 Password Input

Show password

🐘 PostgreSQL Format

💡 Examples

📤 Generated Hash

{{ result.hash }}

🔍 Hash Details

Version: {{ result.version }}

Algorithm: {{ result.algorithm }}

Format: {{ result.format }}

Description: {{ result.description }}

Iterations: {{ result.iterations }}

Salt: {{ result.salt }}

⚠️ {{ result.warning }}

🗄️ SQL Command

{{ sqlCommand }}

🔒 Security Information

⚠️ {{ error }}

ℹ️ About PostgreSQL Password Generator

PostgreSQL Password Hashing generates password hashes used by PostgreSQL database server for user authentication. Different PostgreSQL versions support different hashing algorithms for storing user passwords securely.

PostgreSQL documents password authentication in its password authentication guide. SCRAM is specified by RFC 5802, with the SCRAM-SHA-256 mechanism in RFC 7677.

PostgreSQL Password Formats:

MD5: traditional PostgreSQL format using md5 plus a digest of password and username; retained for compatibility.
SCRAM-SHA-256: modern salted, iterated verifier format recommended for current PostgreSQL deployments.
Unix crypt: traditional Unix crypt() style output for legacy analysis.
Plain text: included only for testing examples; never store or deploy plain-text database passwords.

Common Use Cases:

Creating PostgreSQL user accounts with specific password hashes
Database administration and user management
Password verification and authentication testing
Database migration between different PostgreSQL versions
Security analysis and penetration testing
Understanding PostgreSQL authentication mechanisms

Security Notes: SCRAM-SHA-256 is the most secure format and is recommended for PostgreSQL 10+. MD5 format is deprecated but still supported for backward compatibility. Plain text should never be used in production. Avoid pasting production database passwords into a web tool; use disposable examples for documentation, migration planning, and authentication lab testing.

API Usage Example:

POST /api/tools/crypto/postgresql-password-generator
Content-Type: application/json

{
    "password": "mySecretPassword",
    "username": "postgres",
    "version": "scram_sha256"
}