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
[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
Re: [GENERAL] Migrating plattaform
You should use pg_dump & pg_restore because datafiles of differents on architectures are incompatibles. El 9 nov. 2017 16:47, "Valdir Kageyama"escribió: > 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 > > Tikara >
[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 Tikara