Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux