Advanced Search
Search Results
4 total results found
openGauss
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 ...
WAL & Archive Mode
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...
Recovery Mode
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 Most likely the disk ran out of space. Check postgres logs. Check recovery state. SELECT pg_is_in_recovery...
Common SQL
Connect psql psql -U xxx -d postgres psql -U xxx -d postgres -p List Databases \l List Tables \dt Select Database \c xxx Create Database CREATE DATABASE foo WITH OWNER = kuga ENCODING = 'UTF8' LC_COLLATE = 'C' LC_CTYPE = 'C' TEMPLATE = t...