Hot answers tagged server
Command-line dump straight into psql is the best bet pg_dump -h host1 -t yourtable database1 | psql -d database2 -h host2 The line in the middle is a pipe, it takes the output from the first command and provides it as input to the second.
I thought I would add a late answer here to expand upon my comments from last year. After re-reading this, I thought of a few good examples of sites that I know of that would be beneficial as examples to anyone viewing this question. The City of Hudson, Ohio has an interesting GIS website. They incorporate city work orders, city layers, community info, ...
Just start playing! Get yourself a virtual server (Windows or Linux, whatever you're comfortable with), and install the OpenGeoSuite. I run a small production server with around 2 GB of ram and two processors and it works fine. As John Barca says, you can scale up to very big, with load balancing and separate, redundant database servers. But to start ...
There are multiple meanings of "cluster", and I fear you may be confusing them... In ArcGIS Server 10.1+ parlance, a "cluster" is a bound subset of servers within an ArcGIS Server site. The documentation contains this image, which shows how a subset of servers can be allocated to one aspect of GIS services. In this diagram there are three (3) hosts ...
Yes you can for example use the WMS-Layer from your QGIS-Server in ol3: http://jsfiddle.net/expedio/0woc6xL3/
There are packages created for MacOS, usually by KingChaos. Looks like you can also use homebrew: http://www.kyngchaos.com/software/postgres http://brew.sh/ As usual, the best way is to look at the docs, as already said by John, check this link: http://postgis.net/install
Only top voted, non community-wiki answers of a minimum length are eligible