Tom Lane wrote:
> "Milen A. Radev" <[EMAIL PROTECTED]> writes:
>> ... In the docs for pg_dump for versions after 8.1 the large objects are
Doh, I meant "versions after 8.0" but I believe you understood me.
>> not even mentioned.
>
> Not so: -b came back in 8.2.
That's nice. A change I haven't n
"Milen A. Radev" <[EMAIL PROTECTED]> writes:
> ... In the docs for pg_dump for versions after 8.1 the large objects are
> not even mentioned.
Not so: -b came back in 8.2.
-b
--blobs
Include large objects in the dump. This is the default behavior
except when --schema, --table, or --sche
Lukas napisał(a):
Hello,
we have one table in database (db has over 200 tables), which has one
byteA filed for storing user photos. We are making backup every night, but
it is now too large because of photos. We do not need to make backup of
photos every night, but the question is how to backup
Lukas wrote:
> -b
> --blobs
> Include large objects in dump.
>
> Examples
>
> To dump a database:
> $ pg_dump mydb > db.out
>
> To dump a database called mydb that contains large objects to a tar file:
> $ pg_dump -Ft -b mydb > db.tar
Please read what I've written. This was the case up to
On 09/03/07, Achilleas Mantzios <[EMAIL PROTECTED]> wrote:
[...]
maybe with --format=p (plain text sql) ?
[...]
And to miss all the advantages of the custom format?
--
Milen A. Radev
---(end of broadcast)---
TIP 4: Have you searched our list ar
-b
--blobs
Include large objects in dump.
Examples
To dump a database:
$ pg_dump mydb > db.out
To dump a database called mydb that contains large objects to a tar file:
$ pg_dump -Ft -b mydb > db.tar
> Achilleas Mantzios wrote:
>> Στις Παρασκευή 09 Μάρτιος 2007 15:05, ο/η Milen A.
>> Rad
Achilleas Mantzios wrote:
> Στις Παρασκευή 09 Μάρτιος 2007 15:05, ο/η Milen A. Radev έγραψε:
>> Achilleas Mantzios wrote:
>>> Στις Παρασκευή 09 Μάρτιος 2007 11:00, ο/η Lukas έγραψε:
Hello,
pg_dump can avoid bloob fields (it can dumb without blobs), but as I
understand byteA is
Στις Παρασκευή 09 Μάρτιος 2007 15:05, ο/η Milen A. Radev έγραψε:
> Achilleas Mantzios wrote:
> > Στις Παρασκευή 09 Μάρτιος 2007 11:00, ο/η Lukas έγραψε:
> >> Hello,
> >>
> >> pg_dump can avoid bloob fields (it can dumb without blobs), but as I
> >> understand byteA is not bloob, so in this case wh
Achilleas Mantzios wrote:
> Στις Παρασκευή 09 Μάρτιος 2007 11:00, ο/η Lukas έγραψε:
>> Hello,
>>
>> pg_dump can avoid bloob fields (it can dumb without blobs), but as I
>> understand byteA is not bloob, so in this case what is blob? I did not
>> found such type as blob..
>>
>
> Take a look at
>
Στις Παρασκευή 09 Μάρτιος 2007 11:00, ο/η Lukas έγραψε:
> Hello,
>
> pg_dump can avoid bloob fields (it can dumb without blobs), but as I
> understand byteA is not bloob, so in this case what is blob? I did not
> found such type as blob..
>
Take a look at
http://www.postgresql.org/docs/7.4/inter
Hello,
pg_dump can avoid bloob fields (it can dumb without blobs), but as I
understand byteA is not bloob, so in this case what is blob? I did not
found such type as blob..
Lukas
> Στις Πέμπτη 08 Μάρτιος 2007 22:02, ο/η Lukas
> έγραψε:
>> Hello,
>>
>> we have one table in database (db has ove
Στις Πέμπτη 08 Μάρτιος 2007 22:02, ο/η Lukas έγραψε:
> Hello,
>
> we have one table in database (db has over 200 tables), which has one
> byteA filed for storing user photos. We are making backup every night, but
> it is now too large because of photos. We do not need to make backup of
> photos ev
Hello,
we have one table in database (db has over 200 tables), which has one
byteA filed for storing user photos. We are making backup every night, but
it is now too large because of photos. We do not need to make backup of
photos every night, but the question is how to backup database without
th
13 matches
Mail list logo
