I have postgresql data [7.4.3] which has the size of more than 5 Gb. and also contains blob for reporting. I use the command pg_restore -d test test.tar
test.tar = 5.5 Gb. after I try to restore it in another server which has the same environment and use the command pg_restore -d test test.tar The database "test" after restoration has the same data but no blob found . What's wrong with my command? Amrit Thailand ---------------------------------------------------------------------------------- http://www.chaiyo.com äªâÂàÁÅì - ¿ÃÕÍÕàÁÅìÃٻẺãËÁè Ê´ãÊ¡ÇèÒà´ÔÁ... ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
