4 -- reloid's get lost during dump/restore - reset them
10 WHERE relname=_rserv_tables_.tname);
13 -- Purge pending sync logs
15 DELETE FROM _rserv_log_;
16 DELETE FROM _rserv_sync_;
19 -- Get a dump of all tables inside a transaction to guarantee integrity
21 COPY stats_site WITH OIDS TO '/home/tperdue/dumpfiles/stats_site.dump';
22 COPY stats_project WITH OIDS TO '/home/tperdue/dumpfiles/stats_project.dump';
23 COPY stats_project_developers WITH OIDS TO '/home/tperdue/dumpfiles/stats_project_developers.dump';
24 COPY stats_project_metric WITH OIDS TO '/home/tperdue/dumpfiles/stats_project_metric.dump';
25 COPY frs_dlstats_file_agg WITH OIDS TO '/home/tperdue/dumpfiles/frs_dlstats_file_agg.dump';
26 COPY stats_subd_pages WITH OIDS TO '/home/tperdue/dumpfiles/stats_subd_pages.dump';
27 COPY stats_agg_logo_by_group WITH OIDS TO '/home/tperdue/dumpfiles/stats_agg_logo_by_group.dump';
28 COPY stats_cvs_group WITH OIDS TO '/home/tperdue/dumpfiles/stats_cvs_group.dump';
29 COPY stats_agg_site_by_group WITH OIDS TO '/home/tperdue/dumpfiles/stats_agg_site_by_group.dump';
30 COPY stats_site_pages_by_day WITH OIDS TO '/home/tperdue/dumpfiles/stats_site_pages_by_day.dump';
31 COPY frs_package WITH OIDS TO '/home/tperdue/dumpfiles/frs_package.dump';
32 COPY frs_release WITH OIDS TO '/home/tperdue/dumpfiles/frs_release.dump';
33 COPY frs_processor WITH OIDS TO '/home/tperdue/dumpfiles/frs_processor.dump';
34 COPY frs_filetype WITH OIDS TO '/home/tperdue/dumpfiles/frs_filetype.dump';
35 COPY frs_file WITH OIDS TO '/home/tperdue/dumpfiles/frs_file.dump';
36 COPY project_weekly_metric WITH OIDS TO '/home/tperdue/dumpfiles/project_weekly_metric.dump';
37 COPY trove_cat WITH OIDS TO '/home/tperdue/dumpfiles/trove_cat.dump';
38 COPY trove_group_link WITH OIDS TO '/home/tperdue/dumpfiles/trove_group_link.dump';
39 COPY users WITH OIDS TO '/home/tperdue/dumpfiles/users.dump';
40 COPY groups WITH OIDS TO '/home/tperdue/dumpfiles/groups.dump';
41 COPY foundry_projects WITH oids to '/home/tperdue/dumpfiles/foundry_projects.dump';