Ok now I seem to have gotten it working by changing the store port numbers to
pgbouncer because its using port no 5432 and postgres is now using 6432.
So now it seems to be giving me the server details that is being used when
the map gets run:
pgbouncer=# show servers;
type | user | database
Does any of this help this is the config file i get when I type in show
config in the pgbouncer admin console:
pgbouncer=# show config;
key| value
| changeable
---+
has it got to do with the DNS I have checked on the admin consol and a
recieved this:
pgbouncer=# show dns_hosts;
hostname | ttl | addrs
--+-+---
(0 rows)
pgbouncer=# show dns_zones;
zonename | serial | count
--++---
(0 rows)
Not to sure if this he
has it got to do with the DNS I have checked on the admin consol and a
recieved this:
pgbouncer=# show dns_hosts;
hostname | ttl | addrs
--+-+---
(0 rows)
pgbouncer=# show dns_zones;
zonename | serial | count
--++---
(0 rows)
Not to sure if this helps.
-
would any of this help make it more clear on what I seem to be doing wrong?
pgbouncer=# show config;
key| value
| changeable
---+-+
job_name
everytime I change something it seems when i type in show servers in the
admin console, it keeps showing 0 rows.
I have gone back and forth several time trying to get this thing sorted out
nut to no avail i keep getting the same message.
--
View this message in context:
http://postgresql.10456
>show the [databases] section in the pgbouncer.ini
[databases]
manifold = host=127.0.0.1 port=5432 dbname=manifold user=postgrest
password=123ert
I have tested now with both the ip address and using localhost in the host
section
I have also ended up swapping round the 2 port numbers so now post
>have you specified in your pgbouncer.ini auth_type and auth_file ?
my auth_type is md5 and my auth_file is D:\Program
Files\PostgreSQL\etc\userlist.txt
>And I think you really need to check pgbouncer log !!!
I get a lot of this im my pgbouncer log
2013-11-01 12:17:49.228 2860 LOG Stats: 0 r
I get this error in geoserver :Original exception error:
Unable to obtain connection: Cannot create PoolableConnectionFactory (ERROR:
client_login_timeout (server down))
when I change the store port number from 5432 to 6432 so that geoserver can
use the pgbouncer instead of calling on the postg
So should I rather change the 6432 to 5432 like the postgresql port or 8080
like the geoserver tomcat port.
Geoserver is on 8080 and reads all the tables that postgres has cause you
need to add the port no that postgres is on to be able for it read the
tables.
--
View this message in context:
geoserver uses the same port number as tomcat does which 8080 as the moment
should I change it to something else?
postgres uses 5432(default port number to postgresql) and pgbouncer uses
6432(default port number given to pgbouncer)
--
View this message in context:
http://postgresql.1045698.n5.
I don't know if this will help in terms of my problem?
this came from the admin pgbouncer console.
pgbouncer=# show pools;
database | user| cl_active | cl_waiting | sv_active | sv_idle |
sv_used| sv_tested | sv_login | maxwait
---+---+---++---+
I use a check in postgres to give the active connections being used.
But what happens if the connection pooler goes all the way to 100 for
example and say that 100 is your postgres maximum connections at the time. I
know I can change the maximum connections in postgres but am not to sure on
the ri
I'm not a 100% sure but when i type : select count (*) from pg_stat_activity;
in postgres it give me the a number be 3 or 75 or higher depending on what
is runnung at the time if its the webpage with the map or just postgres
itself.
I had thought that the client connections to PgBouncer and pool c
Can some one please give me a bit more of a better explanation on how exactly
the pgbouncer works as I am now lost.
I'm not sure if it is pooling the connections cause surely if its not being
used the connections should go down not up i.e i run the webpage which has
my map running which is an open
for some reason it not always pooling the connections for reuse so I'm not
sure what or if I have left something out.
As I only have a 100 postgres connections and when you have six people
working on it at the same time the connections neary go all the way. Which
in turn starts making pink tiles f
I'm not 100% sure I follow in that part of if its the client cause currently
when I run it on my own computer it does the same thing. Only when I stop
tomcat and start it again then i get the 3 default connection that postgres
has set up. our server does the same thing.
--
View this message in
currently my pg bouncer.ini looks like this :
[databases]
manifold = host=localhost port=5432 dbname=manifold user=postgrest
password=123ert
[pgbouncer]
logfile = C:\Program Files\PostgreSQL\log\pgbouncer.log
pidfile = C:\Program Files\PostgreSQL\log\pgbouncer.pid
listen_addr = *
listen_port = 6
I have now installed the pgbouncer and it seemed to help a little but it did
not bring the connections back down once the connections ended or people
stopped using it. although it would fluctuate up and down on occasion but it
still reached 100 connections.
--
View this message in context:
http
yes they are as well as the tomcat which is where geoserver is running from.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Connection-pooling-tp5776378p5776386.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mai
I'm not sure if its suppose to be under general so please let me know if I
need to move it to another topic area please.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Connection-pooling-tp5776378p5776382.html
Sent from the PostgreSQL - general mailing list archive at
I have geoserver connected to a postgres database and so far I have been
reading that I would need some sort of connection pooling but how do I go
about doing that when it seems most of the connection pooling
aplications/programs seem to only run on linux. I have a windows machine.
otherwise is th
22 matches
Mail list logo
