On 6/9/19 11:36 PM, Pawan Sharma wrote:
Hello All.
What is the best way to upgrade from PostgreSQL 9.6 to PostgreSQL 11
instead of pg_upgrade.
- Less downtime.
- Approx database size are 1-3TB.
If you really don't want to do pg_upgrade, then a possibility is
multi-threaded pg_dump using d
On 10/6/19 9:52 π.μ., Pawan Sharma wrote:
Thanks all,
Is pg_upgrade is the best method if I am doing upgrade on same server or
different server.
Same server means: source and Target on same server
Different: source and Target are different server.
A traditional upgrade by definition is on th
Thanks all,
Is pg_upgrade is the best method if I am doing upgrade on same server or
different server.
Same server means: source and Target on same server
Different: source and Target are different server.
On Mon, Jun 10, 2019, 12:07 PM Michael Paquier wrote:
> On Mon, Jun 10, 2019 at 09:00:
On Mon, Jun 10, 2019 at 09:00:38AM +0300, Achilleas Mantzios wrote:
> On 10/6/19 7:36 π.μ., Pawan Sharma wrote:
>> What is the best way to upgrade from PostgreSQL 9.6 to PostgreSQL
>> 11 instead of pg_upgrade.
>
> why not pg_upgrade ? If the size is near the 3TB mark as you say,
> pg_upgrade is the
On 10/6/19 7:36 π.μ., Pawan Sharma wrote:
Hello All.
What is the best way to upgrade from PostgreSQL 9.6 to PostgreSQL 11 instead of
pg_upgrade.
why not pg_upgrade ? If the size is near the 3TB mark as you say, pg_upgrade is
the fastest IMHO.
- Less downtime.
- Approx database size are 1-3
Hello All.
What is the best way to upgrade from PostgreSQL 9.6 to PostgreSQL 11
instead of pg_upgrade.
- Less downtime.
- Approx database size are 1-3TB.
Thanks for your help..!!!
Regards,
Pawan