On Sat, Apr 22, 2006 at 06:18:18PM -0700, Richard Broersma Jr wrote: > > you can reference the following page for ideas: > http://www.postgresql.org/docs/7.4/interactive/client-authentication.html#EXAMPLE-PG-HBA.CONF > > but to get started I would recommend: > " > TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD > local all all trust > > "
Is whitespace important? Tabs? The number of spaces? Is: local all all trust The same as: local all all trust > Let preface the next portion of my reply with the fact that I am not positive > what I am says is > true for Version 7 of postgresql. > > unless you specify otherwise, your log file will be located in your data > directory. > the first one is postgresql.log. > The other log files are located in ../data/pg_log/ [EMAIL PROTECTED] root]# ls /var/lib/pgsql/data/ base pg_clog pg_ident.conf pg_xlog postmaster.opts global pg_hba.conf PG_VERSION postgresql.conf postmaster.pid [EMAIL PROTECTED] root]# ls -la /var/lib/pgsql/data/pg_xlog/ total 16412 drwx------ 2 postgres postgres 4096 Apr 12 17:34 . drwx------ 6 postgres postgres 4096 Apr 22 17:00 .. -rw------- 1 postgres postgres 16777216 Apr 22 17:00 0000000000000000 [EMAIL PROTECTED] root]# file /var/lib/pgsql/data/pg_xlog/0000000000000000 /var/lib/pgsql/data/pg_xlog/0000000000000000: data > One point to be aware of, the type of messages that appear in the depends > upon the setting of you > postgresql.conf file. Ohhhkaaaayyy... so, what settings would be needed to get usable logs? Set everything that has "log" in the name to "true"? -- *********************************************************************** * John Oliver http://www.john-oliver.net/ * * * *********************************************************************** ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
