[GENERAL] Copy database to another host without data from specific tables

2017-03-06 Thread Panagiotis Atmatzidis
Hello, I have 2 RDS instances on AWS running PSQL 9.4.7. 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

Re: [GENERAL] Copy database to another host without data from specific tables

2017-03-09 Thread Panagiotis Atmatzidis
Thanks for the replies, pg_dump —exclude-table will do for now. Panagiotis (atmosx) Atmatzidis email: a...@convalesco.org URL:http://www.convalesco.org GnuPG ID: 0x1A7BFEC5 gpg --keyserver pgp.mit.edu --recv-keys 1A7BFEC5 "Everyone thinks of changing the world, but no one thinks of changing