pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ryan Wells <ryan.wells@soapware.com>
To: pgsql-admin@postgresql.org
Subject: Error restoring after 8.3 upgrade
Date: Mon, 3 Mar 2008 14:22:36 -0600
Message-ID: <52F2AD70C422474B857FC9E3F7B62539027C886A@exchange.DOCS.COM> (raw)

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




Message-ID: <52F2AD70C422474B857FC9E3F7B62539027C886A@exchange.DOCS.COM>
Permalink:  ../52F2AD70C422474B857FC9E3F7B62539027C886A@exchange.DOCS.COM/
Also on:    postgresql.org/message-id/52F2AD70C422474B857FC9E3F7B62539027C886A@exchange.DOCS.COM

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: ryan.wells@soapware.com
  Subject: Re: Error restoring after 8.3 upgrade
  In-Reply-To: <52F2AD70C422474B857FC9E3F7B62539027C886A@exchange.DOCS.COM>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox