Search Results

Get Process Start Time SELECT pg_postmaster_start_time(); Show Config File SHOW config_file; Show Max Connections SHOW max_connections; Get Total Activity Connections SELECT COUNT(*) AS total_connections FROM pg_stat_activity; Activity Connections Sta...

Official skopeo copy \ --all \ docker://opengauss/opengauss:5.0.0 \ docker://registry.example.com/opengauss/opengauss:5.0.0 docker run -d \ --name opengauss \ -e GS_PASSWORD=foo \ -p 5492:5432 \ registry.example.com/opengauss/opengauss:5.0.0 ...

Error the database system is in recovery mode Sit Env Host: 192.168.80.9 psql -h apple-pgsql.db.example.com -p 5433 -U postgres Trouble Shooting Check recovery state. SELECT pg_is_in_recovery(); Use ps to get process running command. ps aux | grep pgsq...

Problem Set wal_keep_size Set archive_mode=on Unset archive_command This will cause wal_keep_size to not work and the disk to fill up. wal_keep_size Controls the minimum number of WAL files that PostgreSQL will retain, even if they have been used by strea...