Thread: [GENERAL] Migrating plattaform
Hello,
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.
regards
valdir
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