RE: Migrating Postgresql from Linux x86

2018-02-11 Thread Clive Anglin
Thanks for the information Clive A. -Original Message- From: Carlos Martinez [mailto:cama...@gmail.com] Sent: Friday, February 9, 2018 10:53 PM To: pgsql-gene...@postgresql.org Cc: Clive Anglin Subject: Re: Migrating Postgresql from Linux x86 Hi. We do that migration from Postgres

Re: Migrating Postgresql from Linux x86

2018-02-09 Thread Carlos Martinez
Hi. We do that migration from Postgres 9.0 (x86_64, Centos 6) to Postgres 9.6 (power, SUSE Enterprise 12). The best way to us was to do a backup (pg_dump -Fc ...) and restore using several cores (pg_restore -j N ..., where N equals to the cores/jobs to be used). How many jobs launch to restore de

Migrating Postgresql from Linux x86

2018-02-09 Thread Clive Anglin
Hi Anyone have migrated PostgreSQL running on Linux x86_64 to running on Linux on Power platform. Interested in a checklist of things to be done and if there is a proper document with the steps to completing would also be of interest. Thanks Clive A.