pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUpgrade/Installation problem: Version 7.4.9 to version 8.1.3
13+ messages / 4 participants
[nested] [flat]
* Upgrade/Installation problem: Version 7.4.9 to version 8.1.3
@ 2007-01-17 18:47 Andrew Edson <cheighlund@yahoo.com>
2007-01-17 18:58 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Jeff Frost <jeff@frostconsultingllc.com>
0 siblings, 1 reply; 13+ messages in thread
From: Andrew Edson @ 2007-01-17 18:47 UTC (permalink / raw)
To: pgsql-admin
I was requested to load data (a full copy of the db in question) from one postgres database into another (empty) db on another system. Both of these systems are running SuSE 9.2 Linux, for the record. It turned out that the two systems were running different versions of postgres; the first system (the one that needed the data) was running version 7.4.9, while the other system was (and is) running 8.1.3. I copied the 8.1.3 installation packet over to the first computer, and tried to install it.
Originally, when starting the (supposed) 8.1.3 pg_ctl, I got an error about tcpip_socket. A search on the postgres site lead me to believe I could remedy the problem by uninstalling the older version of postgres. I proceded in the following order: swap to the installation directory for 8.1.3, make uninstall, make distclean, swap to the 7.4.9 installation directory, make uninstall, make distclean, swap back to 8.1.3, configure, make, make install. I still got the error, though. I finally found it mentioned in the postgres.conf file, and commented out the line. Next, I was told that my data files were initialized in 7.4, despite my earlier efforts, and after renaming the old folder, I went back and repeated the steps of (8.1.3)make uninstall, make distclean, configure, make, make install. However, there is no data directory in the base postgres directory now, only the older renamed one.
If anyone can tell me what to do to get this system back up and running, I would appreciate it greatly. If more information is needed, I will be happy to supply as much as I can.
Thank you for your consideration.
---------------------------------
Access over 1 million songs - Yahoo! Music Unlimited.
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Upgrade/Installation problem: Version 7.4.9 to version
2007-01-17 18:47 Upgrade/Installation problem: Version 7.4.9 to version 8.1.3 Andrew Edson <cheighlund@yahoo.com>
@ 2007-01-17 18:58 ` Jeff Frost <jeff@frostconsultingllc.com>
2007-01-17 20:41 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Andrew Edson <cheighlund@yahoo.com>
0 siblings, 1 reply; 13+ messages in thread
From: Jeff Frost @ 2007-01-17 18:58 UTC (permalink / raw)
To: Andrew Edson <cheighlund@yahoo.com>; +Cc: pgsql-admin
Andrew,
If you're moving between major versions, a dump/restore is necessary. The
proper procedure is:
1) pg_dump the old database by using the new version of pg_dump (8.1.x)
against the old db server (7.4.9 in your case)
2) stop the old database server (and possibly move/rename the old data dir)
3) initdb the new database server
4) edit postgresql.conf, etc
5) start the new database server
6) pg_restore the old database into the newly initialized data directory
So, it sounds like you'll need to reinstall 7.4 and bring it back up, then use
the 8.1.3 pg_dump to create a dump, then restore that into the new 8.1 server.
On Wed, 17 Jan 2007, Andrew Edson wrote:
> I was requested to load data (a full copy of the db in question) from one postgres database into another (empty) db on another system. Both of these systems are running SuSE 9.2 Linux, for the record. It turned out that the two systems were running different versions of postgres; the first system (the one that needed the data) was running version 7.4.9, while the other system was (and is) running 8.1.3. I copied the 8.1.3 installation packet over to the first computer, and tried to install it.
>
> Originally, when starting the (supposed) 8.1.3 pg_ctl, I got an error about tcpip_socket. A search on the postgres site lead me to believe I could remedy the problem by uninstalling the older version of postgres. I proceded in the following order: swap to the installation directory for 8.1.3, make uninstall, make distclean, swap to the 7.4.9 installation directory, make uninstall, make distclean, swap back to 8.1.3, configure, make, make install. I still got the error, though. I finally found it mentioned in the postgres.conf file, and commented out the line. Next, I was told that my data files were initialized in 7.4, despite my earlier efforts, and after renaming the old folder, I went back and repeated the steps of (8.1.3)make uninstall, make distclean, configure, make, make install. However, there is no data directory in the base postgres directory now, only the older renamed one.
>
> If anyone can tell me what to do to get this system back up and running, I would appreciate it greatly. If more information is needed, I will be happy to supply as much as I can.
>
> Thank you for your consideration.
>
>
> ---------------------------------
> Access over 1 million songs - Yahoo! Music Unlimited.
--
Jeff Frost, Owner <jeff@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Upgrade/Installation problem: Version 7.4.9 to version
2007-01-17 18:47 Upgrade/Installation problem: Version 7.4.9 to version 8.1.3 Andrew Edson <cheighlund@yahoo.com>
2007-01-17 18:58 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Jeff Frost <jeff@frostconsultingllc.com>
@ 2007-01-17 20:41 ` Andrew Edson <cheighlund@yahoo.com>
2007-01-17 20:45 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Jeff Frost <jeff@frostconsultingllc.com>
2007-01-17 21:12 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Ray Stell <stellr@cns.vt.edu>
0 siblings, 2 replies; 13+ messages in thread
From: Andrew Edson @ 2007-01-17 20:41 UTC (permalink / raw)
To: Jeff Frost <jeff@frostconsultingllc.com>; +Cc: pgsql-admin
Please clear something up for me. The database I'm trying to upgrade was/is empty; only the original installation was present, no tables. Exactly what is it I'm supposed to be dumping? If you mean making a copy of the original 8.1.3, that I've done before, but I'm unclear as to the meaning of what you're saying at the moment. Please enlighten me.
Jeff Frost <jeff@frostconsultingllc.com> wrote: Andrew,
If you're moving between major versions, a dump/restore is necessary. The
proper procedure is:
1) pg_dump the old database by using the new version of pg_dump (8.1.x)
against the old db server (7.4.9 in your case)
2) stop the old database server (and possibly move/rename the old data dir)
3) initdb the new database server
4) edit postgresql.conf, etc
5) start the new database server
6) pg_restore the old database into the newly initialized data directory
So, it sounds like you'll need to reinstall 7.4 and bring it back up, then use
the 8.1.3 pg_dump to create a dump, then restore that into the new 8.1 server.
---------------------------------
It's here! Your new message!
Get new email alerts with the free Yahoo! Toolbar.
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Upgrade/Installation problem: Version 7.4.9 to version
2007-01-17 18:47 Upgrade/Installation problem: Version 7.4.9 to version 8.1.3 Andrew Edson <cheighlund@yahoo.com>
2007-01-17 18:58 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Jeff Frost <jeff@frostconsultingllc.com>
2007-01-17 20:41 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Andrew Edson <cheighlund@yahoo.com>
@ 2007-01-17 20:45 ` Jeff Frost <jeff@frostconsultingllc.com>
2007-01-17 20:48 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Jeff Frost <jeff@frostconsultingllc.com>
1 sibling, 1 reply; 13+ messages in thread
From: Jeff Frost @ 2007-01-17 20:45 UTC (permalink / raw)
To: Andrew Edson <cheighlund@yahoo.com>; +Cc: pgsql-admin
You have to dump the original 7.4.9 version of the database and restore that
into the 8.1.3 database server.
An example:
I have a server db1 which is running pg 7.4.9
I have a server db2 which is to replace db1 running pg 8.1.3
I would likely just do something like this from db2 (assuming no clients are
writing to db1 while this is happening):
pg_dumpall -h db1 | psql -h db2
On Wed, 17 Jan 2007, Andrew Edson wrote:
> Please clear something up for me. The database I'm trying to upgrade was/is empty; only the original installation was present, no tables. Exactly what is it I'm supposed to be dumping? If you mean making a copy of the original 8.1.3, that I've done before, but I'm unclear as to the meaning of what you're saying at the moment. Please enlighten me.
>
> Jeff Frost <jeff@frostconsultingllc.com> wrote: Andrew,
>
> If you're moving between major versions, a dump/restore is necessary. The
> proper procedure is:
>
> 1) pg_dump the old database by using the new version of pg_dump (8.1.x)
> against the old db server (7.4.9 in your case)
> 2) stop the old database server (and possibly move/rename the old data dir)
> 3) initdb the new database server
> 4) edit postgresql.conf, etc
> 5) start the new database server
> 6) pg_restore the old database into the newly initialized data directory
>
> So, it sounds like you'll need to reinstall 7.4 and bring it back up, then use
> the 8.1.3 pg_dump to create a dump, then restore that into the new 8.1 server.
>
>
> ---------------------------------
> It's here! Your new message!
> Get new email alerts with the free Yahoo! Toolbar.
--
Jeff Frost, Owner <jeff@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Upgrade/Installation problem: Version 7.4.9 to version
2007-01-17 18:47 Upgrade/Installation problem: Version 7.4.9 to version 8.1.3 Andrew Edson <cheighlund@yahoo.com>
2007-01-17 18:58 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Jeff Frost <jeff@frostconsultingllc.com>
2007-01-17 20:41 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Andrew Edson <cheighlund@yahoo.com>
2007-01-17 20:45 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Jeff Frost <jeff@frostconsultingllc.com>
@ 2007-01-17 20:48 ` Jeff Frost <jeff@frostconsultingllc.com>
0 siblings, 0 replies; 13+ messages in thread
From: Jeff Frost @ 2007-01-17 20:48 UTC (permalink / raw)
To: Andrew Edson <cheighlund@yahoo.com>; +Cc: pgsql-admin
And of course, I should have made mention of the docs here:
http://www.postgresql.org/docs/8.1/interactive/migration.html
because it likely explains it better than I am. :-)
On Wed, 17 Jan 2007, Jeff Frost wrote:
> You have to dump the original 7.4.9 version of the database and restore that
> into the 8.1.3 database server.
>
> An example:
>
> I have a server db1 which is running pg 7.4.9
> I have a server db2 which is to replace db1 running pg 8.1.3
>
> I would likely just do something like this from db2 (assuming no clients are
> writing to db1 while this is happening):
>
> pg_dumpall -h db1 | psql -h db2
>
>
> On Wed, 17 Jan 2007, Andrew Edson wrote:
>
>> Please clear something up for me. The database I'm trying to upgrade
>> was/is empty; only the original installation was present, no tables.
>> Exactly what is it I'm supposed to be dumping? If you mean making a copy
>> of the original 8.1.3, that I've done before, but I'm unclear as to the
>> meaning of what you're saying at the moment. Please enlighten me.
>>
>> Jeff Frost <jeff@frostconsultingllc.com> wrote: Andrew,
>>
>> If you're moving between major versions, a dump/restore is necessary. The
>> proper procedure is:
>>
>> 1) pg_dump the old database by using the new version of pg_dump (8.1.x)
>> against the old db server (7.4.9 in your case)
>> 2) stop the old database server (and possibly move/rename the old data dir)
>> 3) initdb the new database server
>> 4) edit postgresql.conf, etc
>> 5) start the new database server
>> 6) pg_restore the old database into the newly initialized data directory
>>
>> So, it sounds like you'll need to reinstall 7.4 and bring it back up, then
>> use
>> the 8.1.3 pg_dump to create a dump, then restore that into the new 8.1
>> server.
>>
>>
>> ---------------------------------
>> It's here! Your new message!
>> Get new email alerts with the free Yahoo! Toolbar.
>
>
--
Jeff Frost, Owner <jeff@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Upgrade/Installation problem: Version 7.4.9 to version
2007-01-17 18:47 Upgrade/Installation problem: Version 7.4.9 to version 8.1.3 Andrew Edson <cheighlund@yahoo.com>
2007-01-17 18:58 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Jeff Frost <jeff@frostconsultingllc.com>
2007-01-17 20:41 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Andrew Edson <cheighlund@yahoo.com>
@ 2007-01-17 21:12 ` Ray Stell <stellr@cns.vt.edu>
2007-01-17 21:18 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Jeff Frost <jeff@frostconsultingllc.com>
1 sibling, 1 reply; 13+ messages in thread
From: Ray Stell @ 2007-01-17 21:12 UTC (permalink / raw)
To: Andrew Edson <cheighlund@yahoo.com>; +Cc: Jeff Frost <jeff@frostconsultingllc.com>; pgsql-admin
1. Curious about the difference in step 6 of this list, uses pg_restore, and what is listed in the doc:
http://www.postgresql.org/docs/8.2/interactive/install-upgrading.html
which says to restore via:
psql -d postgres -f outputfile
Is this use of psql related to the fact that a pg_dumpall was the starting place instead
of pg_dump as is used in this list of steps? Can you use psql -f to restore a backup
via pg_dump?
2. Also, I found myself wondering:
pg_dump -> pg_restore
pg_dumpall -> ?
I would have expected a pg_restoreall. Also, I would expect such a
pg_restoreall to do the initdb step in the process of restoring "all."
Why is there pg_dumpall instead of a pg_dump with some flag?
On Wed, Jan 17, 2007 at 12:41:55PM -0800, Andrew Edson wrote:
> Please clear something up for me. The database I'm trying to upgrade was/is empty; only the original installation was present, no tables. Exactly what is it I'm supposed to be dumping? If you mean making a copy of the original 8.1.3, that I've done before, but I'm unclear as to the meaning of what you're saying at the moment. Please enlighten me.
>
> Jeff Frost <jeff@frostconsultingllc.com> wrote: Andrew,
>
> If you're moving between major versions, a dump/restore is necessary. The
> proper procedure is:
>
> 1) pg_dump the old database by using the new version of pg_dump (8.1.x)
> against the old db server (7.4.9 in your case)
> 2) stop the old database server (and possibly move/rename the old data dir)
> 3) initdb the new database server
> 4) edit postgresql.conf, etc
> 5) start the new database server
> 6) pg_restore the old database into the newly initialized data directory
>
> So, it sounds like you'll need to reinstall 7.4 and bring it back up, then use
> the 8.1.3 pg_dump to create a dump, then restore that into the new 8.1 server.
>
>
> ---------------------------------
> It's here! Your new message!
> Get new email alerts with the free Yahoo! Toolbar.
--
You have no chance to survive make your time.
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Upgrade/Installation problem: Version 7.4.9 to version
2007-01-17 18:47 Upgrade/Installation problem: Version 7.4.9 to version 8.1.3 Andrew Edson <cheighlund@yahoo.com>
2007-01-17 18:58 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Jeff Frost <jeff@frostconsultingllc.com>
2007-01-17 20:41 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Andrew Edson <cheighlund@yahoo.com>
2007-01-17 21:12 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Ray Stell <stellr@cns.vt.edu>
@ 2007-01-17 21:18 ` Jeff Frost <jeff@frostconsultingllc.com>
2007-01-17 21:27 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Ray Stell <stellr@cns.vt.edu>
0 siblings, 1 reply; 13+ messages in thread
From: Jeff Frost @ 2007-01-17 21:18 UTC (permalink / raw)
To: Ray Stell <stellr@cns.vt.edu>; +Cc: Andrew Edson <cheighlund@yahoo.com>; pgsql-admin
On Wed, 17 Jan 2007, Ray Stell wrote:
>
> 1. Curious about the difference in step 6 of this list, uses pg_restore, and what is listed in the doc:
> http://www.postgresql.org/docs/8.2/interactive/install-upgrading.html
> which says to restore via:
> psql -d postgres -f outputfile
>
It depends on the output format. Pg_restore is used if you created the dump
file in one of the non-text formats (such as -Fc or -Ft).
> Is this use of psql related to the fact that a pg_dumpall was the starting place instead
> of pg_dump as is used in this list of steps? Can you use psql -f to restore a backup
> via pg_dump?
>
> 2. Also, I found myself wondering:
> pg_dump -> pg_restore
> pg_dumpall -> ?
pg_dumpall creates plain text sql scripts (like the default output for
pg_dump), so it's:
pg_dumpall -> psql
>
> I would have expected a pg_restoreall. Also, I would expect such a
> pg_restoreall to do the initdb step in the process of restoring "all."
> Why is there pg_dumpall instead of a pg_dump with some flag?
pg_dumpall does all DBs plus the globals, but I'll have to let one of the
developers answer why there isn't just a flag for pg_dump.
>
>
>
>
>
> On Wed, Jan 17, 2007 at 12:41:55PM -0800, Andrew Edson wrote:
>> Please clear something up for me. The database I'm trying to upgrade was/is empty; only the original installation was present, no tables. Exactly what is it I'm supposed to be dumping? If you mean making a copy of the original 8.1.3, that I've done before, but I'm unclear as to the meaning of what you're saying at the moment. Please enlighten me.
>>
>> Jeff Frost <jeff@frostconsultingllc.com> wrote: Andrew,
>>
>> If you're moving between major versions, a dump/restore is necessary. The
>> proper procedure is:
>>
>> 1) pg_dump the old database by using the new version of pg_dump (8.1.x)
>> against the old db server (7.4.9 in your case)
>> 2) stop the old database server (and possibly move/rename the old data dir)
>> 3) initdb the new database server
>> 4) edit postgresql.conf, etc
>> 5) start the new database server
>> 6) pg_restore the old database into the newly initialized data directory
>>
>> So, it sounds like you'll need to reinstall 7.4 and bring it back up, then use
>> the 8.1.3 pg_dump to create a dump, then restore that into the new 8.1 server.
>>
>>
>> ---------------------------------
>> It's here! Your new message!
>> Get new email alerts with the free Yahoo! Toolbar.
>
--
Jeff Frost, Owner <jeff@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Upgrade/Installation problem: Version 7.4.9 to version
2007-01-17 18:47 Upgrade/Installation problem: Version 7.4.9 to version 8.1.3 Andrew Edson <cheighlund@yahoo.com>
2007-01-17 18:58 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Jeff Frost <jeff@frostconsultingllc.com>
2007-01-17 20:41 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Andrew Edson <cheighlund@yahoo.com>
2007-01-17 21:12 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Ray Stell <stellr@cns.vt.edu>
2007-01-17 21:18 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Jeff Frost <jeff@frostconsultingllc.com>
@ 2007-01-17 21:27 ` Ray Stell <stellr@cns.vt.edu>
2007-01-17 21:31 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Jeff Frost <jeff@frostconsultingllc.com>
0 siblings, 1 reply; 13+ messages in thread
From: Ray Stell @ 2007-01-17 21:27 UTC (permalink / raw)
To: Jeff Frost <jeff@frostconsultingllc.com>; +Cc: Andrew Edson <cheighlund@yahoo.com>; pgsql-admin
On Wed, Jan 17, 2007 at 01:18:06PM -0800, Jeff Frost wrote:
> On Wed, 17 Jan 2007, Ray Stell wrote:
> >Why is there pg_dumpall instead of a pg_dump with some flag?
>
> pg_dumpall does all DBs plus the globals, but I'll have to let one of the
> developers answer why there isn't just a flag for pg_dump.
Thanks.
If I've done a pg_dumpall does some of the sql that gets included
fail in the restore because the objects already exist via the documented
initdb? That is how it works with oracle, you export, install a db, then
import, but the import throws errors because of the installe objects already
exist.
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Upgrade/Installation problem: Version 7.4.9 to version
2007-01-17 18:47 Upgrade/Installation problem: Version 7.4.9 to version 8.1.3 Andrew Edson <cheighlund@yahoo.com>
2007-01-17 18:58 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Jeff Frost <jeff@frostconsultingllc.com>
2007-01-17 20:41 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Andrew Edson <cheighlund@yahoo.com>
2007-01-17 21:12 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Ray Stell <stellr@cns.vt.edu>
2007-01-17 21:18 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Jeff Frost <jeff@frostconsultingllc.com>
2007-01-17 21:27 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Ray Stell <stellr@cns.vt.edu>
@ 2007-01-17 21:31 ` Jeff Frost <jeff@frostconsultingllc.com>
2007-01-18 14:17 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Ray Stell <stellr@cns.vt.edu>
0 siblings, 1 reply; 13+ messages in thread
From: Jeff Frost @ 2007-01-17 21:31 UTC (permalink / raw)
To: Ray Stell <stellr@cns.vt.edu>; +Cc: Andrew Edson <cheighlund@yahoo.com>; pgsql-admin
On Wed, 17 Jan 2007, Ray Stell wrote:
> On Wed, Jan 17, 2007 at 01:18:06PM -0800, Jeff Frost wrote:
>> On Wed, 17 Jan 2007, Ray Stell wrote:
>>> Why is there pg_dumpall instead of a pg_dump with some flag?
>>
>> pg_dumpall does all DBs plus the globals, but I'll have to let one of the
>> developers answer why there isn't just a flag for pg_dump.
>
> Thanks.
>
> If I've done a pg_dumpall does some of the sql that gets included
> fail in the restore because the objects already exist via the documented
> initdb? That is how it works with oracle, you export, install a db, then
> import, but the import throws errors because of the installe objects already
> exist.
Yes, for instance the postgres db user is pretty much guaranteed to exist.
Usually when I do a restore, I do it like this:
zcat dumpall.gz | psql postgres > restore.txt 2> restore.err
or
pg_restore frostconsulting.dmp | psql frostconsulting > restore.txt 2> restore.err
and that way I can review the errors in restore.err to determine if it's
a real issue or not.
--
Jeff Frost, Owner <jeff@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Upgrade/Installation problem: Version 7.4.9 to version
2007-01-17 18:47 Upgrade/Installation problem: Version 7.4.9 to version 8.1.3 Andrew Edson <cheighlund@yahoo.com>
2007-01-17 18:58 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Jeff Frost <jeff@frostconsultingllc.com>
2007-01-17 20:41 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Andrew Edson <cheighlund@yahoo.com>
2007-01-17 21:12 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Ray Stell <stellr@cns.vt.edu>
2007-01-17 21:18 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Jeff Frost <jeff@frostconsultingllc.com>
2007-01-17 21:27 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Ray Stell <stellr@cns.vt.edu>
2007-01-17 21:31 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Jeff Frost <jeff@frostconsultingllc.com>
@ 2007-01-18 14:17 ` Ray Stell <stellr@cns.vt.edu>
2007-01-18 15:42 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 13+ messages in thread
From: Ray Stell @ 2007-01-18 14:17 UTC (permalink / raw)
To: Jeff Frost <jeff@frostconsultingllc.com>; +Cc: Andrew Edson <cheighlund@yahoo.com>; pgsql-admin
On Wed, Jan 17, 2007 at 01:31:50PM -0800, Jeff Frost wrote:
Please, a couple of more questions about this upgrade process (never been through it, obviously).
1. I am backing up some of the config files that I know that I have touched:
postgresql.conf, pg_hba.conf
Are there other files down in there that I will need later that you tend to want to keep?
2. When you prepare to pg_dumpall using the new version, do you need to change all the
path vars to point to the new install such as LD_LIBRARY_PATH and PATH, or does just
an explicit call of the new pg_dumpall ok?
Thanks.
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Upgrade/Installation problem: Version 7.4.9 to version
2007-01-17 18:47 Upgrade/Installation problem: Version 7.4.9 to version 8.1.3 Andrew Edson <cheighlund@yahoo.com>
2007-01-17 18:58 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Jeff Frost <jeff@frostconsultingllc.com>
2007-01-17 20:41 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Andrew Edson <cheighlund@yahoo.com>
2007-01-17 21:12 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Ray Stell <stellr@cns.vt.edu>
2007-01-17 21:18 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Jeff Frost <jeff@frostconsultingllc.com>
2007-01-17 21:27 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Ray Stell <stellr@cns.vt.edu>
2007-01-17 21:31 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Jeff Frost <jeff@frostconsultingllc.com>
2007-01-18 14:17 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Ray Stell <stellr@cns.vt.edu>
@ 2007-01-18 15:42 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 13+ messages in thread
From: Tom Lane @ 2007-01-18 15:42 UTC (permalink / raw)
To: Ray Stell <stellr@cns.vt.edu>; +Cc: Jeff Frost <jeff@frostconsultingllc.com>; Andrew Edson <cheighlund@yahoo.com>; pgsql-admin
Ray Stell <stellr@cns.vt.edu> writes:
> 2. When you prepare to pg_dumpall using the new version, do you need to change all the
> path vars to point to the new install such as LD_LIBRARY_PATH and PATH, or does just
> an explicit call of the new pg_dumpall ok?
Just call the new version --- you might need to give it an explicit -P
switch if you compiled it with a different default port number, but
that's about it.
regards, tom lane
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Upgrade/Installation problem: Version 7.4.9 to version
@ 2007-01-17 21:13 Jeff Frost <jeff@frostconsultingllc.com>
2007-01-17 21:40 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Andrew Edson <cheighlund@yahoo.com>
0 siblings, 1 reply; 13+ messages in thread
From: Jeff Frost @ 2007-01-17 21:13 UTC (permalink / raw)
To: Andrew Edson <cheighlund@yahoo.com>; +Cc: pgsql-admin
Please reply-all when replying so everyone can help.
What I mean is that I have a physical server db1 which is old and meant to be
replaced by new shiny physical server db2.
Let me ask a different question, because it seems perhaps I didn't understand
your original email.
Are you just trying to upgrade from postgresql 7.4.9 to 8.1.3 (I'd suggest
8.1.6 myself) on the same physical machine?
If so, then you need to use an intermediate file like this:
(starting from when postgresql-7.4.9 is running)
/usr/local/src/postgresql-8.1.6/src/bin/pg_dump/pg_dumpall | gzip > dumpall.gz
stop postgresql 7.4.9 server
rename the 7.4.9 data directory
install postgresql-8.1.6
initdb -E UTF8 -D /var/lib/pgsql/data
(or wherever your data directory is to reside)
start postgresql 8.1.6
zcat dumpall.gz | psql postgres
On Wed, 17 Jan 2007, Andrew Edson wrote:
> I'm not understanding part of what you wrote. Unless you mean the
> upgrading, I'm not certain what you mean by 'replace' in your example.
> Should I be trying to have both copies of Postgres running at once or
> something like that? And if so, how would I do that?
>
> Jeff Frost <jeff@frostconsultingllc.com> wrote: You have to dump the original 7.4.9 version of the database and restore that
> into the 8.1.3 database server.
>
> An example:
>
> I have a server db1 which is running pg 7.4.9
> I have a server db2 which is to replace db1 running pg 8.1.3
>
> I would likely just do something like this from db2 (assuming no clients are
> writing to db1 while this is happening):
>
> pg_dumpall -h db1 | psql -h db2
>
>
> ---------------------------------
> TV dinner still cooling?
> Check out "Tonight's Picks" on Yahoo! TV.
--
Jeff Frost, Owner <jeff@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Upgrade/Installation problem: Version 7.4.9 to version
2007-01-17 21:13 Re: Upgrade/Installation problem: Version 7.4.9 to version Jeff Frost <jeff@frostconsultingllc.com>
@ 2007-01-17 21:40 ` Andrew Edson <cheighlund@yahoo.com>
0 siblings, 0 replies; 13+ messages in thread
From: Andrew Edson @ 2007-01-17 21:40 UTC (permalink / raw)
To: Jeff Frost <jeff@frostconsultingllc.com>; +Cc: pgsql-admin
I apologize; I had intended to reply-all, and simply missed the mark somehow.
Also, thank you for the link to the documentation; it was clear enough that I was able to get what I needed done...at least as far as I can tell, since it's not finished yet.
Thank you very much for your gracious assistance.
Jeff Frost <jeff@frostconsultingllc.com> wrote:
Please reply-all when replying so everyone can help.
What I mean is that I have a physical server db1 which is old and meant to be
replaced by new shiny physical server db2.
Let me ask a different question, because it seems perhaps I didn't understand
your original email.
Are you just trying to upgrade from postgresql 7.4.9 to 8.1.3 (I'd suggest
8.1.6 myself) on the same physical machine?
If so, then you need to use an intermediate file like this:
(starting from when postgresql-7.4.9 is running)
/usr/local/src/postgresql-8.1.6/src/bin/pg_dump/pg_dumpall | gzip > dumpall.gz
stop postgresql 7.4.9 server
rename the 7.4.9 data directory
install postgresql-8.1.6
initdb -E UTF8 -D /var/lib/pgsql/data
(or wherever your data directory is to reside)
start postgresql 8.1.6
zcat dumpall.gz | psql postgres
---------------------------------
Don't pick lemons.
See all the new 2007 cars at Yahoo! Autos.
^ permalink raw reply [nested|flat] 13+ messages in thread
end of thread, other threads:[~2007-01-18 15:42 UTC | newest]
Thread overview: 13+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-01-17 18:47 Upgrade/Installation problem: Version 7.4.9 to version 8.1.3 Andrew Edson <cheighlund@yahoo.com>
2007-01-17 18:58 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Jeff Frost <jeff@frostconsultingllc.com>
2007-01-17 20:41 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Andrew Edson <cheighlund@yahoo.com>
2007-01-17 20:45 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Jeff Frost <jeff@frostconsultingllc.com>
2007-01-17 20:48 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Jeff Frost <jeff@frostconsultingllc.com>
2007-01-17 21:12 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Ray Stell <stellr@cns.vt.edu>
2007-01-17 21:18 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Jeff Frost <jeff@frostconsultingllc.com>
2007-01-17 21:27 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Ray Stell <stellr@cns.vt.edu>
2007-01-17 21:31 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Jeff Frost <jeff@frostconsultingllc.com>
2007-01-18 14:17 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Ray Stell <stellr@cns.vt.edu>
2007-01-18 15:42 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Tom Lane <tgl@sss.pgh.pa.us>
2007-01-17 21:13 Re: Upgrade/Installation problem: Version 7.4.9 to version Jeff Frost <jeff@frostconsultingllc.com>
2007-01-17 21:40 ` Re: Upgrade/Installation problem: Version 7.4.9 to version Andrew Edson <cheighlund@yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox