| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Migrating plattaform |
| Date: | 2017-11-13 03:48:27 |
| Message-ID: | 7f0d5aee-e7f1-495c-a7ea-142faba6d3ec@hogranch.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | y39chen | 2017-11-13 05:25:10 | PostgreSQL walsender process doesn't exist after "pg_ctl stop -m fast" |
| Previous Message | Tom Lane | 2017-11-13 02:18:58 | Re: Postgres 10.1 fails to start: server did not start in time |