On Tue, Mar 7, 2017 at 2:02 AM, Panagiotis Atmatzidis <atma@convalesco.org> wrote:
I want to make a clone of database1 which belongs to user1, to database2 which belongs to user2. Database1 has 20+ tables. I want to avoid copying the DATA sitting on 5 tables on database1 (many Gigs).
I've read one too many posts about how to perform the actions with "pg_dump" and "pg_restore" but I'm trying to figure out the easiest way to do this. The process I have in mind is this:
Your method will break down if you have FKs and you're not careful with the order you copy your data.
pg_dump has an --exclude-table flag which I would suggest. Just apply it multiple times to exclude your 5 tables.
