Обсуждение: Error restoring after 8.3 upgrade

Поиск
Список
Период
Сортировка

Error restoring after 8.3 upgrade

От
"Ryan Wells"
Дата:
We have a database that we're upgrading from 8.2 to 8.3.  Our basic
prodecure is to make a backup of the data using pgAdmin, remove 8.2,
install 8.3, then use pgAdmin to restore the data.  That works fine on
our test system, but on the actual server we get the following error
during the restore:

pg_restore: [archiver (db)] error returned by PQputCopyData: could not
send data to server: No buffer space available (0x00002747/10055)
pg_restore: *** aborted because of error

Our support staff says the server OS is Windows Server 2003, but they
don't have the other machine specs documented.  I'm trying to get those
details.

Google turned up a few discussions of similar errors that may be
related, but no certain fixes:
http://archives.postgresql.org/pgsql-general/2006-01/msg00769.php
http://archives.postgresql.org/pgsql-bugs/2006-07/msg00051.php
http://archives.postgresql.org/pgsql-bugs/2006-04/msg00260.php
http://archives.postgresql.org/pgsql-general/2006-01/msg00328.php
http://www.webservertalk.com/archive307-2007-3-1832662.html
http://osdir.com/ml/db.postgresql.ports/2005-11/msg00000.html
http://www.mail-archive.com/pgsql-bugs@postgresql.org/msg15449.html

We've tried adjusting the buffer sizes in postgresql.conf and the
Windows registry tweak that one site suggested, but neither of those
made any apparent difference.

Naturally I'm hoping this is a common, well-known issue with an easy
fix, but of course I don't expect that to be the case. :-)

Thanks,
Ryan