| 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]
| 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 |