On 4/3/19 8:18 AM, Steven Lembark wrote:
Trying to find a way of moving a large table between databases in the same cluster. There is not sufficient space to copy the contents -- the dedicated tablespace that fits the beastie is on an 80% full disk. Given that the two databases live in the same cluster and have the owner & the tablespace in common, is there any way to move the contents without a dump & reload?
COPY TO STDIN and pipe that through ssh to another server? -- Angular momentum makes the world go 'round.
