2 -- reloid's get lost during a dump/restore - reset them
4 UPDATE _rserv_slave_tables_
8 WHERE relname=_rserv_slave_tables_.tname);
11 -- Blank out all the tables
13 TRUNCATE foundry_projects ;
15 TRUNCATE stats_project ;
16 TRUNCATE stats_project_developers ;
17 TRUNCATE stats_project_metric ;
18 TRUNCATE frs_dlstats_file_agg ;
19 TRUNCATE stats_subd_pages ;
20 TRUNCATE stats_agg_logo_by_group ;
21 TRUNCATE stats_cvs_group ;
22 TRUNCATE stats_agg_site_by_group ;
23 TRUNCATE stats_site_pages_by_day ;
24 TRUNCATE frs_package ;
25 TRUNCATE frs_release ;
26 TRUNCATE frs_processor ;
27 TRUNCATE frs_filetype ;
31 TRUNCATE project_weekly_metric ;
33 TRUNCATE trove_group_link ;
35 COPY foundry_projects WITH oids from '/home/tperdue/dumpfiles/foundry_projects.dump';
36 COPY stats_site WITH OIDS FROM '/home/tperdue/dumpfiles/stats_site.dump';
37 COPY stats_project WITH OIDS FROM '/home/tperdue/dumpfiles/stats_project.dump';
38 COPY stats_project_developers WITH OIDS FROM '/home/tperdue/dumpfiles/stats_project_developers.dump';
39 COPY stats_project_metric WITH OIDS FROM '/home/tperdue/dumpfiles/stats_project_metric.dump';
40 COPY frs_dlstats_file_agg WITH OIDS FROM '/home/tperdue/dumpfiles/frs_dlstats_file_agg.dump';
41 COPY stats_subd_pages WITH OIDS FROM '/home/tperdue/dumpfiles/stats_subd_pages.dump';
42 COPY stats_agg_logo_by_group WITH OIDS FROM '/home/tperdue/dumpfiles/stats_agg_logo_by_group.dump';
43 COPY stats_cvs_group WITH OIDS FROM '/home/tperdue/dumpfiles/stats_cvs_group.dump';
44 COPY stats_agg_site_by_group WITH OIDS FROM '/home/tperdue/dumpfiles/stats_agg_site_by_group.dump';
45 COPY stats_site_pages_by_day WITH OIDS FROM '/home/tperdue/dumpfiles/stats_site_pages_by_day.dump';
46 COPY frs_package WITH OIDS FROM '/home/tperdue/dumpfiles/frs_package.dump';
47 COPY frs_release WITH OIDS FROM '/home/tperdue/dumpfiles/frs_release.dump';
48 COPY frs_processor WITH OIDS FROM '/home/tperdue/dumpfiles/frs_processor.dump';
49 COPY frs_filetype WITH OIDS FROM '/home/tperdue/dumpfiles/frs_filetype.dump';
50 COPY frs_file WITH OIDS FROM '/home/tperdue/dumpfiles/frs_file.dump';
51 COPY users WITH OIDS FROM '/home/tperdue/dumpfiles/users.dump';
52 COPY groups WITH OIDS FROM '/home/tperdue/dumpfiles/groups.dump';
53 COPY project_weekly_metric WITH OIDS FROM '/home/tperdue/dumpfiles/project_weekly_metric.dump';
54 COPY trove_cat WITH OIDS FROM '/home/tperdue/dumpfiles/trove_cat.dump';
55 COPY trove_group_link WITH OIDS FROM '/home/tperdue/dumpfiles/trove_group_link.dump';
57 DELETE FROM _rserv_slave_sync_;