Skip site navigation (1) Skip section navigation (2)

Re: pg_upgrade missing

From: "Matthias Howell" <Matthias(dot)Howell(at)voxco(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: pg_upgrade missing
Date: 2012-06-06 19:00:58
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
To bring some closure:


I installed the -contrib  as well which gave me pg_upgrade.


Then I ran into a missing postgres file issue with pg_upgrade.


I realized that the rpm -ev postgresql-server-9.0.0-1PGDG.el5.x86_64
that I had run probably caused the issue so I reinstalled 9.0


Then I hit this issue and used the instructions here to get it to run.


It completed successfully.


Thanks for the help.







From: Matthias Howell 
Sent: Wednesday, June 06, 2012 11:36 AM
To: 'pgsql-novice(at)postgresql(dot)org'
Subject: pg_upgrade missing




I'm trying to upgrade from postgres 9.0.0 to 9.1.4 (latest? downloaded
it today).


however, pg_upgrade is not showing in the 9.1 bin.



Here are the steps I executed:

rpm -ivh ./pgdg-centos91-9.1-4.noarch.rpm

yum install postgresql91-server which gave me a dependency error so I
ran rpm -ev postgresql-server-9.0.0-1PGDG.el5.x86_64


yum install postgresql91-server again and it worked.


but there is no pg_upgrade in the new bin dir.


[root(at)sociallinux bin]# pwd


[root(at)sociallinux bin]# ls

clusterdb  createdb  createlang  createuser  dropdb  droplang  dropuser
oid2name  pg_archivecleanup  pgbench  pg_dump  pg_dumpall  pg_restore
pg_standby  pg_upgrade  psql  reindexdb  vacuumdb  vacuumlo

[root(at)sociallinux bin]#





[root(at)sociallinux bin]# ls

clusterdb  createlang  dropdb    dropuser  pg_basebackup  pg_controldata
pg_dump     pg_resetxlog  pg_test_fsync  postmaster  reindexdb

createdb   createuser  droplang  initdb    pg_config      pg_ctl
pg_dumpall  pg_restore    postgres       psql        vacuumdb

[root(at)sociallinux bin]#


Not sure how to proceed.





pgsql-novice by date

Next:From: Tom LaneDate: 2012-06-06 20:42:36
Subject: Re: pg_upgrade missing
Previous:From: Devrim GÜNDÜZDate: 2012-06-06 18:59:03
Subject: Re: pg_upgrade missing

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group