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

2012-10-10 Thread Albe Laurenz
Tom Lane wrote: Craig James cja...@emolecules.com 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

[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

[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:

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

2012-10-10 Thread Tom Lane
Craig James cja...@emolecules.com 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

[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

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 upgrade to

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 (pgsql-admin@postgresql.org) To make changes to your subscription:

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

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',