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

Reply via email to