Re: Import from Linux to Windows

Claudio Natoli wrote:
>
> Hi there,
>
> have a vague recollection of a sysadmin here coming to me with a similar
> issue. Suggested he try unix2dos and retry the import.
>
> Don't know if it is a generic fix, but it got him through.

That is not required in 7.4 and later releases.

---------------------------------------------------------------------------

>
> Cheers,
> Claudio
>
>
> -----Original Message-----
> From: Tom Haddon
> To: pgsql-hackers-win32(at)postgresql(dot)org
> Sent: 8/12/04 5:09 AM
> Subject: [pgsql-hackers-win32] Import from Linux to Windows
>
> Hi,
>
> I have a dump file created using pg_dumpall on Linux that I'm trying to
> import into Windows. I know this dump file is good as I've tested it and
> looked at it. When I run it against the Windows version (8.0.0beta1)
> from within psql with the \i switch, it loads in the structure of the
> first database in the dump, and creates all the databases and users, but
> doesn't populate the data of the first database, and doesn't create the
> structure of all the other databases.
>
> My guess is this is a Windows formatting issue. Do I just need to do a
> search and replace on \n or \t and replace it with something?
>
> Thanks, Tom
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
> ---
> Certain disclaimers and policies apply to all email sent from Memetrics.
> For the full text of these disclaimers and policies see
> <a
> href="http://www.memetrics.com/emailpolicy.html">http://www.memetrics.com/em
> ailpolicy.html</a>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073