No title
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? Using
PG_dump/restore?
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?
Thank you so much,
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?
No. And 8.1 isn't out yet.
Using PG_dump/restore?
Yes
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?
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:
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? Using
No! Don't try it, it is useless and dangerous.
Btw.: actual version is 8.0.3, not 8.1.
PG_dump/restore?
Yes, and use the pg_dump from the 8.0 - Version to dump the old
database.
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
Under Linux/UNIX, from the new machine: (principle)
pg_dump -h <old_server> <options> | psql <options>
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 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� ;-)
<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@despammed.com><BR>>To: pgsql-novice@postgresql.org<BR>>Subject: Re: [NOVICE] [despammed] Re: [GENERAL]<BR>>Date: Sun, 14 Aug 2005 13:12:51 +0200<BR>><BR>>Adam O'Toole <adamnb1@hotmail.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>&gt;<BR>&gt;<BR>&gt;Andreas<BR>&gt;--<BR>&gt;Diese Message wurde erstellt mit freundlicher
Unterst�tzung eines freilau-<BR>>fenden Pinguins aus artgerechter Freilandhaltung. Er ist garantiert frei<BR>>von Micro$oft'schen Viren. (#97922 http://counter.li.org)&nbsp;&nbsp;&nbsp;&nbsp; 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>
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