> Buenas tardes compañeros, tego problemas con un pgpool version 3.0.4.1
> en
> ubuntu,
>
> tengo configurado un backend y el parametro connection_cache = true
>
> Se configuro una app web para que se conecte a dicho pool se conecta bien
> pero no reutiliza las coneccciones es decir cuando me co
Buenas tardes compañeros, tego problemas con un pgpool version 3.0.4.1 en
ubuntu,
tengo configurado un backend y el parametro connection_cache = true
Se configuro una app web para que se conecte a dicho pool se conecta bien
pero no reutiliza las coneccciones es decir cuando me conecto con el
pg
Hello,
I am run pgpool and then create database bench. After that I run
following command :
pgbench -i -p bench
But I got following error :
2011-09-23 12:38:11 ERROR: pid 12697: pool_read_kind: kind does not match
between master(53) slot[1] (45)
2011-09-23 12:38:11 ERROR: pid 1269
Hello:
We have a problem with pgpool II.
We have setup a replication system for PostgreSQL 9 using pgpool II with two
nodes. The system is work: when we insert some record in the pool (port
), the data is saved in node-1 and node-2. We can also stop a node and
recover it properly.
The proble
sorry, found http://pgfoundry.org/mail/?group_id=155 pgfoundry.org
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/pgpool-II-forum-tp4754155p4754163.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgs
Hi!
Where can I ask about using pgpool-II (forum, maillist ...)?
Thank you!
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/pgpool-II-forum-tp4754155p4754155.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list
hi.
excuse me for offtopic -- pgpool maillist is almost dead
i want pgpool in replication mode to interrupt service in case of any
backend failure.
is it possible?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/
Hi,
I am running postgresql 8.3.11 and pgpool II 3.0
I am trying to get pg_pool to run on a development server. Any userid
defined with 'trust' level
Access works fine, but having issues with ids defined with md5 level
therefore requiring a password.
Reading the pgpool doc
(http://pgpoo
> postgresql-server-dev-8.4?
ah, the other way around :P
i would think
libpqxx3-dev
or libpqxx-dev, which is probably a meta-package (independent of version nr)
it seems from the error that you don't need the server files, only
libpg, which is a client library
--
"Patriotism is the convictio
2010/9/30 Victor Hugo :
> Hi !
>
> I am compiling the pgpool-II and the following error below happens:
> configure: error: libpq is not installed or libpq is old
> I ran the following command : ./configure
> --prefix=/opt/PostgreSQL/pgpoolII --with-pgsql=/opt/PostgreSQL/8.4
> --with-pgsql-libdir=/
On Fri, Oct 1, 2010 at 1:48 PM, Willy-Bas Loos wrote:
>> I've installed postgresql 8.4.4.
> Hi,
>
> Usually you need a ...-dev package if you want to compile anything against it.
> But i can't find a postgresql-8.4-dev in my ubuntu lucid (10.04).
> That might mean that you have to compile postgres
> I've installed postgresql 8.4.4.
Hi,
Usually you need a ...-dev package if you want to compile anything against it.
But i can't find a postgresql-8.4-dev in my ubuntu lucid (10.04).
That might mean that you have to compile postgres also, or find a
repository for the -dev package.
hth
WBL
--
"
Hi !
I am compiling the pgpool-II and the following error below happens:
configure: error: libpq is not installed or libpq is old
I ran the following command : ./configure
--prefix=/opt/PostgreSQL/pgpoolII --with-pgsql=/opt/PostgreSQL/8.4
--with-pgsql-libdir=/opt/PostgreSQL/8.4/lib
--with-pgsql-i
I am looking ahead to when postgresql 9.x is non-beta and how
we can best make use of the "virtually synchronous" replication.
At our site, we have a load balancer appliance that works very well
in that it can direct a connection to one of a number
of back ends. When one back end goes away, conne
Hi All,
I have installed Postgres 8.3.3 and Pgpool 2.2RC2 on two machines and* Both
*servers have the identical copy of the database running.
I have started postgres server on both machines and I have started pgpool on
both machines.
But for some reasons i am not able to connect to database throu
Hello,
while evaluating pgpool-II (replication mode) I ran into a situation
where I don't know the reason why
The setup looks like:
-
host "one": postgres8.3.5 (defined as backend_0) and pgpoolII (port )
host "two": postgres8.3.5 (defined as backend_1)
According to the
Hi Dear List,
I am trying to start a multi-master single slave replication with pgpool-2.
I read the tutorial available but I could not exactly figure out what is to be
done!
Do I have to do the installation for every node, as it is for slony?
Does anybody know a step by step tutorial?
Thank you
On Wed, Sep 19, 2007 at 09:59:22PM -0700, Charles.Hou wrote:
> i have installed the pgpool in the server and start it. but how can i
> know it's working? i means that the clients connected to the
> database
> by the pgpool.
The latest versions of pgpool2 (I don't use pgpool) have connection
loggi
i have installed the pgpool in the server and start it. but how can i
know it's working? i means that the clients connected to the
database
by the pgpool.
---(end of broadcast)---
TIP 6: explain analyze is your friend
After a long battle with technology, [EMAIL PROTECTED] (adey), an earthling,
wrote:
> Please could someone give me an idea of what pgpool is, and where I can
> research it?
>
> I have run a search on postgresql.org and found many references, but
> they don't explain what it is, and it doesn't app
http://pgpool.projects.postgresql.org/
from the site:
"What is pgpool?
pgpool is a connection pool server for PostgreSQL. pgpool runs between
PostgreSQL's clients(front ends) and servers(back ends). A PostgreSQL
client can connect to pgpool as if it were a standard PostgreSQL
server..."
G.-
O
Please could someone give me an idea of what pgpool is, and where I can research it?
I have run a search on postgresql.org and found many references, but they don't explain what it is, and it doesn't appear in the documentation index of the v8.1 manuals.
Hello list,
I have a 2 database cluster with pgpool running. It is configured as a load
balancer and is working good untill I start a VACUUM, then the database
goes in degeneration mode...
Has anyone experienced the same problem?
Thanks for helping.
--
Cheers!
Wim De Hul
--
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Pgpool errors: pgpool 2.6.4 postgres 7.3.10 ProcessFrontendResponse:
failed to read kind from frontend. fronend abnormally exited
I have set up the above versions of pgpool and posgres, running in
replication mode.
we are connecting via psql and qu
I'm using pgpool in a fairly high-traffic environment, and I regularly
get this warning from pgpool calling ABORT:
WARNING: there is no transaction in progress
I found this post in the archives:
http://archives.postgresql.org/pgsql-general/2004-04/msg01154.php
But the README for pgpool asserts:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Is anyone here using PgPool? I've been trying to get it working but
I keep getting an error:
ERROR: pid #: accept() failed. reason: Resource temporarily
unavailable
Anyone know if there are any sites or mailing lists _not_ in
Japanese? TIA
---
26 matches
Mail list logo
