Re: migration of 100+ tables

2019-03-10 Thread Adrian Klaver
*From:* Adrian Klaver *Sent:* Sunday, March 10, 2019 6:28 PM *To:* Julie Nishimura; pgsql-general@lists.postgresql.org *Subject:* Re: migration of 100+ tables On 3/10/19 5:53 PM, Julie Nishimura wrote: Hello friends, I will need to migrate 500+ tablesĀ  from one server (8.3) to another (9.3)

Re: migration of 100+ tables

2019-03-10 Thread Julie Nishimura
Oh, this is great news! Yay, thanks! From: Adrian Klaver Sent: Sunday, March 10, 2019 6:28 PM To: Julie Nishimura; pgsql-general@lists.postgresql.org Subject: Re: migration of 100+ tables On 3/10/19 5:53 PM, Julie Nishimura wrote: > Hello friends, I will need

Re: migration of 100+ tables

2019-03-10 Thread Adrian Klaver
On 3/10/19 5:53 PM, Julie Nishimura wrote: Hello friends, I will need to migrate 500+ tablesĀ  from one server (8.3) to another (9.3). I cannot dump and load the entire database due to storage limitations (because the source is > 20 TB, and the target is about 1.5 TB). I was thinking about usi

migration of 100+ tables

2019-03-10 Thread Julie Nishimura
Hello friends, I will need to migrate 500+ tables from one server (8.3) to another (9.3). I cannot dump and load the entire database due to storage limitations (because the source is > 20 TB, and the target is about 1.5 TB). I was thinking about using pg_dump with customized -t flag, then use r