[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;