Re: [ADMIN] 9.2 won't load C-language function

2012-10-10 Thread Craig Ringer
On 10/11/2012 02:22 AM, Craig James wrote: I have a C-language function I've been using on 8.4 for a long time. On 9.2 it won't load: test=# set search_path = public; SET test=# CREATE OR REPLACE FUNCTION chmoogle_session_id() RETURNS integer AS '/usr/local/pgsql/lib/libchmoogle.so', 'chmoogle_

Re: [ADMIN] Pg 8.3.x on RHEL 6.3?

2012-10-10 Thread Craig Ringer
On 10/11/2012 05:15 AM, Rosser Schwarz wrote: In preparation for that effort, I've been asked to avail myself of the collective experience and wisdom of the wider community to see if anyone has seen anything unexpected, or any kind of misbehavior in running 8.3 on RHEL 6.3. I've not noticed any

Re: [ADMIN] Pg 8.3.x on RHEL 6.3?

2012-10-10 Thread Craig Ringer
On 10/11/2012 07:12 AM, Walter Hurry wrote: OK, I'll do your work for you. $200/hr. This was a polite and reasonable question, there is no need to be rude. -- Craig Ringer -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.post

Re: [ADMIN] Pg 8.3.x on RHEL 6.3?

2012-10-10 Thread Walter Hurry
On Wed, 10 Oct 2012 14:15:15 -0700, Rosser Schwarz wrote: > Fellow Pg Admins, > > At $work, we're preparing to move one of our Pg instances to new > hardware, and considering an OS upgrade at the same time. The instance > in question is running an older version of 8.3, which we'd like to > upgra

[ADMIN] Pg 8.3.x on RHEL 6.3?

2012-10-10 Thread Rosser Schwarz
Fellow Pg Admins, At $work, we're preparing to move one of our Pg instances to new hardware, and considering an OS upgrade at the same time. The instance in question is running an older version of 8.3, which we'd like to upgrade to 8.3.latest (presently .21; unf., we don't have the time or testin

Re: [ADMIN] 9.2 won't load C-language function

2012-10-10 Thread Tom Lane
Craig James writes: > ERROR: could not load library "/usr/local/pgsql/lib/libchmoogle.so": > libopenbabel.so.4: cannot open shared object file: No such file or directory > But libopenbabel.so.4 does exist: > # ls -l /usr/local/pgsql/lib/libopenbabel.so.4 > -rwxr-xr-x 1 root root 18250709 2012-1

[ADMIN] 9.2 won't load C-language function

2012-10-10 Thread Craig James
I have a C-language function I've been using on 8.4 for a long time. On 9.2 it won't load: test=# set search_path = public; SET test=# CREATE OR REPLACE FUNCTION chmoogle_session_id() RETURNS integer AS '/usr/local/pgsql/lib/libchmoogle.so', 'chmoogle_session_id' LANGUAGE c VOLATILE; ERROR: coul

[ADMIN] Multiple LDAP servers -- no failover?

2012-10-10 Thread Dave Pooser
I have two LDAP servers listed in my pg_hba.conf: local all all trust hostall all 127.0.0.1/32 trust hostall all 192.168.1.0/24 ldap ldapserver="backup.example.com primary.example.com" ldapsuffix="@example.com

Re: [ADMIN] catalog is missing

2012-10-10 Thread Bruce Momjian
On Wed, Oct 10, 2012 at 11:17:39AM +0530, Hariraman Jayaraj wrote: > Dear All, > > Using Postgres 8.3 in Suse Iinux Enterprise Edition 11 SP1. Recently server > rebooted automatically and found RAM problem and the problematic RAM has been > replaced. Now DB is working fine except, > > While vacuu

Re: [ADMIN] Mixing 8.4.x and 9.2.x clients and servers

2012-10-10 Thread Albe Laurenz
Tom Lane wrote: > Craig James writes: > > Is it OK to mix 9.2.x and 8.4.x clients and servers? Can they talk to each > > other? In other words, if I install 9.2 on a new server alongside older > > servers running 8.4.x, can clients on the 8.4 systems talk to 9.2 servers, > > and can the 9.2 clie