From: | Panagiotis Atmatzidis <atma(at)convalesco(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Copy database to another host without data from specific tables |
Date: | 2017-03-07 07:02:20 |
Message-ID: | EB4E164C-786A-420A-AEA4-264DE8459561@convalesco.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 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:
1) pg_dump the schema from DB1 to DB2 using --no-owner and pg_restore with --role=user2
2) pg_dump -Fc --no-owner --data-only -t 'table1' from DB1 and then restore with pg_restore -t 'table' --role=user2 <table.sql> to DB2
This procedure though is very time consuming (although it could be scripted). Is there any better / faster / safer way to do this?
Thanks.
--
Panagiotis (atmosx) Atmatzidis
email: atma(at)convalesco(dot)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 himself.” - Leo Tolstoy
From | Date | Subject | |
---|---|---|---|
Next Message | Condor | 2017-03-07 07:43:00 | Re: Copy database to another host without data from specific tables |
Previous Message | Günce Kaya | 2017-03-07 04:18:06 | Re: Fwd: parameter type is unknown error |