Hi all, We have a big database, around 1.2GB, and want to back it up. We used pg_dump with --blobs for large objects. However, the process cannot be completed and threw an error. Can anyone please elaborate on the --blobs, or backing up for large databases? Judging from the description of -b/--blobs we suspect that it has something to do with some fields being text. If anyone has some insight on this help would be much appreciated. Thanks. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match