pg_dump / pg_restore with Large Objects from 32-bit to 64-bit

From: "Matt Janssen" <matt(at)luggagepros(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: pg_dump / pg_restore with Large Objects from 32-bit to 64-bit
Date: 2010-03-10 16:29:18
Message-ID: 000301cac06e$d54d9f10$7fe8dd30$@com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

When migrating our Postgres databases from 32 to 64-bit systems, including
large binary objects, how well will this work?

32-bit server) pg_dump --format=c --blobs --file=backup.pg mydb

64-bit server) pg_restore -d mydb backup.pg

I'm hoping that PG's compressed custom archive format is not architecture
dependant. Thanks!

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2010-03-11 16:38:05 Re: select (\'*\' ~* \'*\')=true while select (\'*\' ilike \'*\')
Previous Message Kevin Grittner 2010-03-10 15:20:20 Re: pg_switch_xlog