Migrating plattaform

On 11/8/2017 11:38 AM, Valdir Kageyama wrote:

I need migrated the postgres from Linux on IBM Power to Oracle Linux
on SPARC.

My doubt is possible copy the datafiles to new enviorement ? or I need
using  other means of copying the data.
For exemples: pg_dump/pg_restore.

pretty sure you can't copy binary database files between architectures,
as various data structures have different binary representations.

sure, pg_dump  -Fc | pg_restore, that works fine across architectures.

--
john r pierce, recycling bits in santa cruz

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general