Re: FreeBSD Port: postgresql-server-8.4.8_1

2011-06-14 Thread Palle Girgensohn
14 jun 2011 kl. 06.34 skrev John Bleichert: > > On Jun 13, 2011, at 4:31 PM, Christer Solskogen wrote: > >> On Mon, Jun 13, 2011 at 8:07 PM, John Bleichert wrote: >> >>> Suggestions? Shall I hit the postgresql forums? I thought I'd ask here >>> first. >>> >> >> This is in a jail, right? >>

Re: FreeBSD Port: postgresql-server-8.4.8_1

2011-06-14 Thread Palle Girgensohn
13 jun 2011 kl. 20.07 skrev John Bleichert: > creating template1 database in /usr/local/pgsql/data/base/1 ... child process > was terminated by signal 12: Bad system call > initdb: removing contents of data directory "/usr/local/pgsql/data" > $ exit > boogie:/var/log uname -a > FreeBSD boogie 8.

Re: FreeBSD Port: postgresql-server-8.4.8_1

2011-06-13 Thread John Bleichert
On Jun 13, 2011, at 4:31 PM, Christer Solskogen wrote: > On Mon, Jun 13, 2011 at 8:07 PM, John Bleichert wrote: > >> Suggestions? Shall I hit the postgresql forums? I thought I'd ask here >> first. >> > > This is in a jail, right? > Try adding this to /etc/sysctl.conf: > security.jail.sysvipc

Re: FreeBSD Port: postgresql-server-8.4.8_1

2011-06-13 Thread Christer Solskogen
On Mon, Jun 13, 2011 at 8:07 PM, John Bleichert wrote: > Suggestions? Shall I hit the postgresql forums? I thought I'd ask here > first. > This is in a jail, right? Try adding this to /etc/sysctl.conf: security.jail.sysvipc_allowed=1 And/or run "sysctl security.jail.sysvipc_allowed=1 as root on

Re: FreeBSD Port: postgresql-server-8.4.8_1

2011-06-13 Thread Andrea Venturoli
On 06/13/11 20:07, John Bleichert wrote: Suggestions? Shall I hit the postgresql forums? I thought I'd ask here first. Did you check the logs? I.e. /usr/local/pgsql/data/postmaster.log, /var/log/all.log or whatever you set. There might be other info there... Did you read pkg_message and a

FreeBSD Port: postgresql-server-8.4.8_1

2011-06-13 Thread John Bleichert
Hello, I'm getting a bad system call error (and a core file) when I try to initdb: boogie:/var/log mkdir /usr/local/pgsql/data boogie:/var/log chown pgsql /usr/local/pgsql/data boogie:/var/log su - pgsql $ /usr/local/bin/initdb -D /usr/local/pgsql/data The files belonging to this database sy