Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 34E639FB28D for ; Tue, 28 Nov 2006 19:50:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 24457-07 for ; Tue, 28 Nov 2006 19:50:23 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from ns1.peker.com.pl (181-ego-2.acn.waw.pl [62.121.85.181]) by postgresql.org (Postfix) with SMTP id BC0139FB28A for ; Tue, 28 Nov 2006 19:50:21 -0400 (AST) Received: (qmail 27834 invoked by uid 540); 28 Nov 2006 23:40:37 -0000 Received: from 83.143.210.69 by ns1.peker.com.pl (envelope-from , uid 401) with qmail-scanner-1.25st (clamdscan: 0.82/760. spamassassin: 3.0.2. perlscan: 1.25st. Clear:RC:0(83.143.210.69):SA:0(-2.6/8.0):. Processed in 6.38464 secs); 28 Nov 2006 23:40:37 -0000 Received: from host69-83-143-210.limes.com.pl (HELO ?10.0.1.69?) (informatyka-adamr@83.143.210.69) by ns1.peker.com.pl with SMTP; 28 Nov 2006 23:40:30 -0000 Message-ID: <456CCAE8.30303@informatyka.gdansk.pl> Date: Wed, 29 Nov 2006 00:48:56 +0100 From: =?ISO-8859-2?Q?Adam_Rad=B3owski?= User-Agent: Thunderbird 1.5.0.7 (X11/20060909) MIME-Version: 1.0 To: Jessica Richard CC: pgsql-admin@postgresql.org Subject: Re: Problem restoring with pg_dump References: <20061128133843.36651.qmail@web58315.mail.re3.yahoo.com> In-Reply-To: <20061128133843.36651.qmail@web58315.mail.re3.yahoo.com> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/232 X-Sequence-Number: 23759 I'm sorry, but I have experiences only with LATNI2 and WIN1250 databases on PostgreSQL 8.0.3, 8.0.6, 8.0.7, 8.1.3 . I'm afraid, that without having Your SQL script file Your problem can be difficult to resolve. Adam Jessica Richard wrote: > can you please be more specific? > > I used pg_dump db to dump the 8.0.8 unicode db, and used > psql db < dbdump to load the db to 8.1.4 server (on this version unicode > becomes utf8) and got the error: > > ERROR: invalid byte sequence for encoding "UTF8": 0x92 > > thanks > > */Adam Radlowski /* wrote: > > I had problems, like that. I've omitted them using "plain" format (SQL > script file) of dump file. I restore data from "plain" format with psql > - using command "\i FILE". It work always. If You gzip this "plain" > file > - You become simillar volume of file using binary dump format. > Greetings > Adam > > Peter Wilson wrote: > > >I posted this to 'general' yesterday but with no luck. This is > probably a better > >group. > > > >I've just got the following message while trying to restore a > database : > > > >pg_restore : [custom archiver] Dumping a specific TOC data block > out of order is > >not supported without ID on this input stream (fseek required). > > > >The command was : > >pg_restore -L /tmp/toc --dbname=whitebeam --disable-triggers > --username=postgres > >/var/backups/restore-db.psql > > > >/tmp/toc is a re-orderd output from : > > > >pg_restore -l -a /var/backups/restore-db.psql > /tmp/toc > > > >Using Postgres 8.1.4 on > >Linux version 2.6.15-1.2054_FC5 > > > >The dump itself was made on another machine running 8.1.4 on > Fedora core 4. > > > >I've run similar commands on this machine before with no problems. > Not sure why > >I should start to have these problems now? > > > >Anyone else seen anything similar? Thoughts much appreciated! > > > >Pete > > > >---------------------------(end of > broadcast)--------------------------- > >TIP 1: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to majordomo@postgresql.org so that your > > message can get through to the mailing list cleanly > > > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > > > ------------------------------------------------------------------------ > Check out the all-new Yahoo! Mail beta > > - Fire up a more powerful email and get things done faster.