Re: Import from Linux to Windows

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.

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>

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