I have created a (spatial) database at my home which is several gigabytes and I want to move the whole database as it is from one computer my works computer.
Nothing fansy, I will create a new postgresql/postgis db instance at my work computer. The db users may or maynot have the same name in both computers.
Is it possible? What should i be carefull about? How can i do it pain free?
I'm using postgresql v9.1.5 with postgis extension. Ubuntu12.04 (kernel 3.2.0-31)