> What is the version of postgresql and freebsd you are using?
postgresql client and server v. 9.2.2. If all else fails I could try downgrading to a previous version of postgres.
FreeBSD 8.3-RELEASE-p5
> I am getting a different output while running > the initdb command through the rc script, and it's not using the -D path to > initialize the cluster, it falls back to the default location > /usr/local/pgsql/data . Setting postgresql_data="/usr/local/pgsql1/data" > in /etc/rc.conf makes it initialize at the right location . I did not had > to mess with an permissions and the rc commands were all run as root. The > above was tested on FreeBSD 9.1 with Postgresql 9.2 on UFS.
I didn't have any luck with the rc script but I was able to use it to get a ktrace dump as root (ktrace as user pgsql doesn't seem to work). So hopefully that will show something(!)
David
If it helps, my versions were FreeBSD 8.1 + PG 9.0.5 using UFS on a dedicated server and FreeBSD 9.1 (available on FTP sites but not announced yet) + PG 9.2.2 using UFS on a virtual box instance. Looks like ZFS is the only major variable here.
