Hot answers tagged database
If you are logging that type of data 1/second speed is a non-issue. Write intensity? No your situation doesn't qualify. The weather data you suggest is less than 128 bytes per second, it is laughably low, basically none. The cells won't wear out as much because your just using new cells, and not re-writing old cells. Writing 1 10mb photo will be more ...
pg_dump -Fc each database, and pg_dumpall --globals-only the users, etc. Run the dumpall script through psql to restore it. Then pg_restore each individual database dump.
Only top voted, non community-wiki answers of a minimum length are eligible