Fwd: Hast + ZFS + Postgresql on FreeBSD 8.1

2010-08-22 Thread Omer Faruk SEN
-- Forwarded message -- From: Omer Faruk SEN omerf...@gmail.com Date: Fri, Aug 20, 2010 at 10:57 PM Subject: Hast + ZFS + Postgresql on FreeBSD 8.1 To: FreeBSD freebsd-questions@freebsd.org Hi, Is there any one here in this list tried this combo on FreeBSD 8.1 ? I really would

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
, 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 which is larger than 2GB? getting two smaller

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

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

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

2008-12-10 Thread Hell, Robert
: 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 please do sent-pr

PostgreSQL 8.0.3 + FreeBSD + TCP/IP

2005-06-14 Thread Joseph Koenig (jWeb)
Hi, I'm having a difficulty getting PostgreSQL to accept TCP/IP connections on FreeBSD 5.3. I have edited 'postgresql.conf' in my postgres data directory to set the listen_address (and uncommented it) and have the port line uncommented and set to the default 5432. I then restarted the postmaster

Re: PostgreSQL 8.0.3 + FreeBSD + TCP/IP

2005-06-14 Thread Kalashnikov Ilya
On Tue, 2005-06-14 at 10:05 -0500, Joseph Koenig (jWeb) wrote: Hi, I'm having a difficulty getting PostgreSQL to accept TCP/IP connections on FreeBSD 5.3. I have edited 'postgresql.conf' in my postgres data directory to set the listen_address (and uncommented it) and have the port line

Re: PostgreSQL 8.0.3 + FreeBSD + TCP/IP

2005-06-14 Thread Joseph Koenig (jWeb)
Hi, I'm having a difficulty getting PostgreSQL to accept TCP/IP connections on FreeBSD 5.3. I have edited 'postgresql.conf' in my postgres data directory to set the listen_address (and uncommented it) and have the port line uncommented and set to the default 5432. I then restarted the

Re: PostgreSQL 8.0.3 + FreeBSD + TCP/IP

2005-06-14 Thread Kalashnikov Ilya
On Tue, 2005-06-14 at 10:05 -0500, Joseph Koenig (jWeb) wrote: Hi, I'm having a difficulty getting PostgreSQL to accept TCP/IP connections on FreeBSD 5.3. I have edited 'postgresql.conf' in my postgres data directory to set the listen_address (and uncommented it) and have the port line

Re: PostgreSQL 8.0.3 + FreeBSD + TCP/IP

2005-06-14 Thread Jonathan Chen
On Tue, Jun 14, 2005 at 10:05:05AM -0500, Joseph Koenig (jWeb) wrote: Hi, I'm having a difficulty getting PostgreSQL to accept TCP/IP connections on FreeBSD 5.3. I have edited 'postgresql.conf' in my postgres data directory to set the listen_address (and uncommented it) and have the port

Re: PostgreSQL 8.0.3 + FreeBSD + TCP/IP

2005-06-14 Thread Joseph Koenig (jWeb)
On Tue, Jun 14, 2005 at 10:05:05AM -0500, Joseph Koenig (jWeb) wrote: Hi, I'm having a difficulty getting PostgreSQL to accept TCP/IP connections on FreeBSD 5.3. I have edited 'postgresql.conf' in my postgres data directory to set the listen_address (and uncommented it) and have the port

Re: PostgreSQL 8.0.3 + FreeBSD + TCP/IP

2005-06-14 Thread Andrew L. Gould
On Tuesday 14 June 2005 03:14 pm, Joseph Koenig (jWeb) wrote: On Tue, Jun 14, 2005 at 10:05:05AM -0500, Joseph Koenig (jWeb) wrote: Hi, I'm having a difficulty getting PostgreSQL to accept TCP/IP connections on FreeBSD 5.3. I have edited 'postgresql.conf' in my postgres data directory

Re: PostgreSQL 8.0.3 + FreeBSD + TCP/IP

2005-06-14 Thread Joseph Koenig (jWeb)
On Tuesday 14 June 2005 03:14 pm, Joseph Koenig (jWeb) wrote: On Tue, Jun 14, 2005 at 10:05:05AM -0500, Joseph Koenig (jWeb) wrote: Hi, I'm having a difficulty getting PostgreSQL to accept TCP/IP connections on FreeBSD 5.3. I have edited 'postgresql.conf' in my postgres data directory to

Re: PostgreSQL 8.0.3 + FreeBSD + TCP/IP

2005-06-14 Thread Ken Ebling
On Jun 14, 2005, at 4:46 PM, Joseph Koenig (jWeb) wrote: I'm guessing that opening the port is part of what placing postgresql_enable=YES in the rc.conf file does, correct? If so, that's probably the problem as I have not rebooted since adding that. Is there a way to safely force that to

Re: PostgreSQL 8.0.3 + FreeBSD + TCP/IP

2005-06-14 Thread Lane Holcombe
On Tuesday 14 June 2005 15:14, Joseph Koenig (jWeb) wrote: On Tue, Jun 14, 2005 at 10:05:05AM -0500, Joseph Koenig (jWeb) wrote: Hi, I'm having a difficulty getting PostgreSQL to accept TCP/IP connections on FreeBSD 5.3. I have edited 'postgresql.conf' in my postgres data directory to

Re: PostgreSQL 8.0.3 + FreeBSD + TCP/IP (Solved)

2005-06-14 Thread Joseph Koenig (jWeb)
On Jun 14, 2005, at 4:46 PM, Joseph Koenig (jWeb) wrote: I'm guessing that opening the port is part of what placing postgresql_enable=YES in the rc.conf file does, correct? If so, that's probably the problem as I have not rebooted since adding that. Is there a way to safely force that to

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 not work.

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 when the

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 say when the

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 = 65536

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.org should

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 preferably 256. Looking

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

2002-10-02 Thread Mailing Lists
like this will potentially be an issue, how does Postgresql perform on FreeBSD. I could use it just as easily as MySQL and, from what I've heard, it's a little beefier in some aspects. With regards to threading issues, am I likely to be happier with Postgresql in the long term? Our current DB

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

2002-10-02 Thread Roger 'Rocky' Vetterberg
will be a limiting factor. My second question is, if it looks like this will potentially be an issue, how does Postgresql perform on FreeBSD. I could use it just as easily as MySQL and, from what I've heard, it's a little beefier in some aspects. With regards to threading issues, am I likely

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

2002-10-02 Thread Kevin D. Kinsey, DaleCo, S.P.
' 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 Lists wrote: Hi all, I've just been getting ready to start serious MySQL

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

2002-10-02 Thread GB Clark
is actually an iMac, it's a long story, with a 400Mhz G3 and 512 mb RAM running OS X 10.2 and keeping up quite nicely, so I don't imagine the hardware itself will be a limiting factor. My second question is, if it looks like this will potentially be an issue, how does Postgresql perform on FreeBSD

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

2002-10-02 Thread Thomas T. Veldhouse
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 Postgresql on FreeBSD, have I just started a holy war? Hello