Hi all,
after installing Postgres7.3.3 on a RedHat 9.0 box ( I used the rpm ) I was
looking for
contrib/adddepend but is nowhere :-(
Am I missing something?
> locate adddepend
/usr/share/doc/postgresql-contrib-7.3.3/README.adddepend
no trace of the script!!!
Thank you in advance
Gaetano
---
i have followed the examples in README.tsearch about converting text columns to
txtidx type using the function txt2txidx() . Problem is.. some words become
chopped. "Database for dummies" becomes 'dummi' 'databas' , for example.
whats goin on here. anything i missed? i also created a trigge
Set
log_statement = true
in your postgresql.conf file, then stop & restart the postmaster.
Queries will be printed in the postmaster's output (or via syslog, if
you're using that).
See
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=runtime-config.html#LOGGING
for details.
In your postgresql.conf file (on my system this is /etc/postgresql.conf -
don't know how standard that is) insert the following line:
debug_print_query = on
then restart the postmaster (again, on my system: /etc/init.d/postgresql
restart) and you'll be on your way. It ends up in the general
postg
Hello,
I am wondering if somebody can help me. I want to know if there is a
way that I can make some kind of a log file of all of the SQL statements that
are used in my database. It was suggested to make that I could make a trace
of them and I am not sure how to do that.
I have i
