469,269 Members | 1,006 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,269 developers. It's quick & easy.

Option required to dump bytea fields?

Do I need to use the -b option in pg_dump to dump bytea fields? For a while
now I have been routinely using the -b option in pg_dump to back up,
restore, and copy my databases because I thought that this was necessary to
dump bytea fields. I am not using other types of large objects in my
database. Recently, I tried to dump a database with this option and the
dump failed; however I can dump the database without the -b option and my
bytea fields seem to have been dumped properly as well as the rest of the
database.

Thanks in advance for your response.
Nov 23 '05 #1
2 2435
Carlos wrote:
Do I need to use the -b option in pg_dump to dump bytea fields?


No, that is for "large objects", which are completely unrelated to bytea
columns.
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #2
Thanks Peter. This is clarifying the problems that I was having with the
dump.

-----Original Message-----
From: Peter Eisentraut [mailto:pe*****@gmx.net]
Sent: Monday, May 10, 2004 11:20 AM
To: Carlos; 'p************@postgresql.org'
Subject: Re: [GENERAL] Option required to dump bytea fields?

Carlos wrote:
Do I need to use the -b option in pg_dump to dump bytea fields?


No, that is for "large objects", which are completely unrelated to bytea
columns.
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by mPath Records | last post: by
2 posts views Thread by Alvar Freude | last post: by
reply views Thread by Alvar Freude | last post: by
4 posts views Thread by David Garamond | last post: by
6 posts views Thread by Egyd Csaba | last post: by
1 post views Thread by Jerry LeVan | last post: by
1 post views Thread by Jerry LeVan | last post: by
4 posts views Thread by Jerry LeVan | last post: by
4 posts views Thread by Egyd Csaba | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.