Re: sleepycat db VS MySQL or postgres

to db5 or db6 OR MySQL, or even postgres. I use simple primary key files, most entries are added from a CLI or termcap/curses screen. Some programatically. With about the same number of sequential dumps vs indexed random reads. I have no experience with the c interface for postgres or mysql

Re: sleepycat db VS MySQL or postgres

users connecting to the database? Will there be lots of updates to the data? These are what you want. If you care about data integrity, I'd choose Postgres. SQLite: Do you want a relational database without needing a daemon to be running and will only have a single user/process accessing

Re: sleepycat db VS MySQL or postgres

On 02/07/2013 13:55, Mark Felder wrote: If twitter was built upon a WORM database instead of MySQL they could host the entirety of twitter on a handful of servers instead of the gross MySQL+Cassandra mess they're fighting with today. I'd say their problem is not exactly solvable by only

Re: sleepycat db VS MySQL or postgres

On Tue, 02 Jul 2013 07:12:37 -0500, Ivan Voras ivo...@freebsd.org wrote: On 02/07/2013 13:55, Mark Felder wrote: If twitter was built upon a WORM database instead of MySQL they could host the entirety of twitter on a handful of servers instead of the gross MySQL+Cassandra mess they're

sleepycat db VS MySQL or postgres

I have a rather extensive series of databases created and in use all with the very old sleepycat db3. I believe in the addage don't fix what ain't broken, but in the case of db3, it IS broken and my db files get corrupted on occasion. I could move to db5 or db6 OR MySQL, or even postgres. I use

Re: sleepycat db VS MySQL or postgres

On 1 July 2013 16:28, Jim Pazarena fqu...@paz.bz wrote: I could move to db5 or db6 OR MySQL, or even postgres. snip I have no experience with the c interface for postgres or mysql, but also, do not know how much the c interface has changed for sleepycat 5/6 compared to the c interface

Re: sleepycat db VS MySQL or postgres

to db5 or db6 OR MySQL, or even postgres. I use simple primary key files, most entries are added from a CLI or termcap/curses screen. Some programatically. With about the same number of sequential dumps vs indexed random reads. I have no experience with the c interface for postgres or mysql, but also

Re: sleepycat db VS MySQL or postgres

. I could move to db5 or db6 OR MySQL, or even postgres. I use simple primary key files, most entries are added from a CLI or termcap/curses screen. Some programatically. With about the same number of sequential dumps vs indexed random reads. I have no experience with the c interface

Re: sleepycat db VS MySQL or postgres

on occasion. I could move to db5 or db6 OR MySQL, or even postgres. I use simple primary key files, most entries are added from a CLI or termcap/curses screen. Some programatically. With about the same number of sequential dumps vs indexed random reads. I have no experience with the c interface

Re: Coldfusion, Postgres and Java under FreeBSD

On Mon, Mar 7, 2011 at 11:36 PM, n j nin...@gmail.com wrote: openjdk-7.0.122_1 Java Development Kit 7 Long description : Sources : Changes : Download vs. openoffice.org-2.1.0 Integrated wordprocessor/dbase/spreadsheet/drawing/chart/browser Long description | Package | Sources | Main Web

Coldfusion, Postgres and Java under FreeBSD

Dear friends, I've been studying/researching to understand what is the best OS for my production environment. I didn't know FreeBSD until this need, and now I'm fascinated with the stuff I've been reading about it. I have 2 servers with the following SW/HW: Server 1: Postgres 9 HSQLDB (Java) 2

Re: Coldfusion, Postgres and Java under FreeBSD

know FreeBSD until this need, and now I'm fascinated with the stuff I've been reading about it. I have 2 servers with the following SW/HW: Server 1: Postgres 9 HSQLDB (Java) 2 cpu 5620 / 48 GB RAM Server 2: Coldfusion 9 and other java applications 2 cpu 5620 / 24 GB RAM I searched the web about

Re: Coldfusion, Postgres and Java under FreeBSD

wrote: Dear friends, I've been studying/researching to understand what is the best OS for my production environment. I didn't know FreeBSD until this need, and now I'm fascinated with the stuff I've been reading about it. I have 2 servers with the following SW/HW: Server 1: Postgres 9

Re: Coldfusion, Postgres and Java under FreeBSD

FreeBSD until this need, and now I'm fascinated with the stuff I've been reading about it. I have 2 servers with the following SW/HW: Server 1: Postgres 9 HSQLDB (Java) 2 cpu 5620 / 48 GB RAM Server 2: Coldfusion 9 and other java applications 2 cpu 5620 / 24 GB RAM I searched the web

Re: Coldfusion, Postgres and Java under FreeBSD

Question #2: Is the JVM implementation for FreeBSD reliable and fast? Most of my software components are made in Java (including HSQDB) Since I have experience with Java on FreeBSD, I will try to answer this question. Java works very well for me under FreeBSD; I have not had a single problem

Re: Coldfusion, Postgres and Java under FreeBSD

Thanks a lot!! Has anyone successfully installed Coldfusion 9? On Monday, March 7, 2011, Nerius Landys nlan...@gmail.com wrote: Question #2: Is the JVM implementation for FreeBSD reliable and fast? Most of my software components are made in Java (including HSQDB) Since I have experience with

Re: Coldfusion, Postgres and Java under FreeBSD

Java works very well for me under FreeBSD; I have not had a single problem with Java on FreeBSD. To install java, you can either install a pre-compiled JDK (called diablo-jdk) or compile all the JDK sources from scratch using the ports system.  If you compile yourself from ports, you can

Re: Coldfusion, Postgres and Java under FreeBSD

On Mon, 07 Mar 2011 12:19:33 -0600, n j nin...@gmail.com wrote: IMHO, building Java on FreeBSD is a pain. AFAIK, Sun/Oracle doesn't provide precompiled OpenJDK for anyone, really. Even OSX now has to build their own. If it's precompiled it's probably not OpenJDK. Regards, Mark

Re: Coldfusion, Postgres and Java under FreeBSD

... I'm running Java on FreeBSD right now, but I must say I'd probably stick to Linux nowadays if I had any say, at least until there comes a day when I'll be able to pkg_add -r openjdk7. ... Why not now? (Or anytime this past year or more?):

Re: Coldfusion, Postgres and Java under FreeBSD

On Tue, Mar 8, 2011 at 2:13 AM, b. f. bf1...@googlemail.com wrote: Why not now? (Or anytime this past year or more?): Hmm, good point :-). I was misled by the ports page (e.g. http://www.freebsd.org/cgi/ports.cgi?query=openjdkstype=all) which used to have a different entry if a port had a

/libexec/ld-elf.so.1: /usr/local/bin/postgres: Undefined symbol shmctl

Have been running FreeBSD 7.1 for months with PostgreSQL 8.3. All fine. Today, made a change to hosts.allow to add an IP address for FTP access. Rebooted and attempted to restart PostgreSQL. Postgres wouldn't start and left this error in the log file: /libexec/ld-elf.so.1: /usr/local/bin

Re: /libexec/ld-elf.so.1: /usr/local/bin/postgres: Undefined symbol shmctl

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Reggie Euser wrote: Have been running FreeBSD 7.1 for months with PostgreSQL 8.3. All fine. Today, made a change to hosts.allow to add an IP address for FTP access. Rebooted and attempted to restart PostgreSQL. Postgres wouldn't start and left

Re: postgres: [2-1] FATAL: the database is starting up

On Thu, Aug 14, 2008 at 10:49 AM, Mehul Ved [EMAIL PROTECTED] wrote: On 8/14/08, fire jotawski [EMAIL PROTECTED] wrote: every time i boot the machine i always get the message that says postgres[pid]: [2-1] FATAL: the database system is starting Have you checked /var/log/messages

Re: postgres: [2-1] FATAL: the database is starting up

On 8/14/08, fire jotawski [EMAIL PROTECTED] wrote: Aug 14 16:09:53 makham postgres[1221]: [1-1] WARNING: autovacuum not started because of misconfiguration Aug 14 16:09:53 makham postgres[1221]: [1-2] HINT: Enable options stats_start_collector and stats_row_level. You can try enabling those

Re: postgres: [2-1] FATAL: the database is starting up

On Thu, Aug 14, 2008 at 09:59:57AM +0700, fire jotawski wrote: hi sirs, apologize me for disturbing the list but i faced the strange problem that i can not understand every times i boot my machine. every time i boot the machine i always get the message that says postgres[pid]: [2-1

Re: postgres: [2-1] FATAL: the database is starting up

the machine i always get the message that says postgres[pid]: [2-1] FATAL: the database system is starting later on after logged in as root, i check for process, i found the postgresql has been started . so what the reason for the message at during start up then. IIRC, PostgreSQL

postgres: [2-1] FATAL: the database is starting up

i386 [~] # and i installed postgres via ports [~] # pkg_info -Ix postgre postgresql-client-8.2.7 PostgreSQL database (client) postgresql-server-8.2.7 The most advanced open-source database available anywhere [ ~] # every time i boot the machine i always get the message that says postgres[pid]: [2

Kernel options for increasing connections/shared buffers in Postgres

Hi everyone, I'm running OpenNMS on 6.2-Release, and I get this error message when it, I think, tries to hit the postgres DB: FATAL: Too many clients My guess is I'm getting this because I can't increase max connections and shared buffers in postgresql.conf because I haven't added the kernel

RE: Postgres Startup Error Message

-Original Message- From: [EMAIL PROTECTED] [mailto:owner-freebsd- [EMAIL PROTECTED] On Behalf Of Gerard Sent: Sunday, March 25, 2007 7:36 AM To: FreeBSD Questions Subject: Postgres Startup Error Message I occasionally receive this error message when booting up: Mar 25 08:28:24

Re: Postgres Startup Error Message

On Mon, 26 Mar 2007 07:02:27 -0500 Rick Apichairuk [EMAIL PROTECTED] wrote: I occasionally receive this error message when booting up: Mar 25 08:28:24 scorpio postgres[756]: [1-1] FATAL: the database system is starting up Since it is an intermittent error message, I am unable

Postgres Startup Error Message

I occasionally receive this error message when booting up: Mar 25 08:28:24 scorpio postgres[756]: [1-1] FATAL: the database system is starting up Since it is an intermittent error message, I am unable to track down what is causing it or how to fix it. Any suggestions? -- ___ oo

Re: Postgres Startup Error Message

Gerard wrote: I occasionally receive this error message when booting up: Mar 25 08:28:24 scorpio postgres[756]: [1-1] FATAL: the database system is starting up Since it is an intermittent error message, I am unable to track down what is causing it or how to fix it. I've always seen

building php5 with postgres support

Hi there, I commonly build php5 from /usr/ports and would like to automatically have postgres support be compiled ever time I build php5. I do not see a 'make config' option for including the postgres extensions, additions, and/or libraries. What can I do so my portinstall and updates via

Re: building php5 with postgres support

In response to Noah [EMAIL PROTECTED]: Hi there, I commonly build php5 from /usr/ports and would like to automatically have postgres support be compiled ever time I build php5. I do not see a 'make config' option for including the postgres extensions, additions, and/or libraries. What

postgres

Hi I am installing postgres81-server from ports, but it gives me an error. It requires postgres81-client but I have postgres74-client installed. I have not installed this port, so is there something that uses this? I cannot find any pgsql script. Would it be safe to remove 74-client and install

Re: postgres

postgres74-client. This should list what package is was pulled in as a dependency for. If that program is actually USING the postgres support (rather than having been built with support for it that you weren't using), you would have to carefully migrate your data. Otherwise, you will probably want

Re: postgres

eoghan wrote: Hi I am installing postgres81-server from ports, but it gives me an error. It requires postgres81-client but I have postgres74-client installed. I have not installed this port, so is there something that uses this? I cannot find any pgsql script. Would it be safe to remove

Re: postgres

Greg Barniskis wrote: eoghan wrote: Hi I am installing postgres81-server from ports, but it gives me an error. It requires postgres81-client but I have postgres74-client installed. I have not installed this port, so is there something that uses this? I cannot find any pgsql script. Would it be

Re: postgres

On Wed, Apr 26, 2006 at 09:14:53PM +0100, eoghan wrote: Thanks guys: Required by: kde-3.5.1 koffice-1.4.2_3,1 php5-extensions-1.0 php5-pgsql-5.1.2_1 postgresql-libpqxx-2.5.5 I wanted to use it with php5, so i guess forcing an uninstall would bork my php5 support? My suggestion for

setting shmmax for postgres

Hi, how can i set the shmmax parameter in freebsd 6.1? i tried this in /etc/sysctl.conf kern.ipc.shmmax=1147483647 shiva2# sysctl -a kern.ipc.shmmax kern.ipc.shmmax: 2147483647 but postgres always fails with this error The PostgreSQL documentation contains more information about shared

Re: setting shmmax for postgres

On Mar 20, 2006, at 3:36 PM, Miguel wrote: shiva2# sysctl -a kern.ipc.shmmax kern.ipc.shmmax: 2147483647 but postgres always fails with this error The PostgreSQL documentation contains more information about shared memory configuration. FATAL: could not create shared memory segment: Cannot

Re: setting shmmax for postgres

Charles Swiger wrote: On Mar 20, 2006, at 3:36 PM, Miguel wrote: shiva2# sysctl -a kern.ipc.shmmax kern.ipc.shmmax: 2147483647 Opss, typo here, its 1147483647 but postgres always fails with this error The PostgreSQL documentation contains more information about shared memory

Re: setting shmmax for postgres

segments are wired down by default or not, I think there's a sysctl which controls that. I have 3G of RAM OK. You probably want to tune the SGA or whatever Postgres calls it to 512-768 MB, then, but I will happily defer to someone more familiar with that particular database. You should

Install ruby-postgres binding with postgres 8.1

I want to install the ruby-postgres binding (ports/databases/ruby-postgres), and I've got postgres 8.1 installed on my machine. When I do 'make install', it starts to download postgresql-client-7.4.9, and then fails because that conflicts with postgresql-client-8.1.0, which I have installed. I'd

Re: Install ruby-postgres binding with postgres 8.1

I managed to get this working. If anyone's interested, I wrote up a short guide to upgrading to 8.1 http://www.flpr.org/articles/2005/11/16/upgrading-to-postgresql-8-1 On 11/16/05, Pat Maddox [EMAIL PROTECTED] wrote: I want to install the ruby-postgres binding (ports/databases/ruby-postgres

postgres 8 init script problem?

Anyone else having problems starting postgres 8.0.1 (from ports) on RELENG_5? It seems to start alright, but clankily: root$ /usr/local/etc/rc.d/010.pgsql.sh start hang for about a minute could not start postmaster root$ /usr/local/etc/rc.d/010.pgsql.sh status pg_ctl: postmaster is running (PID

Re: postgres 8 init script problem?

* Dick Davies [EMAIL PROTECTED] [0237 21:37]: Anyone else having problems starting postgres 8.0.1 (from ports) on RELENG_5? It seems to start alright, but clankily: root$ /usr/local/etc/rc.d/010.pgsql.sh start hang for about a minute could not start postmaster root$ /usr/local/etc/rc.d

Re: Postgres

* Norman Uittenbogaart [EMAIL PROTECTED] [1010 16:10]: I'm trying to write a backup script for postgres and us a crontab on it. In the manual it says for pg_dumpall make $HOME/.pgpass so it won't ask for a password. Now I made the .pgpass in root's homedir (i wanted to use root's crontab

Re: Postgres

Dick Davies wrote: * Norman Uittenbogaart [EMAIL PROTECTED] [1010 16:10]: I'm trying to write a backup script for postgres and us a crontab on it. In the manual it says for pg_dumpall make $HOME/.pgpass so it won't ask for a password. Now I made the .pgpass in root's homedir (i wanted to use

Re: Postgres

On Wednesday 13 October 2004 04:20 pm, Randy Grafton wrote: Dick Davies wrote: * Norman Uittenbogaart [EMAIL PROTECTED] [1010 16:10]: I'm trying to write a backup script for postgres and us a crontab on it. In the manual it says for pg_dumpall make $HOME/.pgpass so it won't ask

Re: ssh/pam/postgres

a method I could use to have ssh validate itself first against postgres also retrieve any other info such as shell, and hom dir.If postgres fails fallback on another method. pam-pgsql is broken on 5.x and I can't find a way using pam_exec to achieve any effect I have been looking

ssh/pam/postgres

Does anyone know a method I could use to have ssh validate itself first against postgres also retrieve any other info such as shell, and hom dir.If postgres fails fallback on another method. pam-pgsql is broken on 5.x and I can't find a way using pam_exec to achieve any effect I have been looking

Re: php postgres issues

is it a lost cause to: /usr/ports/lang/php4-extensions make config (choose pgsql support) apache restart but still no support for postgres in php perhaps there is some extra configuration I am missing I changed my php.ini to incudle pgsql.so http.config is set up to add the php module users

php postgres issues

I am having issues with getting postgress extensions for php4 do you have to configure it via ports/compiling or can you get away with with just pkg_dd -r Iv'e tried pkg_add -r apache pkg_add -r mod_php4 and the ports way cd /usr/ports/www/mod_php4 make cd work/php-4.3.8 ./configure

Re: php postgres issues

On Wed, 18 Aug 2004 12:45:03 -0400, Rail mail [EMAIL PROTECTED] wrote: I am having issues with getting postgress extensions for php4 do you have to configure it via ports/compiling or can you get away with with just pkg_dd -r Iv'e tried pkg_add -r apache pkg_add -r mod_php4 and the

Postgres running in 5.1 jail corrupts Postgres running in host environment

I'm running Postgres 7.4 installed from a just cvsupped FreeBSD ports. I've got a production machine that's going to need a lot of upgrades, and I want to test them out prior to upgrading the production environment. So I built a jail on the production machine to install the new software

ERserver for Postgres from ports

Greetings, I'm curious if anyone had success installing/running the erserver port (databases/erserver) for Postgresql. It doesn't seem to install all files properly after ers_setup (had to copy from examples/erserver and edit them by hand). The next issue was that the Java stuff didn't run. After

problem Postgres rotation logs

I use Postgres as database for my web site. Postgres write logs to /var/log/pgsql.log. To make log rotation, I append: /var/log/pgsql pgsql:pgsql 600 4 *$W0D23 Z to /etc/newsyslog The rotation works fine and Postgres still work after it occurs, but until I stop

Re: problem Postgres rotation logs

On Sat, 14 Jun 2003 18:21:29 + Emilio Manuel [EMAIL PROTECTED] wrote: I use Postgres as database for my web site. Postgres write logs to /var/log/pgsql.log. To make log rotation, I append: /var/log/pgsql pgsql:pgsql 600 4 *$W0D23 Z to /etc/newsyslog