[archiver] out of memory

"Jomar Andrade" <[email protected]>
Newsgroups gmane.comp.db.postgresql.devel.win32
Message-ID <001501c4ab44$bc6ca8a0$3900010a@JBAET>
I'm getting this message when trying to restore a 25MB dump. The backup was generated from a postgis database, so it has (smalls, in this case) blobs inside.
Searching in the files, I found a Tom Lane's message suggesting the use of pg_dump -d option in a similar situation because, at that time, there was some issue about the COPY command.
Well, when I use the normal commands <pg_dump -h localhost -U postgres -F t -b -d MAPAS > MAPAS.tar>, the restore operation <pg_restore -d MAPAS MAPAS.tar> shows the message "[archiver] out of memory" almost immediately.
If I use the combination <pg_dump -o -C -b -Ft -i -O -v MAPAS > MAPAS.TAR>, the restore <pg_restore -Ft MAPAS.TAR -d MAPAS> doesn't show the message, but takes hours quietly consuming 99% of my CPU and 30% of my RAM. With no result...
Any tips?

[]s

Jomar
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.