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 but
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 volumes with the
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
needs. I've
found with 2000 needed
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.
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 [EMAIL PROTECTED] wrote:
Are you
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 users
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
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
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
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
pgsql.so is linked
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:
I'm
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
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
of
broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
Gavin M. Roy
800 Pound Gorilla
[EMAIL PROTECTED]
---(end of broadcast
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
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
.
Regards,
Gavin
Gavin M. Roy
800 Pound Gorilla
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: explain analyze is your friend
not
match
Gavin M. Roy
800 Pound Gorilla
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
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 wrote:
This sure sounds like
--
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: if posting
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 PROTECTED]
---(end
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
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,
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
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
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 15:24,
,
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 around
the backend getting so much cpu priority it's
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, do you mean that it's
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-40 seconds
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 EXPLAIN ANALYZE output for the large query? (Also the
usual
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 not from
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/~gavinr/sco_threat.gif
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
large scale databases
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
Here's some PHP code I use to do just that:
xml version=1.0
?php
function returnRecord($resultid, $row, $level) {
$prepend = ;
for ( $y = 0; $y $level; $y++ )
$prepend .= \t;
$record = $prepend . RECORD\n;
for ( $y = 0; $y pg_NumFields($resultid); $y++ ) {
$record .=
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
39 matches
Mail list logo