On 2012-06-08 08:39, Craig Ringer wrote:
On 06/07/2012 10:26 PM, Condor wrote:
Hello ppl,
I read in internet and in this mailing list, when some one asking
about load balance,
most of the answers is: pgpool.
I want to asking how stable is pgpool ? How much query can handle ?
What load
On 06/10/12 11:26 PM, Condor wrote:
Im not sure, just looking how to make load balance. I have a small
database around 20 gb,
but I expect to join another database on different scheme and Im
looking for solution
about load balance or some cache mechanism. Bad part is one row from
db is read
On 2012-06-11 09:35, John R Pierce wrote:
On 06/10/12 11:26 PM, Condor wrote:
Im not sure, just looking how to make load balance. I have a small
database around 20 gb,
but I expect to join another database on different scheme and Im
looking for solution
about load balance or some cache
On 06/11/12 12:11 AM, Condor wrote:
I seek advice if the server load is too much what I could do to it
landed.
I recommend a faster server for this. more CPU cores, more memory,
faster storage. that will take you a LONG ways, much simpler than
complex and fragile database cluster schemes
On 06/11/2012 11:34 AM, Benson Jin wrote:
Hi All,
We are having a problem with our streaming replication read only node.
It has crashed a few times with a couple of different reasons, mostly
segmentation fault.
Any chance of examining a core dump and getting a stack trace?
On 2012-06-11 10:23, John R Pierce wrote:
On 06/11/12 12:11 AM, Condor wrote:
I seek advice if the server load is too much what I could do to it
landed.
I recommend a faster server for this. more CPU cores, more memory,
faster storage. that will take you a LONG ways, much simpler than
Dear all
I have to import and watch/edit data stored in an .backup-file. This is a
backup-file, stored by an other firm.
My problem is, I am new at Postgres and it is the first time I have to work
with PostGIS-data.
I installed pgAdminIII and tryed to import it with this program. But it will
not
De : Craig Ringer [mailto:ring...@ringerc.id.au]
Envoyé : June-09-12 3:50 AM
(CCing Dave Page Sachin Srivastava who work on the installer):
Short version is that the Pg installer appears to need to:
- Include the latest release of the redist because there's a security fix in it
- use
On 11 June 2012 10:42, gipsy-king1 stue...@gis-consult.de wrote:
I have to import and watch/edit data stored in an .backup-file. This is a
backup-file, stored by an other firm.
Can you tell me what I have to do?
Is that a Postgres dump? If so, is it a plain text dump, a compressed
dump or a
When attempting to download and install Postgres on my computer for work, it
prompted me to create a password. Upon trying many different combinations I
could not get one to work. An error message stated that the password I entered
did not meet the constraints. Is there a guide to creating a
I have postgresql91-contrib installed in Centos 6:
# yum list installed postgresql91-contrib
...
Installed Packages
postgresql91-contrib.x86_64 9.1.4-1PGDG.rhel6 @pgdg91
But when I try to use it I get the error:
ERROR: function dblink(text, text) does not exist
LINE 2: from dblink(
On Jun 11, 2012, at 11:17 AM, Clodoaldo Neto wrote:
I have postgresql91-contrib installed in Centos 6:
# yum list installed postgresql91-contrib
...
Installed Packages
postgresql91-contrib.x86_64 9.1.4-1PGDG.rhel6 @pgdg91
But when I try to use it I get the error:
ERROR: function
2012/6/11 Vibhor Kumar vibhor.ku...@enterprisedb.com
On Jun 11, 2012, at 11:17 AM, Clodoaldo Neto wrote:
I have postgresql91-contrib installed in Centos 6:
# yum list installed postgresql91-contrib
...
Installed Packages
postgresql91-contrib.x86_64 9.1.4-1PGDG.rhel6 @pgdg91
But
Magruder, Ryan S. wrote on 11.06.2012 16:55:
When attempting to download and install Postgres on my computer for
work, it prompted me to create a password. Upon trying many different
combinations I could not get one to work. An error message stated
that the password I entered did not meet the
Am 11.06.2012 14:43, schrieb Alban Hertroys:
On 11 June 2012 10:42, gipsy-king1 stue...@gis-consult.de wrote:
I have to import and watch/edit data stored in an .backup-file. This is a
backup-file, stored by an other firm.
Can you tell me what I have to do?
Is that a Postgres dump? If so, is
2012/6/11 Benson Jin benson@troo.com:
Hi All,
We are having a problem with our streaming replication read only node. It
has crashed a few times with a couple of different reasons, mostly
segmentation fault. The latest log are listed below:
2012-05-30 23:56:37.385 UTC::: LOG: server
I will try produce one and submit to here.
- Original Message -
From: Craig Ringer ring...@ringerc.id.au
To: Benson Jin benson@troo.com
Cc: pgsql-general@postgresql.org
Sent: Monday, June 11, 2012 3:49:41 AM
Subject: Re: [GENERAL] Segmentation Fault
On 06/11/2012 11:34 AM,
On 06/11/12 2:11 AM, Condor wrote:
Yes, I now but these parameters can't be increase forever. It's can
but isn't cheep.
For that reason I looking some other ways.
why don't you worry about that when you get there, rather than before
you even start?
I've got a 2U dual xeon X5660 server w/
On 2012-06-11 21:03, John R Pierce wrote:
On 06/11/12 2:11 AM, Condor wrote:
Yes, I now but these parameters can't be increase forever. It's can
but isn't cheep.
For that reason I looking some other ways.
why don't you worry about that when you get there, rather than before
you even start?
(version == 9.1)
In my PL/pgSQL stored functions,
I want to be able to distinguish which FK constraint caused the
[foreign_key_violation] exception.
. . .
BEGIN
delete from MY_COOL_TABLE where id = 123 ;
EXCEPTION
WHEN foreign_key_violation THEN
CASE
WHEN (SQLERRM
On 06/11/12 12:17 PM, Condor wrote:
May be because some times when some one start a new business does not
have 20k $ for
a new server and resource of the server is enough for the moment and
as I planed
is enough for this year.
and when you start a new business, you don't lease a campus large
On Tue, Jun 12, 2012 at 5:17 AM, Condor con...@stz-bg.com wrote:
On 2012-06-11 21:03, John R Pierce wrote:
On 06/11/12 2:11 AM, Condor wrote:
Yes, I now but these parameters can't be increase forever. It's can but
isn't cheep.
For that reason I looking some other ways.
why don't you worry
Thank you both for the suggestions. I started playing with the window
functions, but found and copied an islands and gaps example that didn't
need them, and was simpler than I thought. This query seems to do the
trick:
SELECT
client_id,
count(*)
FROM
(SELECT
client_id,
Along with Chris, the need for having tables defined in the extension
is about keeping control of the table structure so the extension
functions are guaranteed to work as intended and to make upgrading
versions easier. As an example, the fact that I can specifically name
constraints makes it
On Fri, 2012-06-08 at 22:27 +0100, Thomas Munro wrote:
This is slow, handled with a seq scan (as are various rephrasing with
, =, etc):
SELECT ... FROM ... WHERE ctid BETWEEN ... AND ...;
Is there a way to retrieve the rows in a physical range quickly?
Interesting idea. However, as far as
On 10/06/12 08:29, David Williams wrote:
Hi There,
I'd like to be able to run the contents of an external SQL file from Perl.
Something akin to:
$dbh-do( '\i /home/david/run_me.sql' );
However this fails, and I assume that is because the \i is a client command. Is
there a way to run
Toby --
A small point:
...
How about something like
use File::Slurp;
use Try::Tiny;
try {
$dbh-being_work;
$dbh-begin_work;
...
Clarification for any who might be unfamiliar with the perl tools.
Greg Williamson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
On Mon, Jun 11, 2012 at 7:37 PM, Greg Williamson
gwilliamso...@yahoo.com wrote:
Toby --
A small point:
...
As a brief note, the semicolon splitting issue was why we went with
invoking psql via system(). We found that was vastly simpler than
trying to handle all corner cases ourselves.
Best
Hi All,
A silly question how do I get install external symbols for postgresql, if
compiled it myself previously? Do I recompile it with --enable-debug option?
Cheers,
Benson
- Original Message -
From: Craig Ringer ring...@ringerc.id.au
To: Benson Jin benson@troo.com
29 matches
Mail list logo