From: | Adam Radłowski <adamr(at)informatyka(dot)gdansk(dot)pl> |
---|---|
To: | Jessica Richard <rjessil(at)yahoo(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Problem restoring with pg_dump |
Date: | 2006-11-28 23:48:56 |
Message-ID: | 456CCAE8.30303@informatyka.gdansk.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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 <adamr(at)informatyka(dot)gdansk(dot)pl>/* 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(at)postgresql(dot)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
> <http://us.rd.yahoo.com/evt=43257/*http://advision.webevents.yahoo.com/mailbeta>
> - Fire up a more powerful email and get things done faster.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-11-29 04:08:36 | Re: Problem restoring with pg_dump |
Previous Message | Peter Wilson | 2006-11-28 23:31:24 | Re: Problem restoring with pg_dump |