Hi all,
I'm looking at a project that I'm trying to run on openbsd. All that
box will have is postgresql. At this time, it's just 2 programmers
and 1 sysadmin type person that's involved, no DBAs, so apologies if
the questions are... too simplistic.
And I realize i
Hi Misc,
Is anybody running Gogs
https://gogs.io/
in production on OpenBSD using PostgreSQL as a backend. Any chance to
share the installation/configuration notes with me?
Predrag
On Thu, Aug 07, 2008 at 12:28:56AM -0400, bofh wrote:
> I'm looking at a project that I'm trying to run on openbsd. All that
> box will have is postgresql. At this time, it's just 2 programmers
> and 1 sysadmin type person that's involved, no DBAs, so apologies
bofh wrote:
Hi all,
I'm looking at a project that I'm trying to run on openbsd. All that
box will have is postgresql. At this time, it's just 2 programmers
and 1 sysadmin type person that's involved, no DBAs, so apologies if
the questions are... too simplistic.
And I
* bofh <[EMAIL PROTECTED]> [080807 00:32]:
> Hi all,
> I'm looking at a project that I'm trying to run on openbsd. All that
> box will have is postgresql. At this time, it's just 2 programmers
> and 1 sysadmin type person that's involved, no DBAs, so a
On Thu, Aug 7, 2008 at 9:48 AM, Jim Razmus <[EMAIL PROTECTED]> wrote:
> If your project is big enough to demand 16 cpus and that much RAM, you
> should be able to afford a DBA.
Yes. I agree. And when it gets to that point, I will have a dba. But I am
a worrier, and would like to get started e
Hello,
We run PostgreSQL 8.3 on a Dell PE 2950 III w/ 4G RAM, 15krpm SAS
disks running from mfi(4) and quad core Xeon - all under
OpenBSD-current/amd64 of course. Oh and we are running
GENERIC.MP.
I suppose the database is reasonably large at this stage, around
55 million rows or 10G on disk
. All that
> box will have is postgresql. At this time, it's just 2 programmers
> and 1 sysadmin type person that's involved, no DBAs, so apologies if
> the questions are... too simplistic.
>
> And I realize if I want to maximize performance, I need to examine
> OSes as w
On Thu, Aug 7, 2008 at 1:23 PM, Niall O'Higgins <[EMAIL PROTECTED]>wrote:
> Oh, also note that OpenBSD has some limit on how much memory an
> individual process can map, so keep that in mind. While the
> kernel may be able to use all 128G of memory in your machine,
>
On Fri, Aug 08, 2008 at 12:52:35PM -0400, bofh wrote:
> Ah, great! Yes, this is the question I was trying to ask - what is the
> largest available chunk of memory available to any one process?
I think MAXDSIZ may have been bumped to 8G on amd64, I haven't
tested any limits myself yet though.
--
On Sun, Aug 10, 2008 at 01:29:12PM -0700, Niall O'Higgins wrote:
| On Fri, Aug 08, 2008 at 12:52:35PM -0400, bofh wrote:
| > Ah, great! Yes, this is the question I was trying to ask - what is the
| > largest available chunk of memory available to any one process?
|
| I think MAXDSIZ may have been
Sorry if this is the wrong list, I debated whether to post it to ports
but as it is not a problem with the port itself and is more a user
problem (i.e I'm being stupid :)) I thought misc was probably more
appropriate.
Anyway I've been trying to get PostgreSQL setup on my 4.3 b
some time in the (near?) future I will update our port
of the PostgreSQL database to version 8.2.x. We currently
have version 8.1.x in the tree, so the update will require
you to do a database dump prior to the update and a restore
after it.
please make sure to read the release notes at
http
Am 25.03.2016 um 02:45 schrieb Predrag Punosevac:
Hi Misc,
Is anybody running Gogs
https://gogs.io/
in production on OpenBSD using PostgreSQL as a backend. Any chance to
share the installation/configuration notes with me?
Predrag
Just compile it using the documentation. You don't ha
ot;
rc_reload=NO
rc_cmd $1
> On 2016-03-25, at 20:18, Markus Hennecke
wrote:
>
> Am 25.03.2016 um 02:45 schrieb Predrag Punosevac:
>> Hi Misc,
>>
>> Is anybody running Gogs
>>
>> https://gogs.io/
>>
>> in production on OpenBSD using Postgre
Hi,
Predrag Punosevac wrote:
> Hi Misc,
>
> Is anybody running Gogs
>
> https://gogs.io/
>
> in production on OpenBSD using PostgreSQL as a backend. Any chance to
> share the installation/configuration notes with me?
Here are my notes (for both mariadb and postgre
Hi
I like OpenBSD very much but:
I have not proper sorts in my PostgreSQL 8.1 database on my OpenBSD 4.0
server.
I had set in /etc/profile the LC_COLLATE to pl_PL.ISO8859-2.
The PostgreSQL cluster was created by command:
initdb --locale=pl_PL.ISO8859-2 -E LATIN2 --lc-messages=C --lc-monetary
was probably
> more appropriate.
>
> Anyway I've been trying to get PostgreSQL setup on my 4.3 box and
> I'm not having much luck at all. I've followed the instructions in
> README.OpenBSD but I think I am missing something very simple here.
> Any help would be greatly a
Simon Connah wrote:
Sorry if this is the wrong list, I debated whether to post it to ports
but as it is not a problem with the port itself and is more a user
problem (i.e I'm being stupid :)) I thought misc was probably more
appropriate.
Anyway I've been trying to get PostgreSQL s
bly more appropriate.
>
> Anyway I've been trying to get PostgreSQL setup on my 4.3 box and I'm not
> having much luck at all. I've followed the instructions in README.OpenBSD
> but I think I am missing something very simple here. Any help would be
> greatly appreciat
Simon Connah wrote:
Sorry if this is the wrong list, I debated whether to post it to ports
but as it is not a problem with the port itself and is more a user
problem (i.e I'm being stupid :)) I thought misc was probably more
appropriate.
Anyway I've been trying to get PostgreSQL s
Does the ADDRESS keyword "samenet" work in OpenBSD's PostgreSQL pg_hba.conf?
Manually specifying an address block works, as does a DNS hostname &
domain name.
$ pkg_info -I postgresql-server
postgresql-server-9.2.3 PostgreSQL RDBMS (server)
$ uname -a
OpenBSD oak.britvault.c
I've currently got a server running syslog-ng (1.6.9) with PostgreSQL
(8.1.1) on a 3.9 snapshot from March 1. The setup has been working well
for a while, but I've recently been told to have it accept syslog for a
couple of anti-spam appliance devices, and they generate between 1-
On 4/5/06, David T Harris <[EMAIL PROTECTED]> wrote:
> Just out of curiosity why did your company decide
> to go with Postgresql as opposed to mysql?
> Just somewhat curious considering you see mysql
> everywhere these days...
hi David -
The first half of this post says
Hi!
There was a commit today which updates postgresql to version 8.1.5. This
fix made it to the stable branch too, so will there be a package for
it, or I have to compile it from ports?
I don't really understand how this updating process work yet, so just
forgive (but not ignore :) me, i
Hi,
The warnings below always appear while linking c files with
postgresql-libpq on SPARC64 platform. Arm64 and i386 platforms don't
display these errors.
/usr/local/lib/libpq.a(fe-auth.o): In function `PQencryptPasswordConn':
fe-auth.c:(.text+0x284): warning: strcpy() is almost alwa
Hi,
I am trying to use PostgreSQL as a backend for my Postfix virtual mail
system and dovecot(psql) for smtp-auth.
'Postfix' is chrooted - most of it - and with MySQL socket there is no
problem to auth users and use Postfix
transport_maps and virtual_*_maps. I have problem with
I see there is a postfix flavour for mysql but not for postgresql. Is this
combination used much? I already have a PGSQL server and I want to plug
postfix into it for virtual mailbox domains.
Thanks for any advice.
Peter
On Jun 24, 2007, at 1:41 PM, bsd_news wrote:
Hi
I like OpenBSD very much but:
I have not proper sorts in my PostgreSQL 8.1 database on my OpenBSD
4.0
server.
I had set in /etc/profile the LC_COLLATE to pl_PL.ISO8859-2.
The PostgreSQL cluster was created by command:
initdb --locale
On 6/24/07, bsd_news <[EMAIL PROTECTED]> wrote:
...
I have not proper sorts in my PostgreSQL 8.1 database on my OpenBSD 4.0
server.
I had set in /etc/profile the LC_COLLATE to pl_PL.ISO8859-2.
...
I do not know is there possibility to fix this problem - maybe OpenBSD now
support only
Hi Ben,
than You for answer. My PostgreSQL instance works fine. The problem is
in OpenBSD unfortunately. PostgreSQL uses COLLATION support served by
operating system and default BSD has C and POSSIX COLLATION. I am looking
for solution for this problem. I need native support for polish
re OpenBSD Developers change the COLLATION
support or someone know solution for this problem.
Best regards,
Artur
On Sun, 24 Jun 2007 21:07:56 -0600, "Philip Guenther" <[EMAIL PROTECTED]>
wrote:
> On 6/24/07, bsd_news <[EMAIL PROTECTED]> wrote:
> ...
>>
On Mon, Jun 25, 2007 at 11:50:10AM +0200, Artur Litwinowicz wrote:
> Hi Philip,
>thank You match for answer and nice words :).
> I am starting be concern for my problem but my "love" for OpenBSD is
> stronger then sort problems (data on my web are sorted not correctly) and I
> do not want to c
O I think it is not good idea to change the code of OpenBSD by me.
Years ago I was coding in C++ (at the University but with best mark ;). Now
I am working for Oracle Corp. (PL/SQL and etc.) and I am a little out of
practice ;) with C/C++.
Maybe someone core OpenBSD Developer will agree with
ce ;) with C/C++.
>
> Maybe someone core OpenBSD Developer will agree with me, that the extended
> COLLATION in OpenBSD will be the strong point in the system functionality ?
>
I had the same problem with PostgreSQL on OpenBSD a few years ago and
I've written some C-language e
> functionality ?
>>
>
> I had the same problem with PostgreSQL on OpenBSD a few years ago and
> I've written some C-language extensions (database functions). Be
> advised that this is a totally non-standard solution. Here you go:
>
> The idea was to make simp
I'm not getting something about the best way to set up a server using
PostgreSQL as a backend for a busy web server running drupal.
The postgresql performance tuning folks
http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
say that in a server with more that 1GB of ra
I am trying to replace mysql with postgresql on my openbsd + apache +php
server.
I need to install postgresql from source, as I need special options, and the
latest version.
I am runnning openbsd 4.5, php 5.2.8 from packages,
postgresql-8.4.2 from source. All dependencies from packages
No?
On 2013-10-02 Wed 18:06 PM |, Craig R. Skinner wrote:
> Does the ADDRESS keyword "samenet" work in OpenBSD's PostgreSQL pg_hba.conf?
>
> Manually specifying an address block works, as does a DNS hostname &
> domain name.
>
> $ pkg_info -I postgr
Question: Is there any really outstanding reason why a suitably-
licensed database or fork thereof, e.g. PostgreSQL, couldn't be fully
integrated into the OpenBSD distribution? Alternately, is there any
reason why a small-scale SQLish database couldn't be implemented for
OpenBSD? (
This may be off topic, if so, I will take it elsewhere.
That said, I am getting the following error when I start up PostgreSQL
on 3.8 (installed via packages):
LOG: could not bind IPv4 socket: Can't assign requested address
HINT: Is another postmaster already running on port 5432? If not,
On 3/22/06, Steve Shockley <[EMAIL PROTECTED]> wrote:
> I've currently got a server running syslog-ng (1.6.9) with PostgreSQL
> (8.1.1) on a 3.9 snapshot from March 1. The setup has been working well
> for a while, but I've recently been told to have it accept syslog fo
* Steve Shockley <[EMAIL PROTECTED]> [060322 21:35]:
> I've currently got a server running syslog-ng (1.6.9) with PostgreSQL
> (8.1.1) on a 3.9 snapshot from March 1. The setup has been working well
> for a while, but I've recently been told to have it accept syslog for
On Thursday 23 March 2006 10:26, Steve Shockley wrote:
> Any query which needs to iterate the whole database will
> take 10-15 minutes after a day or so, and that's no good for a web
> front-end.
The first order of business should be to get rid of these kind of queries.
---
Lars Hansson
Steve Shockley wrote:
I've currently got a server running syslog-ng (1.6.9) with PostgreSQL
(8.1.1) on a 3.9 snapshot from March 1. The setup has been working
well for a while, but I've recently been told to have it accept syslog
for a couple of anti-spam appliance devices, and the
Jim Razmus wrote:
> * Steve Shockley <[EMAIL PROTECTED]> [060322 21:35]:
> > I've currently got a server running syslog-ng (1.6.9) with
> > PostgreSQL (8.1.1) on a 3.9 snapshot from March 1. The setup has
> > been working well for a while, but I've recently b
On Thu, Apr 06, 2006 at 01:05:43PM -0700, Miles Keaton wrote:
> On 4/5/06, David T Harris <[EMAIL PROTECTED]> wrote:
> > Just out of curiosity why did your company decide
> > to go with Postgresql as opposed to mysql?
> > Just somewhat curious considering you see mysq
(though that
> has apparently improved quite a bit in the 5.x series), and less
> 'nonstandard extensions'.
Yep to the above.
PostgreSQL has:
*) foriegn keys
*) supports ANSII SQL
*) Full ACIDity
*) supports views (sort of like symbolic links to entire tables, joins,
etc)
MySQL is a wee
>>>>> "Craig" == Craig Skinner <[EMAIL PROTECTED]> writes:
Craig> MySQL is a wee bit faster,
I keep seeing this, but I sometimes see the opposite. That "MySQL is faster"
meme seems peristent though, as if the PostgreSQL want to provide *some*
ju
Randal L. Schwartz wrote:
Craig> MySQL is a wee bit faster,
I keep seeing this, but I sometimes see the opposite. That "MySQL is faster"
meme seems peristent though, as if the PostgreSQL want to provide *some*
justification for people to continue to have a reason for MySQL.
Give
Randal L. Schwartz wrote:
I keep seeing this, but I sometimes see the opposite. That "MySQL is faster"
meme seems peristent though, as if the PostgreSQL want to provide *some*
justification for people to continue to have a reason for MySQL.
MySQL is perhaps slightly faster
rather
> > use something with a working foreign key implementation (though that
> > has apparently improved quite a bit in the 5.x series), and less
> > 'nonstandard extensions'.
>
> Yep to the above.
>
> PostgreSQL has:
>
> *) foriegn keys
>
On 06 Apr 2006 18:12:59 -0700, Randal L. Schwartz wrote:
> Given the cost of programmer time (and the cost of lost data) vs the
> cost of a slightly faster processor, is it ever really worth it even
> if MySQL is *twice* as fast?
Yes.
Example 1: I feel like digging through some data that will be
to a file system. Actually very perceptive. You can use the filesytem
to move stuff around and get away with it very nicesly.
As to losing data, I suspect you'd lose a lot more
from PostgreSQL than MySQL on a failing hard drive.
At 01:08 PM 4/7/06, [EMAIL PROTECTED] wrote:
As to losing data, I suspect you'd lose a lot more
from PostgreSQL than MySQL on a failing hard drive.
And I suspect that if you place WAL files on different disk than the
database, that the opposite is true.
On 4/7/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> As to losing data, I suspect you'd lose a lot more
> from PostgreSQL than MySQL on a failing hard drive.
Any particular reason for that suspicion? I ask out of genuine
interest, and I promise I don't want to start a flame war.
-Josh
ng to say. Keep going and minimize
damage? How would you do that when your fields are too small? And what has
this got to do with PostgreSQl v.s mySql anyway?
> This is what systems that face the "real world" are forced to do.
Are you saying that "real" RDBMS' arent
al RDBMS keeps your well designed data consistent and safe, that's
the point.
> > Second is to keep going and minimize the damage as best you can.
>
> I dont really understand what youre trying to say. Keep going and minimize
> damage? How would you do that when your fields ar
Josh Tolley wrote:
>
> On 4/7/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > As to losing data, I suspect you'd lose a lot more
> > from PostgreSQL than MySQL on a failing hard drive.
>
> Any particular reason for that suspicion? I ask out of genuine
>
kups enough?'' ;-)
> >
> > > > Second is to keep going and minimize the damage as best you can.
> > >
> > > I dont really understand what youre trying to say. Keep going
> > and minimize
> > > damage? How would you do that when
On 29/10/06, LeVA <[EMAIL PROTECTED]> wrote:
Hi!
There was a commit today which updates postgresql to version 8.1.5. This
fix made it to the stable branch too, so will there be a package for
it, or I have to compile it from ports?
I don't really understand how this updating process w
2006. October 29. 22:30, viq:
> On 29/10/06, LeVA <[EMAIL PROTECTED]> wrote:
> > Hi!
> >
> > There was a commit today which updates postgresql to version 8.1.5.
> > This fix made it to the stable branch too, so will there be a
> > package for it, or I hav
On Sun, Oct 29, 2006 at 11:59:33PM +0100, LeVA wrote:
> 2006. October 29. 22:30, viq:
> > On 29/10/06, LeVA <[EMAIL PROTECTED]> wrote:
> > > Hi!
> > >
> > > There was a commit today which updates postgresql to version 8.1.5.
> > > This fix m
se Postfix (and Dovecot)
> > with PostgreSQL?
>
> Pull the user data from PostgreSQL and generate the files:
> /etc/sasldb2.db (copy to /var/spool/postfix/etc && postfix reload)
> /etc/cram-md5.pwd
>
> e.g: have a cron driven perl script check for changes to the user tabl
'online' access to postgresql. It is less
CPU expensive and much faster.
But if you wish to use SQL maps I guess you may want to use 127.0.0.1
instead of local socket and of course you need to configure postgresql
to accept network access. *Addition* to above: In pg_hba.conf
(PosgreSQL):
On Fri, Nov 30, 2007 at 10:33:04PM +0100, Bengt Frost wrote:
>
> Someone out there have any suggestions how use Postfix (and Dovecot)
> with PostgreSQL?
Pull the user data from PostgreSQL and generate the files:
/etc/sasldb2.db (copy to /var/spool/postfix/etc && postfix relo
*Addition* to above: In pg_hba.conf (PosgreSQL):
vmail(user) access to datab with md5 password
local(and host)
--bfrost
Bengt Frost wrote:
Hi,
I am trying to use PostgreSQL as a backend for my Postfix virtual mail
system and dovecot(psql) for smtp-auth.
'Postfix' is chrooted -
Instead of that I would recommend you to use DB files generated at
regular intervals instead of 'online' access to postgresql. It is less
CPU expensive and much faster.
But if you wish to use SQL maps I guess you may want to use 127.0.0.1
instead of local socket and of course y
On Sat, Dec 01, 2007 at 12:07:54AM +0100, Bengt Frost wrote:
> > >
> > > Someone out there have any suggestions how use Postfix (and Dovecot)
> > > with PostgreSQL?
> >
> > Pull the user data from PostgreSQL and generate the files:
> > /etc/sasldb2.
mailserver.
On Sat, Dec 01, 2007 at 01:12:54PM +, Craig Skinner wrote:
> On Sat, Dec 01, 2007 at 12:07:54AM +0100, Bengt Frost wrote:
> > > >
> > > > Someone out there have any suggestions how use Postfix (and Dovecot)
> > > > with PostgreSQL?
> > > .
openbsd.org
Sent: Saturday, December 1, 2007 7:12:54 AM
Subject: Re: Postfix(chroot) and Postgresql
On Sat, Dec 01, 2007 at 12:07:54AM +0100, Bengt Frost wrote:
> > >
> > > Someone out there have any suggestions how use Postfix (and
Dovecot)
> > > with PostgreSQL?
> &
On Dec 25, 2007, at 12:57 PM, badeguruji wrote:
I want to setup postfix and dovecot. i want to authenticate my users
thru ldap.
for that i have installed openldap server package.
Is there a place where i can find some 'ponited' help on how to
build such an 'email users' database? i do not wa
aig Skinner <[EMAIL PROTECTED]>
> Sent: Saturday, December 1, 2007 7:12:54 AM
> Subject: Re: Postfix(chroot) and Postgresql
>
> > How about - using OpenLDAP?
>
> Same thing. Flat files are fast and reliable [...]
To add to Craig's comment from the mail you quoted, they're
also a lot simpler.
badeguruji wrote:
[...]
i am searching on google and have not found anything yet. i am
therefore looking into generic ldap manuals. (i do not want to be a
ldap guru)
I maintaining some larger email installations that use LDAP. If you are
not willing/don't want to dig deep into the matter, th
On 3/23/07, Peter <[EMAIL PROTECTED]> wrote:
I see there is a postfix flavour for mysql but not for postgresql. Is this
combination used much? I already have a PGSQL server and I want to plug
postfix into it for virtual mailbox domains.
I can't say if it's used often, but I
On 3/23/07, Peter <[EMAIL PROTECTED]> wrote:
I see there is a postfix flavour for mysql but not for postgresql. Is this
combination used much? I already have a PGSQL server and I want to plug
postfix into it for virtual mailbox domains.
uh, what do you think the pgsql flavor is?
Le Samedi 24 Mars 2007 01:13, Ted Unangst a icrit :
> On 3/23/07, Peter <[EMAIL PROTECTED]> wrote:
> > I see there is a postfix flavour for mysql but not for postgresql. Is
> > this combination used much? I already have a PGSQL server and I want to
> > plug postfix
for mysql but not for postgresql. Is
> > this combination used much? I already have a PGSQL server and I want to
> > plug postfix into it for virtual mailbox domains.
>
> uh, what do you think the pgsql flavor is?
And where do you find that?
On 3/23/07, Peter <[EMAIL PROTECTED]> wrote:
I see there is a postfix flavour for mysql but not for postgresql. Is this
combination used much? I already have a PGSQL server and I want to plug
postfix into it for virtual mailbox domains.
You get 2 minutes in the penalty box. ;)
Ther
On 3/23/07, Peter <[EMAIL PROTECTED]> wrote:
Le Samedi 24 Mars 2007 01:13, Ted Unangst a icrit:
> On 3/23/07, Peter <[EMAIL PROTECTED]> wrote:
> > I see there is a postfix flavour for mysql but not for postgresql. Is
> > this combination used much? I already have a
On 3/24/07, Ted Unangst <[EMAIL PROTECTED]> wrote:
On 3/23/07, Peter <[EMAIL PROTECTED]> wrote:
> Le Samedi 24 Mars 2007 01:13, Ted Unangst a icrit:
> > On 3/23/07, Peter <[EMAIL PROTECTED]> wrote:
> > > I see there is a postfix flavour for mysql bu
From: "Bryan Irvine" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Peter <[EMAIL PROTECTED]>
CC: misc@openbsd.org
Subject: Re: Postfix flavour for PostgreSQL ?
Date: Sat, 24 Mar 2007 00:56:26 -0700
On 3/23/07, Peter <[EMAIL PROTECTED]> wrote:
I see there is a p
Dear List,
in a 4.4 box with Postgresql 8.3.3 I try to create a new tablespace in a
different filesystem and get the following error:
---
template1=# CREATE TABLESPACE OWNER LOCATION
'/home//db';
ERROR: could not set permissions on direct
On Wed, Jan 27, 2010 at 02:13:45PM -0700, Jeff Ross wrote:
> I have searched (and searched) so I wonder if I'm running into the
> i386 1GB limit I see referenced, as in the thread today about fsck
> on larger partitions.
Yes you do. Also, kernel memory is limited, insane shm value will
probably (h
e shm value will
probably (havn't looked at the code) have bad effects.
Thanks!
By what definition of insane? I'd like to be able to say to the PostgreSQL
folks that their sizing model doesn't work on OpenBSD because of x but this is
the correct way to size on OpenBSD.
Also,
Shm shouldn't be mapped in the kernel, so large values won't be that
bad.
On Jan 27, 2010, at 5:01 PM, Tobias Ulmer wrote:
On Wed, Jan 27, 2010 at 02:13:45PM -0700, Jeff Ross wrote:
I have searched (and searched) so I wonder if I'm running into the
i386 1GB limit I see referenced, as in the
On Wed, Jan 27, 2010 at 06:55:29PM -0500, Ted Unangst wrote:
> Shm shouldn't be mapped in the kernel, so large values won't be that
> bad.
But the way that shared mem is implemented means that larger
values require a larger malloc(9), which can increase the
pressure on kva space, which can panic y
On Thu, Jan 28, 2010 at 1:16 AM, Bret S. Lambert wrote:
> On Wed, Jan 27, 2010 at 06:55:29PM -0500, Ted Unangst wrote:
>> Shm shouldn't be mapped in the kernel, so large values won't be that
>> bad.
>
> But the way that shared mem is implemented means that larger
> values require a larger malloc(9
On Wed, Jan 27, 2010 at 3:13 PM, Jeff Ross wrote:
> max_connections = 200 # pgtune wizard 2010-01-27
Silly question, but have you tried any kind of connection pooling? If
you can drop max_connections down you can reduce the shared memory
footprint postgresql has.
d today about fsck
> >>on larger partitions.
> >
> >Yes you do. Also, kernel memory is limited, insane shm value will
> >probably (havn't looked at the code) have bad effects.
> >
>
> Thanks!
>
> By what definition of insane? I'd like to b
On Thu, Jan 28, 2010 at 6:10 PM, Tobias Ulmer wrote:
> Let's make this simple, on i386 you have 1G per process. Adding all the
> numbers up, you have to stay below this limit.
That's quite an oversimplification. For starters, we're talking about
shm, which doesn't count against your 1GB. The st
On Thu, Jan 28, 2010 at 06:53:06PM -0500, Ted Unangst wrote:
> On Thu, Jan 28, 2010 at 6:10 PM, Tobias Ulmer wrote:
> > Let's make this simple, on i386 you have 1G per process. Adding all the
> > numbers up, you have to stay below this limit.
>
> That's quite an oversimplification. For starters,
I just upgraded a production server to -current (needed latest PostgreSQL)
I also am using a forum and wanted to add a second forum using
PostgreSQL (first has been using mysql)
This software supports doing this.
All is working fine, except one script called from crontab to send out
> I can't get postgresql to work with php with the chrooted environment.
Error output? Logs, etc? Attempting to connect to the /var/www/tmp socket
and seeing if that works? You're giving us "OMG I have a problem!!!"
without giving us much of a chance to help.
Hell, it'
On Tue, Mar 2, 2010 at 9:45 PM, Henry Gall wrote:
> I am trying to replace mysql with postgresql on my openbsd + apache +php
> server.
>
> I need to install postgresql from source, as I need special options, and
the
> latest version.
>
> I am runnning openbsd 4.5, ph
s for gmail's line-wrapping.
Thanks.
--david
[mom@www pkgs]$ sudo pkg_add ./postgresql-client-9.2.4.tgz
./postgresql-server-9.2.4.tgz
postgresql-client-9.2.3->9.2.4 forward dependencies:
| Dependency of postgresql-server-9.2.3 on postgresql-client-=9.2.3
doesn't match
Merging postg
On Sun, Sep 25, 2005 at 05:30:01AM -0800, Szechuan Death wrote:
> Question: Is there any really outstanding reason why a suitably-
> licensed database or fork thereof, e.g. PostgreSQL, couldn't be fully
> integrated into the OpenBSD distribution? Alternately, is there any
> r
--On 25 September 2005 05:30 -0800, Szechuan Death wrote:
Question: Is there any really outstanding reason why a suitably-
licensed database or fork thereof, e.g. PostgreSQL, couldn't be fully
integrated into the OpenBSD distribution?
Just a thought, you might find it easier to make a
David Hill wrote:
If you want PostgreSQL, install it from the ports tree.
What is wrong with dump/restore and using tar for a backup solution?
Thank you, I am well aware of the fact that it can be installed from
the ports tree. Going back and _reading_ the original post, we find
that
ver,
although I note that PostgreSQL is much more widely used, and therefore
gives you the biggest "win" with its inclusion. However, since SQLite
is small, embeddable and public-domain, it does provide a third option;
the database could just be embedded in the backup software. It seem
1 - 100 of 240 matches
Mail list logo