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