Hey Garrett,
thanks for coming back to me.
1. I had make clean before I did make install clean.
2.
$ ./configure --with-libraries=/usr/local/lib
--with-includes=/usr/local/include --enable-thread-safety --with-openssl
--enable-dtrace --with-pam --enable-nls --prefix=/usr/local
--mandir=/usr/local/man --infodir=/usr/local/info/
--build=amd64-portbld-freebsd9.0
uname -v = FreeBSD 9.0-CURRENT #0: Fri Oct 8 21:09:20 UTC 2010
root@freebsd9:/usr/obj/usr/src/sys/DTRACE
configure:2820: checking for dtrace
configure:2836: found /usr/sbin/dtrace
configure:2847: result: dtrace
| #define ENABLE_DTRACE 1
ac_cv_prog_DTRACE=dtrace
DTRACE='dtrace'
DTRACEFLAGS=''
configure_args=' '\''--with-libraries=/usr/local/lib'\''
'\''--with-includes=/usr/local/include'\'' '\''--enable-thread-safety'\''
'\''--with-openssl'\'' '\''--enable-dtrace'\'' '\''--with-pam'\''
'\''--enable-nls'\'' '\''--prefix=/usr/local'\''
'\''--mandir=/usr/local/man'\'' '\''--infodir=/usr/local/info/'\''
'\''--build=amd64-portbld-freebsd9.0'\''
'\''build_alias=amd64-portbld-freebsd9.0'\'' '\''CC=cc'\'' '\''CFLAGS=-O2
-pipe -fno-omit-frame-pointer -fno-strict-aliasing'\'' '\''LDFLAGS=
-L/usr/local/lib -rpath=/usr/lib:/usr/local/lib -lelf -L/usr/local/lib'\''
'\''CPPFLAGS=-I/usr/local/include'\'''
enable_dtrace='yes'
#define ENABLE_DTRACE 1
The server is running:
[root@freebsd9/usr/ports/databases/postgresql90-server/work/postgresql-9.0.1]#
ps aux |
grep post
pgsql 86977 0.0 1.0 61992 9984 ?? Ss 10:01PM 0:00.97
/usr/local/bin/postgres -D /usr/local/pgsql/data
pgsql 86979 0.0 1.0 61992 10004 ?? Rs 10:01PM 0:06.48 postgres:
writer process (postgres)
pgsql 86980 0.0 1.0 61992 10004 ?? Rs 10:01PM 0:03.44 postgres:
wal writer process (postgres)
pgsql 86981 0.0 1.0 61992 10880 ?? Ss 10:01PM 0:00.99 postgres:
autovacuum launcher process (postgres)
pgsql 86982 0.0 0.8 24896 8056 ?? Ss 10:01PM 0:00.56 postgres:
stats collector process (postgres)
According to the manual:
http://www.postgresql.org/docs/8.2/static/dynamic-trace.html
[root@freebsd9/usr/ports/databases/postgresql90-server/work/postgresql-9.0.1]#
ls
src/include/pg_trace.h
This file is there.
But I can't see the probes in the list:
dtrace -l | grep -i postgres
Further info:
[root@freebsd9 ~]# /usr/local/etc/rc.d/postgresql restart
dtrace DOF postgres: DTrace ioctl failed for DOF at 0x801c35000: Invalid
argument
Any time I would like to start dtrace on the servers pid the daemon is
crashing wo/ any log.
I.
On Mon, Oct 18, 2010 at 11:48 PM, Garrett Cooper <gcooper@freebsd.org>wrote: