3 hours ago by Gavin Henry

It's taken us a while to get round to ordering one of these Yubikeys from Yubico, but they do look great and have lots of documentation via the wiki. We're going to be testing them via the pam module for SSH access (and of course using pam_ldap). So, users in LDAP [?] via pam, and a Yubikey, let's s ...

The Suretec Blog - blog.suretecsystems.com · 8 references

19 hours ago by depesz

On 18th of November Tom Lane committed patch by Laurenz Albe which adds very interesting capability: Add a hook to CREATE/ALTER ROLE to allow an external module to check the strength of database passwords, and create a sample implementation of such a hook as a new contrib module "passwordcheck". Lau ...

select * from depesz; - depesz.com · Rank: 72,548 · 51 references

22 hours ago by Kyle Cordes

I suppose there have been hiring companies with wildly unrealistic cost expectations forever; the internet just makes it more visible. Take, for example, this job post for PostgreSQL expert, which I republish here for criticism and comment, anonymized: We are looking for a postgre expert with indept ...

Kyle Cordes - kylecordes.com · Rank: 45,876 · 65 references

1 day ago by sandip

To manage/setup role based password authentication for postgresql database. Modify "/var/lib/pgsql/data/pg_hba.conf" and include: host samerole all 127.0.0.1/32 md5 Save the below script and run: ./db_setup.sh create #!/bin/bash # db_setup.sh USAGE="Usage: $0 < ...

LinuxWebLog.com - Tips, ... - linuxweblog.com · Rank: 144,618 · 13 references

1 day ago by pitti

Yesterday PostgreSQL released new security/bug fix microreleases 8.4.2, 8.3.9, and 8.1.19, which fix two security issues and a whole bunch of bugs. Updates for all supported Ubuntu releases are built in the ubuntu-security-proposed PPA. They pass the upstream and postgresql-common test suites, but m ...

Martin Pitt - piware.de · Rank: 144,477 · 3 references

1 day ago by Al Wold

MySQL was "bought" by Sun last year, as you may know. The fact that this is significant sort of illustrates one of the reasons I didn't like MySQL from the moment I met it in 1997 or so. It's only like half in the game as far as being free and open source. It is tied way too much to MySQL AB, the co ...

Al's Blog - alwold.blogspot.com · 1 reference

1 day ago by logbinario

Leyendo la documentacion oficial de PostgreSQL versión 8.4.2, en lo que respecta a la programación de funciones con PL/pgSQL, resulta que ahora ya es posible codificar mas de una sección de declaracion de variables (DECLARE) las cuales pasan a formar un subblock, además de que se puede declarar mas ...

logBinario::blog - logbinario.wordpress.com

1 day ago by depesz

On 13th of November (I know, backlog again), Tom Lane committed patch which make PostgreSQL more strict about what happens in stored procedures in PL/pgSQL: Add control knobs for plpgsql's variable resolution behavior, and make the default be "throw error on conflict", as per discussions. The GUC va ...

select * from depesz; - depesz.com · Rank: 72,548 · 51 references

1 day ago by zrydento

Domain Name Servers on the internet use various software to function, the most popular DNS server type on the internet is BIND, which stands for Berkeley Internet Name Domain. BIND is the predominant system on UNIX based systems. BIND was originally created at the University of California, Berkeley ...

Zero Intellect - zerointellect.com

1 day ago by LAONB

PostgreSQL是一种对象-关系型数据库管理系统(ORDBMS),也是目前功能最强大、特性最丰富和最复杂的自由软件数据库系统.它起源于伯克利 (BSD)的数据库研究计划,目前是最重要的开源数据库产品......

LAONB.COM - laonb.com · Rank: 31,479 · 7 references