Re: backup compress...blobs/insert commands/verbose

From: Ragnar Hafstað <gnari(at)simnet(dot)is>
To: Zlatko Matic <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>
Cc: Postgresql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: backup compress...blobs/insert commands/verbose
Date: 2005-05-09 23:34:40
Message-ID: 1115681680.24340.9.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

[note: it is better to create a new thread than to hijack an
unrelated one]

On Mon, 2005-05-09 at 18:45 +0200, Zlatko Matic wrote:
> Can someone explain me the following options while using pgAdimn III for
> backup:
>
my guess is...

> blobs
include blobs in backup. blobs are not included
by default (I think)

> insert commands
text file backups create a file containing a series
of SQL commands. data is imported with COPY, which is effective,
but you might prefer a series of INSERT commands, if you want to
keep it more portable between database systems, or need to
import it into old postgresql versions.

gnari

[snip quote of an entire unrelated email]

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2005-05-10 00:14:11 Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
Previous Message Bart Grantham 2005-05-09 23:05:18 Array manipulation/syntax question