Загрузка данных


[angel2@redosdozorbd ~]$ grep -n "CREATE TABLE public._accumrg3035" /tmp/restore.log
[angel2@redosdozorbd ~]$ gunzip -c /mnt/data/dump.gz | grep -n ""CREATE TABLE public._accumrg3035"
> ^C
[angel2@redosdozorbd ~]$ gunzip -c /mnt/data/dump.gz | grep -n "CREATE TABLE public._accumrg3035" 
2917:CREATE TABLE public._accumrg3035 (
^C
[angel2@redosdozorbd ~]$ gunzip -c /mnt/data/dump.gz | sed -n '2900,3000p'
-- Name: TABLE _accopt; Type: MAC LABEL; Schema: public; Owner: postgres
--

MAC LABEL ON TABLE public._accopt IS '{0,0}';


--
-- Name: TABLE _accopt; Type: MAC CCR; Schema: public; Owner: postgres
--

MAC CCR ON TABLE public._accopt IS ON;


--
-- Name: _accumrg3035; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public._accumrg3035 (
    _period timestamp without time zone NOT NULL,
    _recorderrref bytea NOT NULL,
    _lineno numeric(9,0) NOT NULL,
    _active boolean NOT NULL,
    _recordkind numeric(1,0) NOT NULL,
    _fld3036rref bytea NOT NULL,
    _fld3037 numeric(13,2) NOT NULL,
    _fld3038 timestamp without time zone NOT NULL
)
WITH (MACS=FALSE, autovacuum_enabled='true', toast.autovacuum_enabled='true');


ALTER TABLE public._accumrg3035 OWNER TO postgres;

--
-- Name: TABLE _accumrg3035; Type: MAC LABEL; Schema: public; Owner: postgres
--

MAC LABEL ON TABLE public._accumrg3035 IS '{0,0}';


--
-- Name: TABLE _accumrg3035; Type: MAC CCR; Schema: public; Owner: postgres
--

MAC CCR ON TABLE public._accumrg3035 IS ON;


--
-- Name: _accumrg6925; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public._accumrg6925 (
    _period timestamp without time zone NOT NULL,
    _recorderrref bytea NOT NULL,
    _lineno numeric(9,0) NOT NULL,
    _active boolean NOT NULL,
    _recordkind numeric(1,0) NOT NULL,
    _fld6926rref bytea NOT NULL,
    _fld6927 numeric(13,2) NOT NULL,
    _fld6928 timestamp without time zone NOT NULL,
    _fld6929 public.mvarchar(40) NOT NULL,
    _fld6930 public.mvarchar NOT NULL
)
WITH (MACS=FALSE, autovacuum_enabled='true', toast.autovacuum_enabled='true');


ALTER TABLE public._accumrg6925 OWNER TO postgres;

--
-- Name: TABLE _accumrg6925; Type: MAC LABEL; Schema: public; Owner: postgres
--

MAC LABEL ON TABLE public._accumrg6925 IS '{0,0}';


--
-- Name: TABLE _accumrg6925; Type: MAC CCR; Schema: public; Owner: postgres
--

MAC CCR ON TABLE public._accumrg6925 IS ON;


--
-- Name: _accumrgopt3040; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public._accumrgopt3040 (
    _regid bytea NOT NULL,
    _period timestamp without time zone NOT NULL,
    _actualperiod boolean NOT NULL,
    _periodicity numeric(2,0) NOT NULL,
    _repetitionfactor numeric(2,0) NOT NULL,
    _usetotals numeric(1,0) NOT NULL,
    _minperiod timestamp without time zone NOT NULL,
    _usesplitter boolean NOT NULL,
    _mincalculatedperiod timestamp without time zone NOT NULL
)
WITH (MACS=FALSE, autovacuum_enabled='true', toast.autovacuum_enabled='true');
ALTER TABLE ONLY public._accumrgopt3040 ALTER COLUMN _regid SET STORAGE PLAIN;


ALTER TABLE public._accumrgopt3040 OWNER TO postgres;