Re: [GENERAL] Disable databse listing for non-superuser (\l) ?

2009-07-24 Thread Brian A. Seklecki
> So, is this a misguided attempt at security through obscurity, or are > you looking at limiting the noise that users see when they look at > databases? The answer to that question would be "yes". ~BAS -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes t

[GENERAL] Disable databse listing for non-superuser (\l) ?

2009-07-24 Thread Brian A. Seklecki
All: Any suggestions on how-to, or comments on a potential NFR, to disable non-superuser's from viewing the database list via \l? Possibly a postgresql.conf toggle or restrictions on the internal views that constitute say, 'pg_catalog.pg_database'. Something equivalent, in principal, to Free

[GENERAL] Disable databse listing for non-superuser (\l) ?

2009-07-23 Thread Brian A. Seklecki
All: Any suggestions on how-to, or comments on a potential NFR, to disable non-superuser's from viewing the database list via \l? Possibly a postgresql.conf toggle or restrictions on the internal views that constitute say, 'pg_catalog.pg_database'. Something equivalent, in principal, to Free

Re: [GENERAL] LDAP Authentication

2008-07-02 Thread Brian A. Seklecki (Mobile)
On Sun, 2008-06-29 at 17:58 +0200, Magnus Hagander wrote: > This is not something you currently can do. We can only do LDAP > authentication, not authorization. There's no way to restrict it to a > particular group. We're very interested in this functionality (nss_ldap for PgSQL) -- so if there's

Re: [GENERAL] [Xen-users] SNMP AgentX subagent for Xen

2008-06-02 Thread Brian A. Seklecki
On Mon, 2008-06-02 at 15:05 +0200, Alain Barthe wrote: > > Sounds like a fun project. > I agree. With PostgreSQL, a the agent can simply daemonize and talk to the Postmaster using libpq and proper HBA. Everything in pg_catalog.* and information_schema.* is already quantified in

Re: [GENERAL] [Xen-users] SNMP AgentX subagent for Xen

2008-06-02 Thread Brian A. Seklecki
On Mon, 2008-06-02 at 13:53 +0100, Dave Shield wrote: > 2008/6/2 Brian A. Seklecki <[EMAIL PROTECTED]>: > >> <[EMAIL PROTECTED]>: > >> There should be a AgentX sub-agent for Xen that feeds Net-SNMP > >> ~BAS > >> > > >

Re: [GENERAL] [Xen-users] SNMP AgentX subagent for Xen

2008-06-02 Thread Brian A. Seklecki
On Mon, 2008-06-02 at 09:10 +0200, Alain Barthe wrote: > 2008/5/31 Brian A. Seklecki (Mobile) > <[EMAIL PROTECTED]>: > There should be a AgentX sub-agent for Xen that feeds Net-SNMP > ~BAS > We can work on one. The Net-SNMP folks have a great AgentX API I

Re: [GENERAL] PostgreSQL/PHP Application Server

2008-02-14 Thread Brian A. Seklecki
On Fri, 2008-01-25 at 06:01 +1030, Shane Ambler wrote: > > I haven't looked into it much but SE-PostgreSQL may be an option for Bill Moran also pointed out Postgresql Veil & PHP Horde: Veil Project http://veil.projects.postgresql.org/ Horde Framework: http://www.horde.org/ Of course, there

Re: [GENERAL] PostgreSQL/PHP Application Server

2008-02-04 Thread Brian A. Seklecki (Mobile)
> No, I was suggesting an approach that might address your requirement > for integration with other authentication systems. > Actually what I really need is the Oracle 9i + Oracle Directory Service functionality (e.g. nss_ldap for PostgreSQL). That combined with Oracle Label Security (OLS) --

Re: [GENERAL] PostgreSQL/PHP Application Server

2008-02-02 Thread Brian A. Seklecki (Mobile)
On Thu, 2008-01-24 at 13:10 -0500, John DeSoi wrote: > . The user/login system is extensible, so you could write your own. I'm not sure if I follow: Are you suggestion that the CMS system, Drupal, is an example of an application server model because of its framework extension? ~BAS IMPORTAN

[GENERAL] PostgreSQL/PHP Application Server

2008-01-24 Thread Brian A. Seklecki
All: Are there any frameworks / toolkits available, possibly as established F/OSS projects, for web applications using PHP+PostgreSQL? sf.net/google comes up short -- a few XML services and Perl+PgSQL hits. By 'application server', as a marketing wank-word gleaned from Oracle/IBM/BEA, essentiall

[GENERAL] PostgreSQL/PHP Application Server

2008-01-24 Thread Brian A. Seklecki (Mobile)
All: Are there any frameworks / toolkits available, possibly as established F/OSS projects, for web applications using PHP+PostgreSQL? sf.net/google comes up short -- a few XML services and Perl+PgSQL hits. By 'application server', as a marketing wank-word gleaned from Oracle/IBM/BEA, essentiall

Re: [GENERAL] Instalation problem

2007-03-31 Thread Brian A. Seklecki
Login in as administrator, take ownership using NTFS permissions, and cane it. ~BAS On Sat, 2007-03-31 at 12:26 -0300, Jonathan Barbero wrote: > Hello. >I installed Pg some time ago. Now i desinstalled it and try to > reinstall, but the instalation program canĀ“t finish. It throw a > proble

Re: [GENERAL] introduction of FK results in no data insert

2007-03-31 Thread Brian A. Seklecki
Please send specific error messages and schemas if possible. ~BAS On Sat, 2007-03-31 at 16:47 -0400, Harpreet Dhaliwal wrote: > Hi, > Upto the point when i don't have FKs in my database, things work fine. > As soon as i put FK in all the tables referencing to a field of one > single table, nothi

Re: [GENERAL] why can't I increase shared buffers to higher value?

2007-03-01 Thread Brian A. Seklecki
3. Thanks Have a burning question? Go to www.Answers.yahoo.com and get answers from real people who know. l8* -lava (Brian A. Seklecki - Pittsburgh, PA, USA) http://www.spiritual-machines.org/ "...from back in the heady days when "hel

Re: [GENERAL] Recursive/Wildcard Object Ownership Change

2007-03-01 Thread Brian A. Seklecki
Corrections (was in a hurry to get to class): - There is no way to specify recursion in "ALTER _DATABASE_ OWNER TO rolename" (changes all objects) ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archi

[GENERAL] Recursive/Wildcard Object Ownership Change

2007-02-28 Thread Brian A. Seklecki
option is to dump the schema and use regex to alter OWNER statements. Ideas on more efficient ways to do this? l8* -lava (Brian A. Seklecki - Pittsburgh, PA, USA) http://www.spiritual-machines.org/ ---(end of broadcast)

Re: [GENERAL] Backup and Restore mechanism in Postgres

2006-01-24 Thread Brian A. Seklecki
On Tue, 20 Sep 2005, Lincoln Yeoh wrote: At 10:00 AM 9/20/2005 -0400, Vivek Khera wrote: On Sep 14, 2005, at 9:45 AM, vinita bansal wrote: I have a 4 proc. AMD Opteron machine with 32 GB RAM and ~400GB HDD Just curious what ever came of this? Also, were you reading the DB and writing the

Re: [GENERAL] psql(18967) malloc: *** vm_allocate(size=8421376)

2006-01-23 Thread Brian A. Seklecki
What about upping ulimt(3) via ulimit(1) in builtin(1) -- assuming you're running Bash. ~BAS On Mon, 9 Jan 2006, Ari Kahn wrote: I'm doing a query that really should be too taxing. But when I execute it I get the following error(s): psql(18967) malloc: *** vm_allocate(size=8421376) faile