Skip to main content
Supported Regions:上海

FAQ

Backup and Recovery​

PostgreSQL database backup and recovery is powered by Tencent Cloud PostgreSQL service, including automatic and manual backups.

For detailed backup policies, procedures, and data recovery methods, refer to the Tencent Cloud documentation:

Usage Questions​

How does PostgreSQL support transactions?​

The CloudBase PostgreSQL SDK does not currently support transaction operations directly. For transaction needs, the following approaches are recommended:

  1. Use RPC calls: Encapsulate transaction logic within database functions via Database RPC Calls, suitable for most transaction scenarios.
  2. Use pg protocol direct connection: If RPC still cannot meet your needs, connect directly to the PostgreSQL database via the pg protocol and use the native PostgreSQL SDK for full transaction control.

Query returns empty results despite correct conditions​

When a database query returns empty results, it is usually due to one of the following:

  1. No data matches the query conditions
  2. Data is filtered by RLS permission policies

Troubleshooting​

  1. Verify data existence

    • Check in the CloudBase console whether the target data exists in the table
    • Verify that field values match expectations

  2. Check RLS permission configuration

    • Check if Row Level Security (RLS) is enabled on the table and if the policies allow the current user to read
    • RLS policies typically use auth.uid() to determine data ownership — verify the current user identity matches
    • Refer to the Data Permissions documentation to check policy configuration

  3. Verify query conditions

    • Simplify query conditions and progressively narrow down which condition causes empty results
    • Check field names, data types, and query syntax