Import from Linux to Windows

"Tom Haddon" <[email protected]>
Newsgroups gmane.comp.db.postgresql.devel.win32
Message-ID <[email protected]>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.