pg_dump -h 127.0.0.1 -U jiang postgres > databasename.bak
psql -h localhost -U jiang -d postgres < databasename.bak
databasename.bak底部内容
COPY public.t1 (id, c1) FROM stdin;
1 3
1 3
1 3
1 3
1 3
1 2
\.
--
-- Data for Name: t2; Type: TABLE DATA; Schema: public; Owner: jiang
--
COPY public.t2 (id, c1) FROM stdin;
1 b
\.
--
-- PostgreSQL database dump complete
--