Re: [GENERAL] PostgreSQL vs FreeBSD 7.0 as regular user
In article <[EMAIL PROTECTED]>, Greg Smith <[EMAIL PROTECTED]> wrote: % Looks like the PostgreSQL documentation here ( % http://www.postgresql.org/docs/current/static/kernel-resources.html ) is % now outdated. From http://www.manpages.info/freebsd/sysctl.8.html : % % "The -w option has been deprecated and is silently ignored." % % Looks like the correct thing to do here now is to edit the % /etc/sysctl.conf file, then issue: % % /etc/rc.d/sysctl reload I guess this would work, but you can still change variables from the command-line. It's just that -w isn't required any more (i.e., the same command works with or without the -w flag). I'm not sure the docs should change, since -w is still required at least on NetBSD. -- Patrick TJ McPhee North York Canada [EMAIL PROTECTED] -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PostgreSQL vs FreeBSD 7.0 as regular user
On Friday 25 July 2008, Zoltan Boszormenyi wrote: > is there anyone using PostgreSQL on FreeBSD 7.0 starting from scratch? Every day. > I compiled 8.3.3 and wanted to run initdb in my home directory but > it fails with the error below. How did you install PostgreSQL? -- Kirk Strauser Daycos -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PostgreSQL vs FreeBSD 7.0 as regular user
Greg Smith wrote: On Sat, 26 Jul 2008, Zoltan Boszormenyi wrote: Zoltan Boszormenyi �rta: These three settings were also set with "sysctl -w ..." to take effect immediately. Rebooting FreeBSD solved it. Huh? Is it really like W#&@$#&? Looks like the PostgreSQL documentation here ( http://www.postgresql.org/docs/current/static/kernel-resources.html ) is now outdated. From http://www.manpages.info/freebsd/sysctl.8.html : "The -w option has been deprecated and is silently ignored." It's not ignored as in "the whole command will have no effect". Only the switch itself is ignored. So, sysctl -w a.b=c is 100% equivalent to sysctl a.b=c Looks like the correct thing to do here now is to edit the /etc/sysctl.conf file, then issue: /etc/rc.d/sysctl reload to use those values without needing to reboot. (I don't actually have such a machine to check for sure). Yes, that will work. Sysctl.conf will not reload itself :) signature.asc Description: OpenPGP digital signature
Re: [GENERAL] PostgreSQL vs FreeBSD 7.0 as regular user
Zoltan Boszormenyi írta: > Joshua D. Drake írta: > >> On Fri, 2008-07-25 at 22:39 +0200, Zoltan Boszormenyi wrote: >> >> >>> Hi, >>> >>> is there anyone using PostgreSQL on FreeBSD 7.0 starting from scratch? >>> I compiled 8.3.3 and wanted to run initdb in my home directory but >>> it fails with the error below. >>> >>> >> >> >>> I configured the shared memory settings in advance according to >>> the PostgreSQL 8.3 online docs: >>> >>> $ cat /etc/sysctl.conf >>> ... >>> kern.ipc.shmall=32768 >>> kern.ipc.shmmax=134217728 >>> kern.ipc.semmap=256 >>> >>> These three settings were also set with "sysctl -w ..." to take effect >>> immediately. >>> >>> >> Are you buy chance in a jail? >> >> Joshua D. Drake >> >> > > I don't know. How to determine? Running this as my own user: > $ sysctl -a | grep "^kern.ipc" > shows the same settings as above. > > Thanks. > Rebooting FreeBSD solved it. Huh? Is it really like W#&@$#&? Anyway, thanks for the help. -- -- Zoltán Böszörményi Cybertec Schönig & Schönig GmbH http://www.postgresql.at/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PostgreSQL vs FreeBSD 7.0 as regular user
Francisco Reyes írta: > On 4:53 pm 07/25/08 Zoltan Boszormenyi <[EMAIL PROTECTED]> wrote: > >> I don't know. How to determine? Running this as my own user: >> > > Is this your own machine or at an ISP? > It's my own machine, FreeBSD is installed as a VMWare guest. > If it is your own machine, then most likely you are not in a jail. You > would know if you were since you would have had to do it. > > If at an ISP once way to know if you are in a jail I think is to try to > ping and traceroute. > > I think by default you can't do one of those within a jail. > Also try ifconfig. A jail will show you a single IP. A "real" machine will > show you usually at least two. 127.0.0.1 and some other address. > -- -- Zoltán Böszörményi Cybertec Schönig & Schönig GmbH http://www.postgresql.at/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PostgreSQL vs FreeBSD 7.0 as regular user
On 4:53 pm 07/25/08 Zoltan Boszormenyi <[EMAIL PROTECTED]> wrote: > I don't know. How to determine? Running this as my own user: Is this your own machine or at an ISP? If it is your own machine, then most likely you are not in a jail. You would know if you were since you would have had to do it. If at an ISP once way to know if you are in a jail I think is to try to ping and traceroute. I think by default you can't do one of those within a jail. Also try ifconfig. A jail will show you a single IP. A "real" machine will show you usually at least two. 127.0.0.1 and some other address. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PostgreSQL vs FreeBSD 7.0 as regular user
Joshua D. Drake írta: > On Fri, 2008-07-25 at 22:39 +0200, Zoltan Boszormenyi wrote: > >> Hi, >> >> is there anyone using PostgreSQL on FreeBSD 7.0 starting from scratch? >> I compiled 8.3.3 and wanted to run initdb in my home directory but >> it fails with the error below. >> > > >> I configured the shared memory settings in advance according to >> the PostgreSQL 8.3 online docs: >> >> $ cat /etc/sysctl.conf >> ... >> kern.ipc.shmall=32768 >> kern.ipc.shmmax=134217728 >> kern.ipc.semmap=256 >> >> These three settings were also set with "sysctl -w ..." to take effect >> immediately. >> > > Are you buy chance in a jail? > > Joshua D. Drake > I don't know. How to determine? Running this as my own user: $ sysctl -a | grep "^kern.ipc" shows the same settings as above. Thanks. -- -- Zoltán Böszörményi Cybertec Schönig & Schönig GmbH http://www.postgresql.at/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] PostgreSQL vs FreeBSD 7.0 as regular user
On Fri, 2008-07-25 at 22:39 +0200, Zoltan Boszormenyi wrote: > Hi, > > is there anyone using PostgreSQL on FreeBSD 7.0 starting from scratch? > I compiled 8.3.3 and wanted to run initdb in my home directory but > it fails with the error below. > I configured the shared memory settings in advance according to > the PostgreSQL 8.3 online docs: > > $ cat /etc/sysctl.conf > ... > kern.ipc.shmall=32768 > kern.ipc.shmmax=134217728 > kern.ipc.semmap=256 > > These three settings were also set with "sysctl -w ..." to take effect > immediately. Are you buy chance in a jail? Joshua D. Drake -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ United States PostgreSQL Association: http://www.postgresql.us/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general