Re: Does pg_dumpall do BLOBs too?

From: Daniel Lundin <daniel(at)helena-daniel(dot)se>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Does pg_dumpall do BLOBs too?
Date: 2002-01-12 10:37:36
Message-ID: 20020112103736.GE1003@shire
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

On Fri, Jan 11, 2002 at 07:38:01PM +0100, Frank Joerdens wrote:
> The man page for pg_dumpall does not mention anything about BLOBs,
> whereas the man page for pg_dump does. Does that mean you can't dump out
> everything at once if you have databases with BLOBs on your server? (I
> need to dump and reload everything cuz my new app wants a NAMEDATALEN of
> 64).
>
As I understand it, pg_dumpall calls pg_dump, so if pg_dump backups blobs, so
would pg_dumpall.

Safest way of finding out whether your data is backed up safely or not is
trying to restore after a backup. Never trust any backup scheme without trying
it.

> Regards, Frank
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Samuel 2002-01-12 10:40:11 Re: again, LIKE operator
Previous Message Lenny Silver 2002-01-12 06:31:16 Re: problem making postgresql

Browse pgsql-jdbc by date

  From Date Subject
Next Message Frank Joerdens 2002-01-12 15:42:31 Re: Does pg_dumpall do BLOBs too?
Previous Message Tom Lane 2002-01-12 04:40:47 Re: JDBC patch for DatabaseMetaData