On Tue, Mar 7, 2017 at 2:02 AM, Panagiotis Atmatzidis <a...@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.
