<html><div style='background-color:'><DIV class=RTE>
<P>Thanks,</P>
<P>I got it working now. I was able to do it two ways. To do just a PG_dump of a database you can use PGAdmin to backup the old one, and use PGAdmin again to restore it on the windows install. If you want to get the users and groups as well, then use the PG_dumpall to get the dump file, and as you said, you can restore it on the windows instance using the command prompt, the pg_restore.exe is found in the Bin directory of the postgreSQL 8 install location. <BR><BR></P><BR><BR><BR>>From: Kretschmer Andreas <andreas_kretschmer(at)despammed(dot)com><BR>>To: pgsql-novice(at)postgresql(dot)org<BR>>Subject: Re: [NOVICE] [despammed] Re: [GENERAL]<BR>>Date: Sun, 14 Aug 2005 13:12:51 +0200<BR>><BR>>Adam O'Toole <adamnb1(at)hotmail(dot)com> schrieb:<BR>><BR>> > Thanks for the feedback Richard and Andreas...<BR>> ><BR>> > Ok, I am missing one thing here? my
new instance is on a Windows server.<BR>> > How will I import the dump from my old 7.4.7 instance running on Linux,<BR>> > into my new 8.0.1 instance running on Windows 2003? How would you go about<BR>> > feeding a Dump file into a Windows install of postgreSQL 8.0.1? I have been<BR>><BR>>You can do on the windows-machine:<BR>><BR>>pg_dump -h <old_server> | psql<BR>><BR>>I'm not familiar with windows (i hate it), but i think, this should be<BR>>possible. Complete the calls to pg_dump & psql with the right<BR>>parameters.<BR>>If this fails, check if you are able to connect to the remote PG-Server,<BR>>adapt there the pg_hba.conf - file, if is necessary.<BR>><BR>>http://www.postgresql.org/docs/current/static/client-authentication.html<BR>><BR>><BR>>Andreas<BR>>--<BR>>Diese Message wurde erstellt mit freundlicher
Untersttzung eines freilau-<BR>>fenden Pinguins aus artgerechter Freilandhaltung. Er ist garantiert frei<BR>>von Micro$oft'schen Viren. (#97922 http://counter.li.org) GPG 7F4584DA<BR>>Was, Sie wissen nicht, wo Kaufbach ist? Hier: N 51.05082, E 13.56889 ;-)<BR>><BR>>---------------------------(end of broadcast)---------------------------<BR>>TIP 9: In versions below 8.0, the planner will ignore your desire to<BR>> choose an index scan if your joining column's datatypes do not<BR>> match<BR></DIV></div></html>