I have a local PSQL server that is recording data on a solid state drive (32 GB )of less than 8 GB as free on a WIn 7 embedded 32 bit machine. In order to make a backup and store large data I need to setup a procedure to move my data at intervals predefine to a remote psql server. I need to create a procedure to connect>copy data to remote>confirm the copy> delete local> and then wait for next hour. Can someone guide me with the procedure, I am new to DB and server management. So would appreciate a simple steps to achieve this.

Bother server are psql. and same table structures