New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

pg_restore failures #11

Open

qjhart opened this issue Oct 25, 2019 · 1 comment

Labels

doc

Contributor

qjhart commented Oct 25, 2019

If you take the eto_zones.FC and restore it, as in pg_restore -h eto.cp9nvnuhf8ya.us-west-2.rds.amazonaws.com -U postgres --dbname=etz eto_zones.Fc

These are because the databse cannot refresh the materialized views without the javascript for fft being loaded. So you need to do the following.

select fft.require_fft();
REFRESH MATERIALIZED VIEW compare.lt_15day_best_final_zone ;
REFRESH MATERIALIZED VIEW compare.lt_15day_best_zone_in_zones;
REFRESH MATERIALIZED VIEW lt_15day_best_zone_in_zones;
REFRESH MATERIALIZED VIEW avg_0625.lt_15day_best_zone_in_zones ;
REFRESH MATERIALIZED VIEW avg_0625.station_best_zone_in_zones ;
REFRESH MATERIALIZED VIEW compare.station_best_final_zone ;

The text was updated successfully, but these errors were encountered:

qjhart added the doc label

Contributor Author

qjhart commented Oct 25, 2019

@jrmerz Here are the update notes for the ET file.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment