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: [email protected]
> 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
  [email protected]               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings