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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general