Has anyone used DRDB (http://www.drbd.org/) with Postgres and can speak to
its speed/value, specifically in its various replication modes (
http://www.drbd.org/users-guide/s-replication-protocols.html)?
Thanks,
Gavin
I just install it as my own user on my laptop... I usually do something like
./configure --prefix=/Users/myaccount/pgsql
make && make install
then
cd ~/
pgsql/bin/initdb -D /Users/myaccount/pgsql/data
pgsql/bin/pg_ctl _D /Users/myaccount/pgsql/data start
and I'm off to the races ;-)
Good luck!
You'll want to evaluate pgBouncer to see if it meets your needs. It
works very well for general proxying, connection pooling.
On 9/7/07, Denis Gasparin <[EMAIL PROTECTED]> wrote:
> I'm looking for connection pooling solutions for our php/apache server.
>
> I already checked pgpool and pgbouncer b
We use noatime on our production database without issues.
On 8/28/07, Bill Moran <[EMAIL PROTECTED]> wrote:
> In response to "Keaton Adams" <[EMAIL PROTECTED]>:
>
> > After reading several articles on the performance drag that Linux atime
> > has on file systems we would like to mount our DB volum
ow if
that answers your question, would be happy to elaborate further if needed.
On 8/19/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> On Jul 23, 5:18 am, [EMAIL PROTECTED] ("Gavin M. Roy") wrote:
> > You might want to look at pgBouncer to pool your drupal pgsql
&
Are you contemplating providing access to data that's currently not stored
in the pg_ catalog tables? I currently monitor the statio data,
transactions per second, and active/idle backends. Things that I think
would be useful would be average query execution time, longest execution
time, etc. Ot
Hmm.. also data such as what is the background writer currently doing, where
are we at in checkpoint segments, how close to checkpoint timeouts are we,
etc.
On 8/2/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
>
> Josh Tolley escribió:
> > On 8/2/07, Gavin M. Roy <[EM
Your easiest route will be to have them export a csv file out of excel and
write a script to import the csv into the database.
On 7/23/07, novnov <[EMAIL PROTECTED]> wrote:
The answer may or many not be very postgres specific but...what are some
possible routes that I could take to allows user
You might want to look at pgBouncer to pool your drupal pgsql needs. I've
found with 2000 needed connections, I can pool out to only 30 backends and
still push 8k transactions per second.
On 7/21/07, Arnaldo Gandol <[EMAIL PROTECTED]> wrote:
I have a drupal site working with postgres that do
The way to handle this is to make your ajax call PHP scripts which
handle your data and return your XML for the Javascript (or HTML).
AJAX makes HTTP requests, it does not talk directly to the database
server.
In essence to do what you're asking you would need a JavaScript
implementation
It doesnt sound like an apache problem to me, it sounds like a
library version conflict happening in PHP, so apache shouldn't impact
it. What happens when you try and access pgsql functions from the cli?
Gavin
On Jun 8, 2006, at 2:22 PM, [EMAIL PROTECTED] wrote:
Gavin M. Roy wrote
your other thread of emails is on the PgSQL PHP list IIRC.
Hope this helps,
Gavin
On Jun 8, 2006, at 2:06 PM, [EMAIL PROTECTED] wrote:
Gavin M. Roy wrote:
I'd check to make sure you dont have extra pgsql.so and postgresql
library files laying about. My off the cuff guess is that
pgs
I'd check to make sure you dont have extra pgsql.so and postgresql
library files laying about. My off the cuff guess is that pgsql.so
is linked against 8.0 libs and you need to recompile it to link
against 8.1 libs?
Gavin
On Jun 8, 2006, at 1:47 PM, [EMAIL PROTECTED] wrote:
I wrote abou
For what it's worth, I have no issue with PHP 5.1.4 and PostgreSQL
8.1.4 on Gentoo either.
Gavin
On Jun 5, 2006, at 2:40 PM, Larry Rosenman wrote:
[EMAIL PROTECTED] wrote:
The last 2-3 days I tried to make php 5.1.4 work with PostgreSQL
8.1.4 - but could not. The PGSQL extension kills the h
Do you mean every version of OS X? I will not run on OS 9, afaik.
It can be compiled against any version of OS X, again as far as I know.
Gavin
On May 16, 2006, at 7:51 AM, Forums @ Existanze wrote:
Here is the thing, the user doesn't have Postgres installed on his/her
computer. So how am
-
Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant
305 321-1144 (mobilehttp://www.JerrySievers.com/
---(end of
broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if y
If your DB encoding is UTF-8, I don't see why you can't use a TEXT
data type.
Regards,
Gavin
On Mar 2, 2006, at 7:07 PM, Perez wrote:
Any pointers/tricks/gotchas on storing XML into postgresql? Is it any
more complicated than storing the XML into a bytea field? Do I
have to
worry about
I haven't compiled it myself, but a guess would be if you installed
XCode (which comes with gcc, and should have most if not all the libs
needed) it's a matter of grabbing the source, untarring it, running ./
configure in the src dir, make, and make install, etc. (Follow the
normal build i
ional.
Regards,
Gavin
Gavin M. Roy
800 Pound Gorilla
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: explain analyze is your friend
here, I am just trying to see if opinions of others on
this, as Jim had posted a MySQL one, and that there was a
PostgreSQL one, so I wanted to see if these are valid, if they
aren't then that site should be updated to reflect this.
Cheers,
Aly.
On Thu, 6 Oct 2005, Gavin M. Roy wro
7;s datatypes do not
match
Gavin M. Roy
800 Pound Gorilla
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
ang Keller
--
P.S.: My From-address is correct
---(end of
broadcast)---
TIP 6: explain analyze is your friend
Gavin M. Roy
800 Pound Gorilla
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1:
tely my project began before PDO saw the light of day, but
I plan to
migrate to it eventually.
--
greg
---(end of
broadcast)---
TIP 5: don't forget to increase your free space map settings
Gavin M. Roy
800 Pound Gorilla
[EMAIL PROTECT
Thank you for posting to a better list for these questions. Check your
postgresql.conf file and make sure it's accepting TCP/IP connections on
the IP you're looking for. If you look in your PGDATA directory you
should find the config file, and if you open it and read it, it's well
commented s
PDO just went into beta, and can be downloaded from
http://pecl.php.net/package/pdo to be compiled into previous versions of
PHP. We really should get some PHP and PgSQL people onto making sure
the PgSQL driver is top notch (if it isn't already).
Gavin
On Mon, 2005-02-07 at 20:21 -0800, Joshua
DROP CONSTRAINT should be able to drop your pkey and as long as your
data supports your new key... you should be set
Gavin
Michael Hannon wrote:
Greetings. We're running Postgres 7.3 on an Intel linux box (Redhat
Enterprise server, version 3.0). We find ourselves in an awkward
position: we ha
I've been extremely happy with my gentoo boxes. I switched from
Slackware over the past year or so after many years of Slackware
zealotry. I have nothing bad to say about using Gentoo other than I
personally wouldnt use portage/ebuilds for PostgreSQL. Personally I
always have better experien
Note that I have had a few segfaults on gentoo, pg v7.4.3, amd64, kernel
2.6.5-gentoo-r1 as well.
Gavin
Andrew Sukow wrote:
Gentoo
Postgres V 7.4.3
Freshly recompiled postgres and compiler
Thanks
Andrew
- Original Message -
From: Bruce Momjian <[EMAIL PROTECTED]>
Date: Tuesday, August 17,
While the sentiment about supporting pgsql friendly vendors is valid,
personally, I'd sooner use dbase 3 than give SCO any money.
Gavin
On 03 Jun 2004 14:51:16 -0400, Robert Treat
<[EMAIL PROTECTED]> wrote:
>
> On Tue, 2004-06-01 at 06:42, Shridhar Daithankar wrote:
> > On Tuesday 01 June 2004 1
ok at the Linux kernel mailing list,
and you'll probably find good articles at Linux Weekly News (lwn.net.)
On 2004.03.06 23:32 Gavin M. Roy wrote:
I'll post it if you want, but the issue isn't with the optimizer,
index usage, or seq scan, the issue seems to be more revolving aro
seemingly
execute while its running.
Gavin
Tom Lane wrote:
"Gavin M. Roy" <[EMAIL PROTECTED]> writes:
It's not WAITING, the larger queries are eating cpu (99%) and the rest
are running so slow it would seem they're waitng for processing time.
Could we see EXP
It is using indexs, and not seqscan, and there was an analyze after
reload... I'll play with GEQO, thanks.
Gavin
Mike Mascari wrote:
Gavin M. Roy wrote:
I upgraded my main production db from 7.3.4 last night to 7.4.1. I'm
running into an issue where a big query that may take 30-
6, 2004 at 01:12:57PM -0800, Gavin M. Roy wrote:
I upgraded my main production db from 7.3.4 last night to 7.4.1. I'm
running into an issue where a big query that may take 30-40 seconds to
reply is holding up all other backends from performing their queries.
By "holding up&quo
post that link so as to not chew up your bandwidth.
Also, the same request goes for your response.
Thanks,
Adam Ruth
On Jan 21, 2004, at 11:28 AM, Gavin M. Roy wrote:
My problem is the threat from SCO is not from the bleachers so to
speak, but direct in writing :(
http://www.gavinroy.com/~g
Here is a copy of the letter which I've sent out today:
http://www.gavinroy.com/~gavinr/SCO%20Response.pdf
We'll see their response and act accordingly. Thanks for all the
feedback everyone.
Gavin
Alex Satrapa wrote:
Gavin M. Roy wrote:
My problem is the threat from SCO is no
Marc G. Fournier wrote:
On Tue, 20 Jan 2004, Gavin M. Roy wrote:
I'm currently one of the targets of SCO's linux licensing extortion
business plan, and am contemplating switching to one of the BSD's to
avoid any potential problems. I'm curious which BSD people prefer for
l
http://mirror.ehpg.net/postgresql/ doesn't suck ;-) But I'm partial.
http://mirror.ehpg.net/postgresql/source/v7.4.1/ is a direct URL.
Gavin
Robert Treat wrote:
On Tue, 2003-12-23 at 13:39, Dan Vande More wrote:
Hey list, I'm just wondering if anyone can point me in the direction of a mirr
Here's some PHP code I use to do just that:
$record = $prepend . "\n";
for ( $y = 0; $y < pg_NumFields($resultid); $y++ ) {
$record .= $prepend . "\t<" . pg_FieldName($resultid, $y) . ">";
$data = Trim(pg_Result($resultid, $row, $y));
$data = ereg_replace("&", "&", $data);
Sorry if this is a repost, but codewalkers have a poll up for php
developers for their database of choice. I'm not affiliated with the
site in any way, I just want to see PgSQL at more than 8% :( It's right
on the homepage.
http://codewalkers.com/
Gavin
---(end of
heh, well in addition to my response from Linux-SMP, I am using
PostgresQL and PHP 3
:) Gavin
Matthew Hixson wrote:
>
> Hello, I'm currently looking for any documentation anyone on the list
> knows of that shows the performance of Linux on any Intel hardware
> (preferrably a dual PII) for serv
40 matches
Mail list logo