Re: [ADMIN] pg_upgrade with postgis

2012-09-12 Thread Bruce Momjian
On Thu, Sep 13, 2012 at 02:12:40AM +0300, Ronit Allen wrote: > Hi - > > Thanks. > As we installed using pg repos (yum) I don't think it will allow me to > re-install postgis. > Is it possible to specify a target cluster for a postgis install from repo or > will it need to be installed from source

Re: [ADMIN] what is maximum allowed value of autovacuum_freeze_max_age

2012-09-12 Thread Kevin Grittner
Radovan Jablonovsky wrote: > In documentation > http://www.postgresql.org/docs/9.1/static/routine-vacuuming.html > is this information about autovacuum_freeze_max_age: "if > autovacuum_freeze_max_age is set to its maximum allowed value of a > little less than two billion". What is exact maximum

Re: [ADMIN] pg_upgrade with postgis

2012-09-12 Thread Ronit Allen
Hi - Thanks. As we installed using pg repos (yum) I don't think it will allow me to re-install postgis. Is it possible to specify a target cluster for a postgis install from repo or will it need to be installed from source? Thanks again. On Wed, Sep 12, 2012 at 1:17 AM, Bruce Momjian wrote: > On

Re: [ADMIN] Missing loadable libraries when running pg_upgrade 9.1 -> 9.2

2012-09-12 Thread Bruce Momjian
On Wed, Sep 12, 2012 at 12:03:21PM +0200, Thomas Kellerer wrote: > Thomas Kellerer wrote on 12.09.2012 11:09: > >Is there a way to find out which function (or extension?) is using those > >libraries in order to remove that dependency? > > What I ended up doing is to search through my pg_dump back

Re: [ADMIN] pg_restore problem "Found unexpected Block id"

2012-09-12 Thread Kevin Grittner
"ramana.pls" wrote: > I am getting an error while restoring the Database Backup. I am > postgre sql 8.0 with Windows XP O.S. PostgreSQL version 8.0 has been out of support overall for years, and out of support for Windows for years before that. http://archives.postgresql.org/pgsql-announce/2

Re: [ADMIN] pg_restore problem "Found unexpected Block id"

2012-09-12 Thread Tom Lane
"ramana.pls" writes: > I am getting an error while restoring the Database Backup. I am postgre sql > 8.0 with Windows XP O.S. 8.0? You do know that's been out of support for several years now, right? > while restoring the data i am getting > pg_restore: [custom archiver] found unexpected block

Re: [ADMIN] Missing loadable libraries when running pg_upgrade 9.1 -> 9.2

2012-09-12 Thread Thomas Kellerer
Thomas Kellerer wrote on 12.09.2012 11:09: Is there a way to find out which function (or extension?) is using those libraries in order to remove that dependency? What I ended up doing is to search through my pg_dump backups and I found the "offending" database. After removing the functions in

[ADMIN] Missing loadable libraries when running pg_upgrade 9.1 -> 9.2

2012-09-12 Thread Thomas Kellerer
using Windows XP SP3 (32bit). When running pg_upgrade with the --check option I get the following error: Your installation references loadable libraries that are missing from the new installation. You can add these libraries to the new installation, or remove the functions using the

[ADMIN] pg_restore problem "Found unexpected Block id"

2012-09-12 Thread ramana.pls
Hi , I am getting an error while restoring the Database Backup. I am postgre sql 8.0 with Windows XP O.S. while restoring the data i am getting pg_restore: [custom archiver] found unexpected block ID (0) when reading data -- expected 4034 Plz provide any solution. Thanks in advance -- Vi