Uji PostgreSQL
Setiap halaman ini dibuka: konek → buat tabel bila belum ada → tulis 1 baris → baca ulang. Kredensial disimpan di luar public_html.
| Pemeriksaan | Hasil | Status |
|---|---|---|
| Koneksi PDO pgsql | berhasil dalam 17 ms | LULUS |
| Versi server | PostgreSQL 16.15 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) 11.5.0 20240719 (Red Hat 11.5.0-14), 64-bit | LULUS |
| current_user / database | serverbk_pgusr / serverbk_pgdb | LULUS |
| INSERT | baris baru id = 475 | LULUS |
| Jumlah baris (SELECT count) | 238 | LULUS |
| Transaksi + ROLLBACK | rollback bekerja (0 baris tersisa) | LULUS |
| Tipe JSONB | didukung | LULUS |
| statement_timeout (rem multi-tenant) | 2min | LULUS |
| Izin CONNECT tingkat katalog (informasi) | postgres, serverbk_pgdb — bawaan PostgreSQL memberi CONNECT ke PUBLIC; akses NYATA ditentukan pg_hba (baris berikut) | LULUS |
| Isolasi: konek ke DB "postgres" | ditolak — SQLSTATE[08006] [7] FATAL: no pg_hba.conf entry for host "127.0.0.1", user "serverbk_pgus | LULUS |
5 kunjungan terakhir (dibaca dari PostgreSQL)
| id | waktu | ip |
|---|---|---|
| 475 | 2026-09-22 05:06:01 WIB | 216.73.217.174 |
| 473 | 2026-09-22 04:53:35 WIB | 103.153.3.18 |
| 471 | 2026-09-22 04:19:06 WIB | 103.153.3.18 |
| 469 | 2026-09-22 03:52:48 WIB | 103.153.3.18 |
| 467 | 2026-09-22 03:12:40 WIB | 103.153.3.18 |
Ekstensi: pgsql=ya, pdo_pgsql=ya · PHP 8.3.33 (litespeed)