marian krucina <marian.krucina@xxxxxxxxx> writes: > pg_upgrade failed on own server, because we used functions from public > schema in index. We install common functions (e.g. postgresql contrib) > to public schema. Tables and indexes are in another schema, and names > of functions without a schema name. Are you sure that has anything to do with schemas, or is it that you forgot to install the (updated versions of the) same contrib modules into the new installation? If not that, please provide a complete description of what you've got in your old database and the errors you got trying to upgrade. Also, exactly what old and new PG versions are you working with? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general