On Tue, Mar 7, 2017 at 2:02 AM, Panagiotis Atmatzidis <atma(at)convalesco(dot)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.