ืื ื’ืœื™ืชืฆืจืคืชื™ืชืกืคืจื“ื™

ืกืžืœ OnWorks

pg_resetxlog - ืžืงื•ื•ืŸ ื‘ืขื ืŸ

ื”ืคืขืœ ืืช pg_resetxlog ื‘ืกืคืง ื”ืื™ืจื•ื— ื”ื—ื™ื ืžื™ ืฉืœ OnWorks ื‘ืืžืฆืขื•ืช ืื•ื‘ื•ื ื˜ื• ืžืงื•ื•ืŸ, ืคื“ื•ืจื” ืžืงื•ื•ืŸ, ืืžื•ืœื˜ื•ืจ ืžืงื•ื•ืŸ ืฉืœ Windows ืื• ืืžื•ืœื˜ื•ืจ ืžืงื•ื•ืŸ ืฉืœ MAC OS

ื–ื•ื”ื™ ื”ืคืงื•ื“ื” pg_resetxlog ืฉื ื™ืชืŸ ืœื”ืจื™ืฅ ื‘ืกืคืง ื”ืื™ืจื•ื— ื”ื—ื™ื ืžื™ ืฉืœ OnWorks ื‘ืืžืฆืขื•ืช ืื—ืช ืžืชื—ื ื•ืช ื”ืขื‘ื•ื“ื” ื”ืžืงื•ื•ื ื•ืช ื”ืžืจื•ื‘ื•ืช ืฉืœื ื•, ื›ื’ื•ืŸ Ubuntu Online, Fedora Online, ืืžื•ืœื˜ื•ืจ ืžืงื•ื•ืŸ ืฉืœ Windows ืื• ืืžื•ืœื˜ื•ืจ ืžืงื•ื•ืŸ ืฉืœ MAC OS

ืชึธื›ึฐื ึดื™ืช:

ืฉืึตื


pg_resetxlog - ืืคืก ืืช ื™ื•ืžืŸ ื”ื›ืชื™ื‘ื” ืงื“ื™ืžื” ื•ืžื™ื“ืข ื‘ืงืจื” ืื—ืจ ืฉืœ PostgreSQL
ืืฉื›ื•ืœ ืžืกื“ ื ืชื•ื ื™ื

ืชึทืงืฆึดื™ืจ


pg_resetxlog [-c xid,xid] [-f] [-n] [-o ื”ื•ืฆื] [-x xid] [-e xid_epoch] [-m mxid,mxid]
[-O ืžืงืกื•ืฃ] [-l xlogfile] {[-D] ื“ืื˜ืื“ื™ืจ}

ืชื™ืื•ืจ


pg_resetxlog ืžื ืงื” ืืช ื™ื•ืžืŸ ื”ื›ืชื™ื‘ื” ืงื“ื™ืžื” (WAL) ื•ืžืืคืก ืื•ืคืฆื™ื•ื ืœื™ ืคืงื“ ืื—ืจ
ืžื™ื“ืข ื”ืžืื•ื—ืกืŸ ื‘ืงื•ื‘ืฅ pg_control. ืœืคืขืžื™ื ื™ืฉ ืฆื•ืจืš ื‘ืคื•ื ืงืฆื™ื” ื–ื• ืื ืืœื”
ืงื‘ืฆื™ื ื ืคื’ืžื•. ื™ืฉ ืœื”ืฉืชืžืฉ ื‘ื• ืจืง ื›ืžื•ืฆื ืื—ืจื•ืŸ, ื›ืืฉืจ ื”ืฉืจืช ื™ืขืฉื” ื–ืืช
ืœื ืœื”ืชื—ื™ืœ ื‘ื’ืœืœ ืฉื—ื™ืชื•ืช ื›ื–ื•.

ืœืื—ืจ ื”ืคืขืœืช ืคืงื•ื“ื” ื–ื•, ื–ื” ืืžื•ืจ ืœื”ื™ื•ืช ืืคืฉืจื™ ืœื”ืคืขื™ืœ ืืช ื”ืฉืจืช, ืืš ื–ื›ื•ืจ
ื›ื™ ืžืกื“ ื”ื ืชื•ื ื™ื ืขืฉื•ื™ ืœื”ื›ื™ืœ ื ืชื•ื ื™ื ืœื ืขืงื‘ื™ื™ื ืขืงื‘ ืขืกืงืื•ืช ืžื—ื•ื™ื‘ื•ืช ื—ืœืงื™ืช.
ืืชื” ืฆืจื™ืš ืžื™ื“ ืœื–ืจื•ืง ืืช ื”ื ืชื•ื ื™ื ืฉืœืš, ืœืจื•ืฅ initdb, ื•ื˜ืขืŸ ืžื—ื“ืฉ. ืœืื—ืจ ื˜ืขื™ื ื” ืžื—ื“ืฉ, ื‘ื“ื•ืง ืื
ื—ื•ืกืจ ืขืงื‘ื™ื•ืช ื•ืชื™ืงื•ืŸ ืœืคื™ ื”ืฆื•ืจืš.

ื›ืœื™ ื–ื” ื™ื›ื•ืœ ืœื”ื™ื•ืช ืžื•ืคืขืœ ืจืง ืขืœ ื™ื“ื™ ื”ืžืฉืชืžืฉ ืฉื”ืชืงื™ืŸ ืืช ื”ืฉืจืช, ื›ื™ ื”ื•ื ื“ื•ืจืฉ
ื’ื™ืฉืช ืงืจื™ืื”/ื›ืชื™ื‘ื” ืœืกืคืจื™ื™ืช ื”ื ืชื•ื ื™ื. ืžื˜ืขืžื™ ื‘ื˜ื™ื—ื•ืช, ืขืœื™ืš ืœืฆื™ื™ืŸ ืืช ื”ื ืชื•ื ื™ื
ืกืคืจื™ื™ื” ื‘ืฉื•ืจืช ื”ืคืงื•ื“ื”. pg_resetxlog ืื™ื ื• ืžืฉืชืžืฉ ื‘ืžืฉืชื ื” ื”ืกื‘ื™ื‘ื” PGDATA.

If pg_resetxlog ืžืชืœื•ื ืŸ ืฉื”ื•ื ืœื ื™ื›ื•ืœ ืœืงื‘ื•ืข ื ืชื•ื ื™ื ื—ื•ืงื™ื™ื ืขื‘ื•ืจ pg_control, ืืชื” ื™ื›ื•ืœ
ืœืืœืฅ ืื•ืชื• ืœื”ืžืฉื™ืš ื‘ื›ืœ ื–ืืช ืขืœ ื™ื“ื™ ืฆื™ื•ืŸ ื” -f ืืคืฉืจื•ืช (ื›ื•ื—). ื‘ืžืงืจื” ื”ื–ื” ืกื‘ื™ืจ
ื”ืขืจื›ื™ื ื™ื—ืœื™ืคื• ืืช ื”ื ืชื•ื ื™ื ื”ื—ืกืจื™ื. ื ื™ืชืŸ ืœืฆืคื•ืช ืœืžืจื‘ื™ืช ื”ืชื—ื•ืžื™ื
ื”ืชืืžื”, ืืš ื™ื™ืชื›ืŸ ืฉื™ื”ื™ื” ืฆื•ืจืš ื‘ืกื™ื•ืข ื™ื“ื ื™ ืขื‘ื•ืจ ื”-OID ื”ื‘ื, ืžื–ื”ื” ื”ืขืกืงื” ื”ื‘ืื” ื•
ืขื™ื“ืŸ, ืžื–ื”ื” ืจื™ื‘ื•ื™ ืขืกืงืื•ืช ื”ื‘ื ื•ืงื™ื–ื•ื–, ื•ืฉื“ื•ืช ื›ืชื•ื‘ืช ื”ืชื—ืœื” ืฉืœ WAL. ื”ืฉื“ื•ืช ื”ืืœื”
ื ื™ืชืŸ ืœื”ื’ื“ื™ืจ ื‘ืืžืฆืขื•ืช ื”ืืคืฉืจื•ื™ื•ืช ื”ื ื“ื•ื ื•ืช ืœื”ืœืŸ. ืื ืืชื” ืœื ื™ื›ื•ืœ ืœืงื‘ื•ืข ื ื›ื•ืŸ
ืขืจื›ื™ื ืขื‘ื•ืจ ื›ืœ ื”ืฉื“ื•ืช ื”ืืœื”, -f ืขื“ื™ื™ืŸ ื ื™ืชืŸ ืœื”ืฉืชืžืฉ, ืื‘ืœ ืžืกื“ ื”ื ืชื•ื ื™ื ื”ืžืฉื•ื—ื–ืจ ื—ื™ื™ื‘ ืœื”ื™ื•ืช
ืžื˜ื•ืคืœ ื‘ื—ืฉื“ื ื•ืช ืืคื™ืœื• ื™ื•ืชืจ ืžื”ืจื’ื™ืœ: ืžื–ื‘ืœื” ืžื™ื™ื“ื™ืช ื•ื˜ืขื™ื ื” ืžื—ื“ืฉ ื”ื™ื ื”ื›ืจื—ื™ืช.
Do ืœึนื ื‘ืฆืข ื›ืœ ืคืขื•ืœื•ืช ืœืฉื™ื ื•ื™ ื ืชื•ื ื™ื ื‘ืžืกื“ ื”ื ืชื•ื ื™ื ืœืคื ื™ ืฉืืชื” dump, ื›ืžื• ื›ืœ ื›ื–ื”
ืคืขื•ืœื” ืขืฉื•ื™ื” ืœื”ื—ืžื™ืจ ืืช ื”ืฉื—ื™ืชื•ืช.

ื”ืฉืžื™ื™ื -o, -x, -e, -m, -O, -c ื• -l ืืคืฉืจื•ื™ื•ืช ืžืืคืฉืจื•ืช ืืช ื”-OID ื”ื‘ื, ืžื–ื”ื” ื”ืขืกืงื” ื”ื‘ืื”, ื”ื‘ื
ื”ืขื™ื“ืŸ ืฉืœ ืžื–ื”ื” ื”ืขืกืงื”, ืžื–ื”ื” ืจื™ื‘ื•ื™ ื”ืขืกืงืื•ืช ื”ื‘ื ื•ื”ื™ืฉืŸ ื‘ื™ื•ืชืจ, ืงื™ื–ื•ื– ืจื™ื‘ื•ื™ ื”ืขืกืงืื•ืช ื”ื‘ื,
ืžื–ื”ื™ ื”ืขืกืงืื•ืช ื”ืขืชื™ืงื™ื ื•ื”ื—ื“ืฉื™ื ื‘ื™ื•ืชืจ ืขื‘ื•ืจื ื ื™ืชืŸ ืœืื—ื–ืจ ืืช ื–ืžืŸ ื”ื”ืชื—ื™ื™ื‘ื•ืช, ื•-WAL
ืขืจื›ื™ ื›ืชื•ื‘ืช ื”ืชื—ืœื” ืฉื™ื•ื’ื“ืจื• ื‘ืื•ืคืŸ ื™ื“ื ื™. ืืœื” ื ื—ื•ืฆื™ื ืจืง ื›ืืฉืจ pg_resetxlog is
ืœื ืžืกื•ื’ืœ ืœืงื‘ื•ืข ืขืจื›ื™ื ืžืชืื™ืžื™ื ืขืœ ื™ื“ื™ ืงืจื™ืืช pg_control. ืขืจื›ื™ื ื‘ื˜ื•ื—ื™ื ื™ื›ื•ืœื™ื ืœื”ื™ื•ืช
ื ืงื‘ืข ื‘ืื•ืคืŸ ื”ื‘ื:

ยท ืขืจืš ื‘ื˜ื•ื— ืขื‘ื•ืจ ืžื–ื”ื” ื”ืขืกืงื” ื”ื‘ืื” (-x) ื ื™ืชืŸ ืœืงื‘ื•ืข ืขืœ ื™ื“ื™ ื—ื™ืคื•ืฉ ื”-
ืฉื ื”ืงื•ื‘ืฅ ื”ื’ื“ื•ืœ ื‘ื™ื•ืชืจ ืžื‘ื—ื™ื ื” ืžืกืคืจื™ืช ื‘ืกืคืจื™ื™ื” pg_clog ืชื—ืช ืกืคืจื™ื™ืช ื”ื ืชื•ื ื™ื,
ื”ื•ืกืคืช ืื—ื“, ื•ืœืื—ืจ ืžื›ืŸ ื”ื›ืคืœื” ื‘-1048576. ืฉื™ืžื• ืœื‘ ืฉืฉืžื•ืช ื”ืงื‘ืฆื™ื ื ืžืฆืื™ื ื‘
ื”ืงืกื“ืฆื™ืžืœื™. ื‘ื“ืจืš ื›ืœืœ ื”ื›ื™ ืงืœ ืœืฆื™ื™ืŸ ืืช ืขืจืš ื”ืื•ืคืฆื™ื” ื’ื ื‘ื”ืงืกื“ืฆื™ืžืœื™. ืœ
ืœื“ื•ื’ืžื”, ืื 0011 ื”ื•ื ื”ืขืจืš ื”ื’ื“ื•ืœ ื‘ื™ื•ืชืจ ื‘-pg_clog, -x 0x1200000 ื™ืขื‘ื•ื“ (ื—ืžื™ืฉื”
ืืคืกื™ื ื ื’ืจืจื™ื ืžืกืคืงื™ื ืืช ื”ืžื›ืคื™ืœ ื”ืžืชืื™ื).

ยท ืขืจืš ื‘ื˜ื•ื— ืขื‘ื•ืจ ืžื–ื”ื” ืจื™ื‘ื•ื™ ื”ืขืกืงืื•ืช ื”ื‘ื (ื”ื—ืœืง ื”ืจืืฉื•ืŸ ืฉืœ -m) ื ื™ืชืŸ ืœืงื‘ื•ืข ืขืœ ื™ื“ื™
ืžื—ืคืฉ ืืช ืฉื ื”ืงื•ื‘ืฅ ื”ื’ื“ื•ืœ ื‘ื™ื•ืชืจ ืžื‘ื—ื™ื ื” ืžืกืคืจื™ืช ื‘ืกืคืจื™ื™ื” pg_multixact/offsets
ืชื—ืช ืกืคืจื™ื™ืช ื”ื ืชื•ื ื™ื, ื”ื•ืกืคืช ืื—ื“ ื•ืœืื—ืจ ืžื›ืŸ ื”ื›ืคืœื” ื‘-65536. ืœืขื•ืžืช ื–ืืช,
ืขืจืš ื‘ื˜ื•ื— ืขื‘ื•ืจ ืžื–ื”ื” ืจื™ื‘ื•ื™ ื”ืขืกืงืื•ืช ื”ื™ืฉืŸ ื‘ื™ื•ืชืจ (ื”ื—ืœืง ื”ืฉื ื™ ืฉืœ -m) ื ื™ืชืŸ ืœืงื‘ื•ืข ืขืœ ื™ื“ื™
ืžื—ืคืฉ ืืช ืฉื ื”ืงื•ื‘ืฅ ื”ืงื˜ืŸ ื‘ื™ื•ืชืจ ืžื‘ื—ื™ื ื” ืžืกืคืจื™ืช ื‘ืื•ืชื” ืกืคืจื™ื™ื” ื•ืžื›ืคื™ืœ
ืœืคื™ 65536. ื›ืžื• ืœืขื™ืœ, ืฉืžื•ืช ื”ืงื‘ืฆื™ื ื”ื ื”ืงืกื“ืฆื™ืžืœื™ื™ื, ื›ืš ืฉื”ื“ืจืš ื”ืงืœื” ื‘ื™ื•ืชืจ ืœืขืฉื•ืช ื–ืืช
ื”ื•ื ืœืฆื™ื™ืŸ ืืช ืขืจืš ื”ืื•ืคืฆื™ื” ื‘ื”ืงืกื“ืฆื™ืžืœื™ ื•ืœื”ื•ืกื™ืฃ ืืจื‘ืขื” ืืคืกื™ื.

ยท ืขืจืš ื‘ื˜ื•ื— ืœืงื™ื–ื•ื– ืจื™ื‘ื•ื™ ื”ืขืกืงืื•ืช ื”ื‘ื (-O) ื ื™ืชืŸ ืœืงื‘ื•ืข ืขืœ ื™ื“ื™ ื”ืกืชื›ืœื•ืช
ืขื‘ื•ืจ ืฉื ื”ืงื•ื‘ืฅ ื”ื’ื“ื•ืœ ื‘ื™ื•ืชืจ ืžื‘ื—ื™ื ื” ืžืกืคืจื™ืช ื‘ืกืคืจื™ื™ื” pg_multixact/members ืžืชื—ืช ืœ-
ืกืคืจื™ื™ืช ื ืชื•ื ื™ื, ื”ื•ืกืคืช ืื—ื“, ื•ืœืื—ืจ ืžื›ืŸ ื”ื›ืคืœื” ื‘-52352. ื›ืžื• ืœืขื™ืœ, ืฉืžื•ืช ื”ืงื‘ืฆื™ื
ื”ื ื‘ื”ืงืกื“ืฆื™ืžืœื™ื™ื. ืื™ืŸ ืžืชื›ื•ืŸ ืคืฉื•ื˜ ื›ืžื• ืืœื” ืฉืœืžืขืœื” ื‘ืชื•ืกืคืช
ืืคืกื™ื.

ยท ืขืจืš ื‘ื˜ื•ื— ืขื‘ื•ืจ ืžื–ื”ื” ื”ืขืกืงื” ื”ื™ืฉืŸ ื‘ื™ื•ืชืจ ืฉืขื‘ื•ืจื• ื ื™ืชืŸ ืœืื—ื–ืจ ืืช ื–ืžืŸ ื”ื”ืชื—ื™ื™ื‘ื•ืช
(ื”ื—ืœืง ื”ืจืืฉื•ืŸ ืฉืœ -c) ื ื™ืชืŸ ืœืงื‘ื•ืข ืขืœ ื™ื“ื™ ื—ื™ืคื•ืฉ ืฉื ื”ืงื•ื‘ืฅ ื”ืงื˜ืŸ ื‘ื™ื•ืชืจ ืžื‘ื—ื™ื ื” ืžืกืคืจื™ืช
ื‘ืกืคืจื™ื™ื” pg_commit_ts ืชื—ืช ืกืคืจื™ื™ืช ื”ื ืชื•ื ื™ื. ืœืขื•ืžืช ื–ืืช, ืขืจืš ื‘ื˜ื•ื— ืขื‘ื•ืจ
ืžื–ื”ื” ื”ืขืกืงื” ื”ื—ื“ืฉ ื‘ื™ื•ืชืจ ืฉืขื‘ื•ืจื• ื ื™ืชืŸ ืœืื—ื–ืจ ืืช ื–ืžืŸ ื”ื”ืชื—ื™ื™ื‘ื•ืช (ื—ืœืง ืฉื ื™ ืฉืœ
-c) ื ื™ืชืŸ ืœืงื‘ื•ืข ืขืœ ื™ื“ื™ ื—ื™ืคื•ืฉ ืื—ืจ ืฉื ื”ืงื•ื‘ืฅ ื”ื’ื“ื•ืœ ื‘ื™ื•ืชืจ ืžื‘ื—ื™ื ื” ืžืกืคืจื™ืช ื‘ืื•ืชื•
ืžึทื“ืจึดื™ืš. ื›ืืžื•ืจ, ืฉืžื•ืช ื”ืงื‘ืฆื™ื ื”ื ื‘ื”ืงืกื“ืฆื™ืžืœื™ื™ื.

ยท ื›ืชื•ื‘ืช ื”ื”ืชื—ืœื” ืฉืœ WAL (-l) ืฆืจื™ืš ืœื”ื™ื•ืช ื’ื“ื•ืœ ื™ื•ืชืจ ืžื›ืœ ืฉื ืงื•ื‘ืฅ ืžืงื˜ืข WAL
ืงื™ื™ื ื›ืขืช ื‘ืกืคืจื™ื™ื” pg_xlog ืชื—ืช ืกืคืจื™ื™ืช ื”ื ืชื•ื ื™ื. ื”ืฉืžื•ืช ื”ืืœื” ื”ื
ื’ื ื‘ื”ืงืกื“ืฆื™ืžืœื™ ื•ื‘ืขืœ ืฉืœื•ืฉื” ื—ืœืงื™ื. ื”ื—ืœืง ื”ืจืืฉื•ืŸ ื”ื•ื "ืžื–ื”ื” ืฆื™ืจ ื”ื–ืžืŸ" ื•
ื‘ื“ืจืš ื›ืœืœ ื™ืฉ ืœืฉืžื•ืจ ืื•ืชื• ื”ื“ื‘ืจ. ืœื“ื•ื’ืžื”, ืื 00000001000000320000004A ื”ื•ื
ื”ืขืจืš ื”ื’ื“ื•ืœ ื‘ื™ื•ืชืจ ื‘-pg_xlog, ื”ืฉืชืžืฉ ื‘-l 00000001000000320000004B ื•ืžืขืœื”.

ื”ืขืจื•ืช
pg_resetxlog ืขืฆืžื• ืžืกืชื›ืœ ืขืœ ื”ืงื‘ืฆื™ื ื‘-pg_xlog ื•ื‘ื•ื—ืจ ื‘ืจื™ืจืช ืžื—ื“ืœ -l ื”ืฆื‘ื”
ืžืขื‘ืจ ืœืฉื ื”ืงื•ื‘ืฅ ื”ืื—ืจื•ืŸ ื”ืงื™ื™ื. ืœื›ืŸ, ื”ืชืืžื” ื™ื“ื ื™ืช ืฉืœ -l ืฆืจื™ืš ืจืง
ื™ื”ื™ื” ืฆื•ืจืš ืื ืืชื” ืžื•ื“ืข ืœืงื•ื‘ืฆื™ ืžืงื˜ืข WAL ืฉืื™ื ื ืงื™ื™ืžื™ื ื›ืขืช
pg_xlog, ื›ื’ื•ืŸ ืขืจื›ื™ื ื‘ืืจื›ื™ื•ืŸ ืœื ืžืงื•ื•ืŸ; ืื• ืื ื™ืฉ ืœืชื•ื›ืŸ ืฉืœ pg_xlog
ืื‘ื“ื• ืœื—ืœื•ื˜ื™ืŸ.

ยท ืื™ืŸ ื“ืจืš ืงืœื” ื™ื—ืกื™ืช ืœืงื‘ื•ืข OID ื”ื‘ื ืฉื”ื•ื ืžืขื‘ืจ ืœื’ื“ื•ืœ ื‘ื™ื•ืชืจ
ื‘ืžืกื“ ื”ื ืชื•ื ื™ื, ืื‘ืœ ืœืžืจื‘ื” ื”ืžื–ืœ ื–ื” ืœื ืงืจื™ื˜ื™ ืœืชืงืŸ ืืช ื”ื”ื’ื“ืจื” ืฉืœ ื”ื‘ื-OID.

ยท ืขื™ื“ืŸ ื–ื™ื”ื•ื™ ื”ืขืกืงื” ืื™ื ื• ืžืื•ื—ืกืŸ ืœืžืขืฉื” ื‘ืฉื•ื ืžืงื•ื ื‘ืžืกื“ ื”ื ืชื•ื ื™ื ืžืœื‘ื“ ื‘-
ืฉื“ื” ืฉื ืงื‘ืข ืขืœ ื™ื“ื™ pg_resetxlog, ื›ืš ืฉื›ืœ ืขืจืš ื™ืขื‘ื•ื“ ืขื“ ืœืžืกื“ ื”ื ืชื•ื ื™ื
ืขืฆืžื• ืžื•ื“ืื’. ื™ื™ืชื›ืŸ ืฉืชืฆื˜ืจืš ืœื”ืชืื™ื ืขืจืš ื–ื” ื›ื“ื™ ืœื”ื‘ื˜ื™ื— ืืช ื”ืฉื›ืคื•ืœ ื”ื–ื”
ืžืขืจื›ื•ืช ื›ื’ื•ืŸ Slony-I ื•-Skytools ืคื•ืขืœื•ืช ื›ื”ืœื›ื” - ืื ื›ืŸ, ืขืจืš ืžืชืื™ื
ืฆืจื™ืš ืœื”ื™ื•ืช ื ื™ืชืŸ ืœื”ืฉื’ื” ืžื”ืžืฆื‘ ืฉืœ ืžืกื“ ื”ื ืชื•ื ื™ื ื”ืžืฉื•ื›ืคืœ ื‘ืžื•ืจื“ ื”ื–ืจื.

ื”ืฉืžื™ื™ื -n (ืœืœื ืคืขื•ืœื”) ืืคืฉืจื•ืช ืžื•ืจื” pg_resetxlog ื›ื“ื™ ืœื”ื“ืคื™ืก ืืช ื”ืขืจื›ื™ื ืฉื ื‘ื ื• ืžื”ื
pg_control ื•ื”ืขืจื›ื™ื ืฉืขื•ืžื“ื™ื ืœื”ืฉืชื ื•ืช, ื•ืื– ืœืฆืืช ืžื‘ืœื™ ืœืฉื ื•ืช ื“ื‘ืจ. ื–ึถื”
ื”ื•ื ื‘ืขื™ืงืจ ื›ืœื™ ืื™ืชื•ืจ ื‘ืื’ื™ื, ืืš ื™ื›ื•ืœ ืœื”ื™ื•ืช ืฉื™ืžื•ืฉื™ ื›ื‘ื“ื™ืงืช ืฉืคื™ื•ืช ืœืคื ื™ ืžืชืŸ ืืคืฉืจื•ืช
pg_resetxlog ืœื”ืžืฉื™ืš ื‘ืืžืช.

ื”ืฉืžื™ื™ื -V ื• --ื’ึดืจึฐืกึธื” ืืคืฉืจื•ื™ื•ืช ืœื”ื“ืคื™ืก ืืช ื’ืจืกืช pg_resetxlog ื•ืœืฆืืช. ื”ืืคืฉืจื•ื™ื•ืช -? ื•
- ืขื–ืจื” ื”ืฆื’ ื˜ื™ืขื•ื ื™ื ื ืชืžื›ื™ื ื•ืฆื.

ืื•ืจื™ื


ืืกื•ืจ ืœื”ืฉืชืžืฉ ื‘ืคืงื•ื“ื” ื–ื• ื›ืฉื”ืฉืจืช ืคื•ืขืœ. pg_resetxlog ื™ืกืจื‘
ื”ืคืขืœ ืื ื”ื•ื ืžื•ืฆื ืงื•ื‘ืฅ ื ืขื™ืœืช ืฉืจืช ื‘ืกืคืจื™ื™ืช ื”ื ืชื•ื ื™ื. ืื ื”ืฉืจืช ืงืจืก ืื–
ื™ื™ืชื›ืŸ ืฉืงื•ื‘ืฅ ื ืขื™ืœื” ื ื•ืชืจ ืžืื—ื•ืจ; ื‘ืžืงืจื” ื–ื” ืชื•ื›ืœ ืœื”ืกื™ืจ ืืช ืงื•ื‘ืฅ ื”ื ืขื™ืœื” ืืœ
ืœื”ืชื™ืจ pg_resetxlog ืœืจื•ืฅ. ืื‘ืœ ืœืคื ื™ ืฉืืชื” ืขื•ืฉื” ื–ืืช, ื•ื•ื“ื ืคืขืžื™ื™ื ืฉืื™ืŸ
ืชื”ืœื™ืš ื”ืฉืจืช ืขื“ื™ื™ืŸ ื—ื™.

ื”ืฉืชืžืฉ ื‘-pg_resetxlog ื‘ืื•ืคืŸ ืžืงื•ื•ืŸ ื‘ืืžืฆืขื•ืช ืฉื™ืจื•ืชื™ onworks.net


ืฉืจืชื™ื ื•ืชื—ื ื•ืช ืขื‘ื•ื“ื” ื‘ื—ื™ื ื

ื”ื•ืจื“ ืืคืœื™ืงืฆื™ื•ืช Windows & Linux

  • 1
    unitedrpms
    unitedrpms
    ื”ืฆื˜ืจืคื• ืืœื™ื ื• ืœื’ื™ื˜ืจ!
    https://gitter.im/unitedrpms-people/Lobby
    ื”ืคืขืœ ืืช ืžืื’ืจ URPMS ื‘-
    ืžืขืจื›ืช -
    https://github.com/UnitedRPMs/unitedrpms.github.io/bl...
    ื”ื•ืจื“ unitedrpms
  • 2
    Boost C ++ ืกืคืจื™ื•ืช
    Boost C ++ ืกืคืจื™ื•ืช
    Boost ืžืกืคืง ื ื™ื™ื“ ื‘ื—ื™ื ื
    ืกืคืจื™ื•ืช C++ ืฉื ื‘ื“ืงื• ืขืœ ื™ื“ื™ ืขืžื™ืชื™ื. ื”
    ื”ื“ื’ืฉ ื”ื•ื ืขืœ ืกืคืจื™ื•ืช ื ื™ื™ื“ื•ืช ืืฉืจ
    ืœืขื‘ื•ื“ ื”ื™ื˜ื‘ ืขื ื”ืกืคืจื™ื™ื” ื”ืกื˜ื ื“ืจื˜ื™ืช ืฉืœ C++.
    ืจืื” http://www.bo...
    ื”ื•ืจื“ ืกืคืจื™ื•ืช Boost C++
  • 3
    VirtualGL
    VirtualGL
    VirtualGL ืžืคื ื” ืžื—ื“ืฉ ืคืงื•ื“ื•ืช ืชืœืช ืžื™ืžื“ ืž-a
    ื™ื™ืฉื•ื Unix/Linux OpenGL ืขืœ a
    GPU ื‘ืฆื“ ื”ืฉืจืช ื•ืžืžื™ืจ ืืช
    ืขื™ื‘ื•ื“ ืฉืœ ืชืžื•ื ื•ืช ืชืœืช ืžื™ืžื“ ืœื–ืจื ื•ื™ื“ืื•
    ืขื ืื™ื–ื” ...
    ื”ื•ืจื“ ืืช VirtualGL
  • 4
    libusb
    libusb
    ืกืคืจื™ื™ื” ื›ื“ื™ ืœืืคืฉืจ ืžืจื—ื‘ ืžืฉืชืžืฉ
    ืชื•ื›ื ื™ื•ืช ื™ื™ืฉื•ื ืœืชืงืฉื•ืจืช ืื™ืชืŸ
    ื”ืชืงื ื™ USB. ืงื”ืœ: ืžืคืชื—ื™ื, ืกื•ืฃ
    ืžืฉืชืžืฉื™ื/ืฉื•ืœื—ืŸ ืขื‘ื•ื“ื”. ืฉืคืช ืชื›ื ื•ืช: C.
    ืงื˜ื’ื•ืจื™ื•ืช ...
    ื”ื•ืจื“ ืืช libusb
  • 5
    ืœึฐื’ึดื™ืžึธื” ืึฒืจื•ึผื›ึผึธื”
    ืœึฐื’ึดื™ืžึธื” ืึฒืจื•ึผื›ึผึธื”
    SWIG ื”ื•ื ื›ืœื™ ืœืคื™ืชื•ื— ืชื•ื›ื ื”
    ืฉืžื—ื‘ืจ ื‘ื™ืŸ ืชื•ื›ื ื™ื•ืช ื”ื›ืชื•ื‘ื•ืช ื‘-C ื•
    C++ ืขื ืžื’ื•ื•ืŸ ืฉืœ ืจืžื•ืช ื’ื‘ื•ื”ื•ืช
    ืฉืคื•ืช ืชื›ื ื•ืช. SWIG ืžืฉืžืฉ ืขื
    ืฉื•ื ื”...
    ื”ื•ืจื“ ืืช SWIG
  • 6
    WooCommerce Nextjs React Theme
    WooCommerce Nextjs React Theme
    ืขืจื›ืช ื ื•ืฉื WooCommerce ืฉืœ React, ื‘ื ื•ื™ ืขื
    ื”ื‘ื JS, Webpack, Babel, Node ื•
    ืืงืกืคืจืก, ื‘ืืžืฆืขื•ืช GraphQL ื•-Apollo
    ืœึธืงื•ึผื—ึท. WooCommerce Store ื‘-React(
    ืžื›ื™ืœ: ืžื•ืฆืจื™ื...
    ื”ื•ืจื“ ืืช WooCommerce Nextjs React Theme
  • ืขื•ื“ ยป

ืคืงื•ื“ื•ืช ืœื™ื ื•ืงืก

Ad