pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_upgrade doesn't work?
2+ messages / 2 participants
[nested] [flat]
* pg_upgrade doesn't work?
@ 2018-08-09 21:05 Cogan, Mark Contractor, NRL Code 3030 <mark.cogan.ctr@nrl.navy.mil>
2018-08-10 10:22 ` Re: pg_upgrade doesn't work? Stephen Frost <sfrost@snowman.net>
0 siblings, 1 reply; 2+ messages in thread
From: Cogan, Mark Contractor, NRL Code 3030 @ 2018-08-09 21:05 UTC (permalink / raw)
To: pgsql-admin
So why does the documentation tell me that I should use the pg_upgrade
command to migrate my 8.4.20 db to 9.6, but when I run the command it tells
me that the major version is different so it won't run? Is there some kind
of issue with the location of the execution binary?
Mark Cogan
Systems Administrator - Contractor, Code 3030
Information Delivery Systems, Inc
Onsite - Naval Research Lab
(202) 404-2032
Attachments:
smime.p7s (application/pkcs7-signature, 10.1K) download
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pg_upgrade doesn't work?
2018-08-09 21:05 pg_upgrade doesn't work? Cogan, Mark Contractor, NRL Code 3030 <mark.cogan.ctr@nrl.navy.mil>
@ 2018-08-10 10:22 ` Stephen Frost <sfrost@snowman.net>
0 siblings, 0 replies; 2+ messages in thread
From: Stephen Frost @ 2018-08-10 10:22 UTC (permalink / raw)
To: Cogan, Mark Contractor, NRL Code 3030 <mark.cogan.ctr@nrl.navy.mil>; +Cc: pgsql-admin
Greetings,
* Cogan, Mark Contractor, NRL Code 3030 (mark.cogan.ctr@nrl.navy.mil) wrote:
> So why does the documentation tell me that I should use the pg_upgrade
> command to migrate my 8.4.20 db to 9.6, but when I run the command it tells
> me that the major version is different so it won't run? Is there some kind
> of issue with the location of the execution binary?
Having the exact error messgaes would be really helpful. You're sure
that you are using the pg_upgrade from 9.6? Note that to perform a
pg_upgrade you have to have the binaries for *both* versions installed
on to the system and then pg_upgrade will perform a copy of the data
files or will create hard-links between the old and new data
directories.
Thanks!
Stephen
Attachments:
signature.asc (application/pgp-signature, 818B) download
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2018-08-10 10:22 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-08-09 21:05 pg_upgrade doesn't work? Cogan, Mark Contractor, NRL Code 3030 <mark.cogan.ctr@nrl.navy.mil>
2018-08-10 10:22 ` Stephen Frost <sfrost@snowman.net>
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