On Fri, Dec 14, 2012 at 4:28 PM, David Noel <david.i.n...@gmail.com> wrote:
> > Did you use ports to install postgresql? > > Yes > > > 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. Amitabh
