Postgres Pro
Downloads
Home   >   mailing lists

pg_dump / pg_restore with Large Objects from 32-bit to 64-bit - Mailing list pgsql-admin

From Matt Janssen
Subject pg_dump / pg_restore with Large Objects from 32-bit to 64-bit
Date
Msg-id 000301cac06e$d54d9f10$7fe8dd30$@com
Whole thread Raw
Responses Re: pg_dump / pg_restore with Large Objects from 32-bit to 64-bit
List pgsql-admin
Tree view

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!

pgsql-admin by date:

Previous
From: Scott Whitney
Date:
Subject: Re: Autovac vs manual with analyze
Next
From: seetharaman jayaraman
Date:
Subject: how to get notification in front end application when ever postgre DB table is modified, any tool, jar, api available?