Re: initdb error

On Fri, Dec 14, 2012 at 4:28 PM, David Noel <david(dot)i(dot)noel(at)gmail(dot)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