Re: [DOCS] Mysql -> Postgresql pitfalls

2003-08-01 Thread Roberto Mello
On Fri, Aug 01, 2003 at 04:51:11PM -0400, Chad N. Tindel wrote:
> 
> As a programmer, I personally would never write code that kept people from
> running things as root.  I mean, what is the point?  If an administrator

Hmmm? 

The point is something called security.

> wants to run postgresql or apache as root, why shouldn't they be allowed
> to make that conscious decision for themselves?  As it is, you have to recompile

Because administrators have too much to worry about. If an application
makes a conscious decision to allow itself to run in a knowingly insecure
manner, that application is doing the admin a disfavor, and should be
ditched.

> apache with some BIG_SECURITY_HOLE defined in order to run as root, which means
> you can't just use the out of the box apache rpm.  Its so stupid to write
> *extra* code that keeps people from doing something that isn't even 
> fundamentally incorrect.

This has no logic. Security is fundamental. No security is fundamentally
incorrect.

-Roberto

-- 
+|Roberto Mello   -http://www.brasileiro.net/  |--+
+   Computer Science Graduate Student, Utah State University  +
+   USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ +
---/ NO INSPIRATION TODAY /---

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html


Re: [DOCS] Mysql -> Postgresql pitfalls

2003-08-02 Thread Roberto Mello
On Sat, Aug 02, 2003 at 01:10:49PM -0400, Chad N. Tindel wrote:
> > Hmmm? 
> > 
> > The point is something called security.
> 
> There is no such thing as a "proper amount of security that is correct for
> all operating environments".  

Whoever said there was? I didn't.
 
> > This has no logic. Security is fundamental. No security is fundamentally
> > incorrect.
> 
> Well, you could make a box very secure by unplugging all the LAN cables from
> it and putting it in a giant safe deposit box.  However, I would say that such
> a machine would be fundamentally incorrect for most operating environments.

Nice strawmen. Too bad it's a logical fallacy.
 
> Many people run their machines with "+ +" in root's .rhosts file because it
> eases the task of doing administration.  They work in a company where the box is
> behind a firewall on some public network and they need there computers to

How about people inside the company? Are they all nice people who live in
happy valley?

> get real work done they don't want things like "security" to get in the
> way because nobody is trying to hack those machines.

I digress.

-Roberto

-- 
+|Roberto Mello   -http://www.brasileiro.net/  |--+
+   Computer Science Graduate Student, Utah State University  +
+   USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ +
Backup not found: (Q)uem mandou usar o Stacker?

---(end of broadcast)---
TIP 8: explain analyze is your friend


Re: [DOCS] Want the docu

2003-09-06 Thread Roberto Mello
On Sat, Sep 06, 2003 at 06:55:55PM +0530, monu_indian wrote:
> Hi
> I am new user of this mail list.
> I want a document about internel structure of pgsql.Any body having , plz let me 
> know.

"monu_indian",

Try looking at the documentation at http://www.postgresql.org/ especially
the developer's manual.

-Roberto

-- 
+|Roberto Mello   -http://www.brasileiro.net/  |--+
+   Computer Science Graduate Student, Utah State University  +
+   USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ +

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


Re: [DOCS] Need help with SGML again

2003-10-13 Thread Roberto Mello
On Mon, Oct 13, 2003 at 09:01:45PM -0700, Josh Berkus wrote:
> Folks,
> 
> I'm augmenting runtime-config as requested.  However, I am finding myself 
> daunted by all the hand-coding SGML I have to do.  Can someone do some 
> handholding for me?
> 
> Particularly, I'd like to know how to:
> cross-link to another item on the same page;
> producte a bulleted or numbered list;

The OpenACS Docbook Primer should give you what you need:

http://openacs.org/doc/openacs-4-6-3/docbook-primer.html

It is for Docbook XML, which (AFAIK, might be wrong) is a superset of
Docbook SGML, but by looking at ohter examples in the docs you shoul dbe
able to assert that by yourself.

There's also the HOWTO-HOWTO from the Linux Documentation Project
(tldp.org)

-Roberto

-- 
+|Roberto Mello   -http://www.brasileiro.net/  |--+
+   Computer Science Graduate Student, Utah State University  +
+   USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ +
Quer um Chokito? Então pôe o dedo na tomadita!

---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org


Re: [DOCS] Quick help with CVS?

2003-10-22 Thread Roberto Mello
On Wed, Oct 22, 2003 at 02:49:27PM -0700, Josh Berkus wrote:
> Folks,
> 
> I can't seem to find the CVS command for telling a single file to revert to 
> the version in the repository.  Help?

If you don't care about yor modifications, you can just rm the file then
"cvs update -Pd" to re-add it from the repository.

There are other ways too. See the CVS red book (available online).

-Roberto

-- 
+|Roberto Mello   -http://www.brasileiro.net/  |--+
+   Computer Science Graduate Student, Utah State University  +
+   USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ +
:.:..::..:::.:..:..:.:..:...:...:: => BRAILE TAGLINE!

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


Re: [pgsql-www] [DOCS] 7.4 official docs : Fonts?

2003-11-20 Thread Roberto Mello
On Thu, Nov 20, 2003 at 12:16:58PM -0500, Bruce Momjian wrote:
> Michael Glaesemann wrote:
> > When I was experimenting with different color schemes, I thought about 
> > perhaps matching the syntax coloring of my editor, BBEdit. However, I'm 
> > sure not all editors use the same color scheme (the ANSI SQL language 
> > module for BBEdit displays only blue (keywords), pink (strings), and 
> > black (everything else). The blue would conflict with the current link 
> > color, and I'd rather not use pink unless everyone else thinks it's a 
> > good idea.) I'm interested in hearing what editors others use for 
> > coding, and what syntax coloring schemes they use for SQL.

I use vim, it has good SQL coloring syntax. The one problem that I'd like
to fix in it is that the body of PL/pgSQL functions are shown as a big
string.

-Roberto

-- 
+|Roberto Mello   -http://www.brasileiro.net/  |--+
+   Computer Science Graduate Student, Utah State University  +
+   USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ +
YES!!  eh, NO!!! oh, well  MAYBE

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings