Move vs. copy table between databases that share a tablespace?

From: Steven Lembark <lembark(at)wrkhors(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Cc: lembark(at)wrkhors(dot)com
Subject: Move vs. copy table between databases that share a tablespace?
Date: 2019-04-03 13:18:25
Message-ID: 20190403081825.14dc71c9.lembark@wrkhors.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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?

Thanks

--
Steven Lembark 3920 10th Ave South
Workhorse Computing Birmingham, AL 35222
lembark(at)wrkhors(dot)com +1 888 359 3508

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Atkins 2019-04-03 13:29:00 Re: SQL queries not matching on certain fields
Previous Message Felix Ableitner 2019-04-03 13:06:03 SQL queries not matching on certain fields