Thread: Re: [GENERAL]
Thanks for the feedback Richard and Andreas... Ok, I am missing one thing here� my new instance is on a Windows server. How will I import the dump from my old 7.4.7 instance running on Linux, into my new 8.0.1 instance running on Windows 2003? How would you go about feeding a Dump file into a Windows install of postgreSQL 8.0.1? I have been researching for a while here, and I just can�t seem to find any info on this scenario. Thanks in advanced ! Adam Adam O'Toole wrote: Hello. I have an instance of postgreSQL 7.4.7 with one database called dbmedia. We are moving to postgreSQL 8.1 running on windows2003 server. Can I just copy the entire $PGDATA directory to the new 8.1 instance of postgreSQL? I heard that I might run into problems because of the difference in PG versions and server architectures. If this wont work, what would be the best way to get my dbmedia database moved over to the 8.1 instance running on windows? Richard Huxton wrote: Test it first - there might be something different between 7.4 and 8.0 that you're relying on. Read the release notes in 8.0 to find out what might affect you. It's generally easier to dump/restore using a version 8 pg_dump - each version is a bit smarter, and can talk to older servers. Oh - and make sure you're familiar with the Unicode issues on Windows. -- Richard Huxton Archonet Ltd
Adam O'Toole <adamnb1@hotmail.com> schrieb: > Thanks for the feedback Richard and Andreas... > > Ok, I am missing one thing here? my new instance is on a Windows server. > How will I import the dump from my old 7.4.7 instance running on Linux, > into my new 8.0.1 instance running on Windows 2003? How would you go about > feeding a Dump file into a Windows install of postgreSQL 8.0.1? I have been You can do on the windows-machine: pg_dump -h <old_server> | psql I'm not familiar with windows (i hate it), but i think, this should be possible. Complete the calls to pg_dump & psql with the right parameters. If this fails, check if you are able to connect to the remote PG-Server, adapt there the pg_hba.conf - file, if is necessary. http://www.postgresql.org/docs/current/static/client-authentication.html Andreas -- Diese Message wurde erstellt mit freundlicher Unterstützung eines freilau- fenden Pinguins aus artgerechter Freilandhaltung. Er ist garantiert frei von Micro$oft'schen Viren. (#97922 http://counter.li.org) GPG 7F4584DA Was, Sie wissen nicht, wo Kaufbach ist? Hier: N 51.05082°, E 13.56889° ;-)
Thanks, 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 theold 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 thecommand prompt, the pg_restore.exe is found in the Bin directory of the postgreSQL 8 install location. >From:Kretschmer Andreas <andreas_kretschmer@despammed.com>>To: pgsql-novice@postgresql.org>Subject:Re: [NOVICE] [despammed] Re: [GENERAL]>Date: Sun, 14 Aug 2005 13:12:51 +0200>>AdamO'Toole <adamnb1@hotmail.com> schrieb:>> > Thanks for the feedback Richard and Andreas...>>> > Ok, I am missing one thing here? my new instance is on a Windows server.> > How will I import the dump from my old 7.4.7 instance running on Linux,>> into my new 8.0.1 instance running on Windows 2003? How would you go about> > feeding a Dump file intoa Windows install of postgreSQL 8.0.1? I have been>>You can do on the windows-machine:>>pg_dump -h <old_server>| psql>>I'm not familiar with windows (i hate it), but i think, this should be>possible. Completethe calls to pg_dump & psql with the right>parameters.>If this fails, check if you are able to connectto the remote PG-Server,>adapt there the pg_hba.conf - file, if is necessary.>>http://www.postgresql.org/docs/current/static/client-authentication.html>>>Andreas>-->Diese Messagewurde erstellt mit freundlicher Unterstützung eines freilau->fenden Pinguins aus artgerechter Freilandhaltung. Er ist garantiert frei>vonMicro$oft'schen Viren. (#97922 http://counter.li.org) GPG 7F4584DA>Was, Sie wissennicht, wo Kaufbach ist? Hier: N 51.05082°, E 13.56889° ;-)>>---------------------------(end of broadcast)--------------------------->TIP9: In versions below 8.0, the planner will ignore your desire to> choosean index scan if your joining column's datatypes do not> match
Adam O'Toole wrote: > Thanks for the feedback Richard and Andreas... > > Ok, I am missing one thing here� my new instance is on a Windows server. > How will I import the dump from my old 7.4.7 instance running on Linux, > into my new 8.0.1 instance running on Windows 2003? How would you go > about feeding a Dump file into a Windows install of postgreSQL 8.0.1? I > have been researching for a while here, and I just can�t seem to find > any info on this scenario. Exactly as you would for any other platform - pg_restore or psql from a text-dump. All the standard unix applications are still there on Windows. -- Richard Huxton Archonet Ltd