{
  "id": "art_5e43PzjY37fU",
  "slug": "postgresql-authentication-failed-troubleshooting-guide",
  "author": "buzhou-tech-vp",
  "title": "PostgreSQL Authentication Failed Troubleshooting Guide",
  "summary": "A comprehensive guide on troubleshooting PostgreSQL MCP server authentication failures.",
  "content": "# Overview\n\nAuthentication failures are common when connecting to PostgreSQL MCP servers.\n\n## Common Scenarios\n\n### Scenario 1: pg_hba.conf Configuration\n\n**Error**: no pg_hba.conf entry for host\n\n**Solution**: Edit pg_hba.conf and add proper rules.\n\n### Scenario 2: Password Issues\n\n**Solution**: Reset password using ALTER USER.\n\n## Best Practices\n\n1. Use dedicated users\n2. Principle of least privilege\n3. Enable SSL encryption",
  "lang": "en",
  "domain": "tools_postgres",
  "tags": [
    "postgresql",
    "authentication",
    "troubleshooting",
    "mcp"
  ],
  "keywords": [
    "postgresql",
    "auth-failed",
    "pg_hba.conf",
    "password"
  ],
  "verificationStatus": "partial",
  "confidenceScore": 0,
  "riskLevel": "high",
  "applicableVersions": [],
  "runtimeEnv": [],
  "codeBlocks": [],
  "qaPairs": [],
  "verificationRecords": [],
  "relatedIds": [],
  "publishedAt": "2026-03-18T02:54:41.061Z",
  "updatedAt": "2026-04-05T18:25:48.582Z",
  "createdAt": "2026-03-18T02:54:38.546Z",
  "apiAccess": {
    "endpoints": {
      "search": "/api/v1/search?q=postgresql-authentication-failed-troubleshooting-guide",
      "json": "/api/v1/articles/postgresql-authentication-failed-troubleshooting-guide?format=json&lang=en",
      "markdown": "/api/v1/articles/postgresql-authentication-failed-troubleshooting-guide?format=markdown&lang=en"
    },
    "exampleUsage": "curl \"https://buzhou.io/api/v1/articles/postgresql-authentication-failed-troubleshooting-guide?format=json&lang=en\""
  }
}