From: | "Obe, Regina DND\\MIS" <robe(dot)dnd(at)cityofboston(dot)gov> |
---|---|
To: | "Federico Simonetti (Etheye)" <flame(at)etheye(dot)com> |
Cc: | pgsql-hackers-win32(at)postgresql(dot)org |
Subject: | Re: R: R: How to move a DB from one server |
Date: | 2005-06-23 12:39:49 |
Message-ID: | B318FD8D29DCD411BD0500D0B7A91C670410406D@jupiter |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers-win32 |
Just a thought. When you are restoring, are you restoring using the same
encoding as the database you dumped. I recall having similar problems and
it was because my dumped database was in SQL ASCII and I had mistakenly
created my new database using UNICODE.
Also I think I had an issue if I was using a pg_restore older than the
version that came with the pg version I used dump.
-----Original Message-----
From: Jochem van Dieten [mailto:jochemd(at)oli(dot)tudelft(dot)nl]
Sent: Thursday, June 23, 2005 8:25 AM
To: Federico Simonetti (Etheye)
Cc: pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: R: R: [pgsql-hackers-win32] How to move a DB from one server
Federico Simonetti (Etheye) wrote:
>
> uhm, you may have lost my first message... I said that I am unable to
> run pg_restore on a different computer other than the one pg_dump was
> used on. I always get a return code of 1 (error). I can easily and
> quickly dump a database with pg_dump but I can't restore it on a PC
> different from the one used to back it up. And I really can't understand
> why, I have tried all possible options...
If you can not restore a dump, you are either doing something
wrong or you have discovered a bug:
http://www.postgresql.org/docs/8.0/interactive/bug-reporting.html
Jochem
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-06-23 14:34:17 | Re: R: How to move a DB from one server to another... |
Previous Message | Jochem van Dieten | 2005-06-23 12:24:59 | Re: R: R: How to move a DB from one server |