Fwd: Hast + ZFS + Postgresql on FreeBSD 8.1

2010-08-22 Thread Omer Faruk SEN
-- Forwarded message -- From: Omer Faruk SEN Date: Fri, Aug 20, 2010 at 10:57 PM Subject: Hast + ZFS + Postgresql on FreeBSD 8.1 To: FreeBSD Hi, Is there any one here in this list tried this combo on FreeBSD 8.1 ? I really would like to know your opinions about that

Hast + ZFS + Postgresql on FreeBSD 8.1

2010-08-20 Thread Omer Faruk SEN
Hi, Is there any one here in this list tried this combo on FreeBSD 8.1 ? I really would like to know your opinions about that. Especially I am concerned on how to keep consistency of database and recovery procedures in the event of failure (I mean pgsql recovery or any) Regards.

Re: PostgreSQL on FreeBSD 7.0 amd64 with more than 2GB shared memory

2008-12-11 Thread Ivan Voras
OTECTED] > Sent: Mittwoch, 10. Dezember 2008 18:30 > To: Hell, Robert > Cc: freebsd-questions@freebsd.org > Subject: Re: PostgreSQL on FreeBSD 7.0 amd64 with more than 2GB shared > memory > >> fails again with ENOMEM. >> Is there any easy way to use a shared memory segment

RE: PostgreSQL on FreeBSD 7.0 amd64 with more than 2GB shared memory

2008-12-10 Thread Hell, Robert
: Re: PostgreSQL on FreeBSD 7.0 amd64 with more than 2GB shared memory > fails again with ENOMEM. > Is there any easy way to use a shared memory segment which is larger > than 2GB? getting two smaller ? :) no idea - maybe it's bug of SHM. as you already checked it

Re: PostgreSQL on FreeBSD 7.0 amd64 with more than 2GB shared memory

2008-12-10 Thread Wojciech Puchar
fails again with ENOMEM. Is there any easy way to use a shared memory segment which is larger than 2GB? getting two smaller ? :) no idea - maybe it's bug of SHM. as you already checked it please do sent-pr ___ freebsd-questions@freebsd.org mailing l

PostgreSQL on FreeBSD 7.0 amd64 with more than 2GB shared memory

2008-12-10 Thread Hell, Robert
Hi, I'm trying to run PostgreSQL 8.3 on a FreeBSD 7.0 amd64 server with more than 2GB shared memory. The machine has 32GB RAM installed. After setting kern.ipc.shmmax and kern.ipc.shmall to the appropriate values, I still had no chance to start postgres with more than 2GB of shared memory. I wrot

Re: PostgreSQL on FreeBSD

2003-10-28 Thread Lowell Gilbert
Wayne Pascoe <[EMAIL PROTECTED]> writes: > On Mon, Oct 27, 2003 at 04:04:28PM -0500, Lowell Gilbert wrote: > > >Why does setting them in > > > /etc/sysctl.conf or /etc/loader.conf not work ? > > > > You're doing something wrong. That's all I can s

Re: PostgreSQL on FreeBSD

2003-10-28 Thread Jan Grant
On Tue, 28 Oct 2003, Wayne Pascoe wrote: > On Mon, Oct 27, 2003 at 04:04:28PM -0500, Lowell Gilbert wrote: > > >Why does setting them in > > > /etc/sysctl.conf or /etc/loader.conf not work ? > > > > You're doing something wrong. That's all I can say

Re: PostgreSQL on FreeBSD

2003-10-28 Thread Wayne Pascoe
On Mon, Oct 27, 2003 at 04:04:28PM -0500, Lowell Gilbert wrote: > >Why does setting them in > > /etc/sysctl.conf or /etc/loader.conf not work ? > > You're doing something wrong. That's all I can say when the > description of the failure is just "no

Re: PostgreSQL on FreeBSD

2003-10-27 Thread Lowell Gilbert
I haven't used that software since it was called postgres, but I'll wade in anyway... Wayne Pascoe <[EMAIL PROTECTED]> writes: > Hi all, > > I'm trying to configure and tune postgresql on FreeBSD 4.9. We want to > allow at least 128 concurrent connections but

Re: PostgreSQL on FreeBSD

2003-10-27 Thread Michael L. Squires
> I'm trying to configure and tune postgresql on FreeBSD 4.9. We want to > allow at least 128 concurrent connections but preferably 256. My memory is that there was some extensive discussion of this on the freebsd-databases mailing list, and a search of the archives at lists.freebsd

PostgreSQL on FreeBSD

2003-10-27 Thread Wayne Pascoe
Hi all, I'm trying to configure and tune postgresql on FreeBSD 4.9. We want to allow at least 128 concurrent connections but preferably 256. Looking at the documentation, we should be okay if we set the following in our kernel to achieve this: kern.ipc.somaxconn = 512 kern.ipc.shmall =

Re: MySQL or Postgresql on FreeBSD, have I just started a holy war?

2002-10-02 Thread Thomas T. Veldhouse
e. A cron job would probably fill role nicely. Tom Veldhouse - Original Message - From: "GB Clark" <[EMAIL PROTECTED]> To: "Mailing Lists" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, October 02, 2002 7:05 AM Subject: Re: MySQL or P

Re: MySQL or Postgresql on FreeBSD, have I just started a holy war?

2002-10-02 Thread GB Clark
Hello, I'm a PostgreSQL person so take all my comments with that in mind. On Wed, 2 Oct 2002 03:06:37 -0700 Mailing Lists <[EMAIL PROTECTED]> wrote: > Hi all, > > I've just been getting ready to start serious MySQL development on a > Dual Processor FreeBSD box and I stumbled across the follow

Re: MySQL or Postgresql on FreeBSD, have I just started a holy war?

2002-10-02 Thread Kevin D. Kinsey, DaleCo, S.P.
From: "Roger 'Rocky' Vetterberg" <[EMAIL PROTECTED]> To: "Mailing Lists" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, October 02, 2002 5:52 AM Subject: Re: MySQL or Postgresql on FreeBSD, have I just started a holy war? > Mailing

Re: MySQL or Postgresql on FreeBSD, have I just started a holy war?

2002-10-02 Thread Roger 'Rocky' Vetterberg
Mailing Lists wrote: > Hi all, > > I've just been getting ready to start serious MySQL development on a > Dual Processor FreeBSD box and I stumbled across the following blog > entry on the web today which has me thinking: > > http://jeremy.zawodny.com/blog/archives/000203.html#000203 > > The

MySQL or Postgresql on FreeBSD, have I just started a holy war?

2002-10-02 Thread Mailing Lists
Hi all, I've just been getting ready to start serious MySQL development on a Dual Processor FreeBSD box and I stumbled across the following blog entry on the web today which has me thinking: http://jeremy.zawodny.com/blog/archives/000203.html#000203 The coles notes version is that the author,