Database table archiving
You will need to create a foreign table in the Linux server that points to the Postgres running on the Windows server. 

Then you can move the rows with an INSERT and a DELETE statement

insert into archive_table (col1, col2, col3)
select c1, c2, c3
from local_table
where created_at_column &lt;= current_date - 42;: -- rows older than 42 days

delete from local_table
where created_at_column &lt;= current_date - 42;


Where archive_table is the foreign table that "points"  to the Windows server.

The DELETE will probably be quite slow (the more rows you archive, the slower it will be), a faster way would be to partition the table e.g. by month and then detach old partitions from the table.