From: Tom Lane <tgl@sss.pgh.pa.us>
To: Laurette Cisneros <laurette@nextbus.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_restore error
Date: Tue, 03 Sep 2002 18:27:24 -0400
Message-ID: <21045.1031092044@sss.pgh.pa.us> (raw)
In-Reply-To: <Pine.LNX.4.44.0209031507130.28841-100000@visor.corp.nextbus.com>
References: <Pine.LNX.4.44.0209031507130.28841-100000@visor.corp.nextbus.com>
Laurette Cisneros <laurette@nextbus.com> writes:
> I am currently on 7.2.1 and the software location has changed (to
> /usr/local/pgsql). And, further research shows that the pg_proc shows:
> This shows /usr/local/pgsql-7.2/lib/plpgsql for the "probin" column.
> How should an update of software be handled as per pg_proc?
The preferred contents of probin are now like
$libdir/plpgsql
(the dollar sign is literal text here). As of 7.2 the server will
substitute a suitable directory name for "$libdir". You probably
have a database that was reloaded from an old dump without taking
advantage of this feature --- before 7.2 you could only use an
absolute path in probin. Now, absolute paths are deprecated for exactly
the reason that they make version updates hard.
Note the lack of a ".so" in that probin entry, too. This is also
a recommended new practice in 7.2 --- no reason to put
platform-dependent assumptions about shared library extensions into
your dumps.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, laurette@nextbus.com
Subject: Re: pg_restore error
In-Reply-To: <21045.1031092044@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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