Plugin do not work with pg4wp

In my project I am using the pg4wp plugin because we needed it running on postgres.
The plugin shows the message:
“Missing Table — One or more required database tables are missing, please check the Diagnostic Info in the Support tab for details”

It seems the plugin was not able to create the table.

I have tested the plugin elsewhere in standard mysql and copied the table from there.

Even tough the table exists, the error still shows the same

Here is the postgres-compatible sql I used to create the table:

CREATE TABLE wp_as3cf_items (
id BIGSERIAL PRIMARY KEY,
provider VARCHAR(18) NOT NULL,
region VARCHAR(255) NOT NULL,
bucket VARCHAR(255) NOT NULL,
path VARCHAR(1024) NOT NULL,
original_path VARCHAR(1024) NOT NULL,
is_private BOOLEAN NOT NULL DEFAULT FALSE,
source_type VARCHAR(18) NOT NULL,
source_id BIGINT NOT NULL,
source_path VARCHAR(1024) NOT NULL,
original_source_path VARCHAR(1024) NOT NULL,
extra_info TEXT,
originator SMALLINT NOT NULL DEFAULT 0,
is_verified BOOLEAN NOT NULL DEFAULT TRUE,
UNIQUE (source_type, source_id),
UNIQUE (is_verified, originator, id),
UNIQUE (path, id),
UNIQUE (original_path, id),
UNIQUE (source_path, id),
UNIQUE (original_source_path, id),
UNIQUE (provider, bucket, id)
);

Here is the diagnostic info from support tab:

Table Prefix: wp_
WordPress: 6.7.1
Web Server: nginx/1.27.3
PHP: 8.1.31
MySQL: 8.0.35
ext/mysqli: yes
PHP Memory Limit: -1
WP Memory Limit: 40M
Memory Usage: 8 MB
Blocked External HTTP Requests: None
WP Locale: pt_BR
Organize offloads by month/year: Enabled
WP_DEBUG: No
WP_DEBUG_LOG: No
WP_DEBUG_DISPLAY: Yes
SCRIPT_DEBUG: No
WP Max Upload Size: 64 MB
PHP Time Limit: 0
PHP Error Log: /dev/stderr
WP Cron: Enabled
fsockopen: Enabled
allow_url_fopen: Enabled
OpenSSL: OpenSSL 3.0.15 3 Sep 2024
cURL: 7.88.1
Zlib Compression: Enabled
PHP GD: bundled (2.1.0 compatible)
Imagick: Enabled
Basic Auth: Disabled
Proxy: Disabled

Total Media Items: 0
Total Offloaded Media Items: 0
Total Not Offloaded Media Items: 0

Media Library Items: 0
Offloaded Media Library Items: 0
Not Offloaded Media Library Items: 0

Number of Image Sizes: 6

Names and Dimensions of Image Sizes:
thumbnail (150×150)
medium (300×300)
large (1024×1024)
1536×1536 (1536×1536)
2048×2048 (2048×2048)

WP_CONTENT_DIR: /var/www/html/wp-content
WP_CONTENT_URL: https://portaljusbr-dev.stg.pdpj.jus.br/wp-content
UPLOADS: Not defined
WP_PLUGIN_DIR: /var/www/html/wp-content/plugins
WP_PLUGIN_URL: https://portaljusbr-dev.stg.pdpj.jus.br/wp-content/plugins

AS3CF_PROVIDER: Not defined
AS3CF_BUCKET: Not defined
AS3CF_REGION: Not defined
AS3CF_SETTINGS: Not defined

Local URL:
https://portaljusbr-dev.stg.pdpj.jus.br/wp-content/uploads/2025/01/example.jpg
Offload URL:
https://portal-media-jus.s3.sa-east-1.amazonaws.com/wp-content/uploads/2025/01/29165816/example.jpg

OME Metadata Version: 12

Custom tables:
wp_as3cf_items: Missing

Storage Provider: Amazon S3
Use Server Roles: On
Key File Path: N/A
Access Keys Set: No
Access Key ID Define: Not defined
Secret Access Key Define: Not defined

Bucket: portal-media-jus
Region: sa-east-1
Block All Public Access: Disabled
Object Ownership Enforced: No

Offload Media: On
Remove Local Media: On
Enable Add Prefix to Bucket Path: On
Custom Prefix for Bucket Path: wp-content/uploads/
Add Year & Month to Bucket Path: On
Add Object Version to Bucket Path: On

Delivery Provider: Amazon S3
Deliver Offloaded Media: On

Force HTTPS: Off

Active Theme Name: CNJ Portal Jus
Active Theme Version: 1.0
Active Theme Folder: portal-jus

Active Plugins:
Advanced Custom Fields (v6.3.6) by WP Engine
Sucuri Security – Auditing, Malware Scanner and Hardening (v1.9.4) by Sucuri Inc.
WP Offload Media Lite (v3.2.11) by Delicious Brains

Drop-ins:
db.php – PostgreSQL for WordPress (PG4WP)