Re: [GENERAL] 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