Skip site navigation (1) Skip section navigation (2)

Re: Import from Linux to Windows

From: "Tom Haddon" <thaddon(at)equilar(dot)com>
To: "Andrew Dunstan" <andrew(at)dunslane(dot)net>
Cc: <pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Re: Import from Linux to Windows
Date: 2004-08-11 21:00:56
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers-win32
I don't think so. Did a search for it in vi and nothing. It doesn't give
me an error, just exits. Last statement is "CREATE TABLE". 

Sorry, not very helpful...

Thanks, Tom

-----Original Message-----
From: Andrew Dunstan [mailto:andrew(at)dunslane(dot)net] 
Sent: Wednesday, August 11, 2004 1:44 PM
To: Tom Haddon
Cc: pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: [pgsql-hackers-win32] Import from Linux to Windows

Tom Haddon wrote:

>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?

What is the error? You don't by any chance have a ^Z somewhere in the 
file, do you?




pgsql-hackers-win32 by date

Next:From: Tom LaneDate: 2004-08-11 23:35:17
Subject: Re: error moving table to tablespace (8.0 beta win32 )
Previous:From: Andrew DunstanDate: 2004-08-11 20:44:15
Subject: Re: Import from Linux to Windows

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group