Hi,
I'm running postgresql 9.1 on Debian and am trying to set up LDAP
authentication using the following configuration in pg_hba.conf:
hostssl testdb all 143.50.203.0/24 ldap ldapserver=wegc24.uni-graz.at
ldapport=636 ldapbinddn=cn=nss,dc=uni-graz,dc=at
ldapbindpasswd=thepasswd
I don't think SSL support for LDAP is supported. Have you tried TLS on port
389?
On May 13, 2014 8:20 PM, Jürgen Fuchsberger
juergen.fuchsber...@uni-graz.at wrote:
Hi,
I'm running postgresql 9.1 on Debian and am trying to set up LDAP
authentication using the following configuration in
Hi,
I have a table with daily partition setup where old partitions are static
tables that is after each day we don't get any new data in old partitions.
The database size is 2 TB and I am running with autovacuum on for
Postgresql 8.4.
Now, I am facing a problem where old tables are not being
On Wed, May 14, 2014 at 8:35 AM, Stephan Fabel sfa...@hawaii.edu wrote:
I don't think SSL support for LDAP is supported. Have you tried TLS on
port 389?
Correct, and you need to set ldaptls=1 to use that as well.
(And yes, unfortunately the LDAP error messages from openldap are
notoriously
Hi, all.
I found the problem - it was merely a poorly written query, which for some
reason was less terrible on my laptop. Looking at http://explain.depesz.com/
helped me solve the issue. Performance is now back to normal.
It seems this was a classic case of pebcak. Thank you for your help and
Search for fulltext tutorial + json functions
http://www.postgresql.org/docs/9.3/static/functions-json.html
On Wed, May 14, 2014 at 1:00 AM, Jesus Rafael Sanchez Medrano
jesusraf...@gmail.com wrote:
thanks... could you please be so kind to post some snippet/code for this?
Att.
==
Jesus
On Wed, May 14, 2014 at 6:48 AM, Peeyush Agarwal
peeyushagarwal1...@gmail.com wrote:
Hi,
Thanks for the reply :)
Yes, Storing timestamp as timestamp [ (p) ] would be better. I simplified
the session in question. It may contain alphabets as well. So, I will
probably need to store it as a
On Wed, May 14, 2014 at 11:48 AM, Jürgen Fuchsberger
juergen.fuchsber...@uni-graz.at wrote:
On 05/14/2014 09:10 AM, Magnus Hagander wrote:
On Wed, May 14, 2014 at 8:35 AM, Stephan Fabel sfa...@hawaii.edu
mailto:sfa...@hawaii.edu wrote:
I don't think SSL support for LDAP is
On Friday 09 May 2014 08:36:04 David G Johnston wrote:
This seems to likely be the same, still open, bug reported previously:
No Number Assigned:
http://www.postgresql.org/message-id/CANCipfpfzoYnOz5jj=UZ70_R=CwDHv36dqWSpw
si27vpm1z...@mail.gmail.com
#8464
On May 14, 2014 12:56 AM, Magnus Hagander mag...@hagander.net wrote:
On Wed, May 14, 2014 at 11:48 AM, Jürgen Fuchsberger
juergen.fuchsber...@uni-graz.at wrote:
On 05/14/2014 09:10 AM, Magnus Hagander wrote:
On Wed, May 14, 2014 at 8:35 AM, Stephan Fabel sfa...@hawaii.edu
Hi Rumman,
Please publish the below information.
1. vacuum and auto-vacuum parametters current settings on cluster.
select name,setting from pg_settings where name ilike '%vacuum%';
2. show maintenance_work_mem ;
show autovacuum_max_workers ;
3. Physical Ram size on server.
--Chiru
On Wed, May 14, 2014 at 12:06 AM, AI Rumman rumman...@gmail.com wrote:
Hi,
I have a table with daily partition setup where old partitions are static
tables that is after each day we don't get any new data in old partitions.
The database size is 2 TB and I am running with autovacuum on for
On Wed, May 14, 2014 at 3:45 PM, Jeff Janes jeff.ja...@gmail.com wrote:
On Wed, May 14, 2014 at 12:06 AM, AI Rumman rumman...@gmail.com wrote:
Hi,
I have a table with daily partition setup where old partitions are static
tables that is after each day we don't get any new data in old
We have a master/slave setup with replication. Today we failed over to the
slave and saw disk I/O go through the roof.
Are the pg_statistic statistics synced along with streaming replication?
Are you expected to have to do a vacuum analyze after failing over? That's
what we're trying now to see
14 matches
Mail list logo