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.
