Hello,
I am facing a weird permission problem with the views in our database.
While the system is up and running, suddenly a certain view gets corrupted.
When we try to query it, it returns permission denied. Although the
permission has not been changed and if I check them using \z the
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:
I have never used pgbouncer myself. But my guess is you have to look at the
Timeout parameters in the configuration file.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Connection-pooling-tp5776378p5776481.html
Sent from the PostgreSQL - general mailing list archive
Hi,
I have a partitioned table events, with one partition for each month, eg
events_2013_03. The partition is done on the field timestamp, and
constraints are set, but insertion of data is done in the partition
directly (so not with a trigger on the events table)
The field event is of type json,
Isn'it a client problem?
It should be client application closing connection when done with data
retrieval, and not the other way around?
Cheers,
Rémi-C
2013/10/31 Jayadevan maymala.jayade...@gmail.com
I have never used pgbouncer myself. But my guess is you have to look at the
Timeout
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 =
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
Hey,
I might be completly wrong, but when you say
get the connections to close if they are not being used,
I'd say that it is a bad client design to not close a connection when it
doesn't need it anymore.
The client should retrieve the data or close when not using after a certain
amount of time.
On 01/11/13 00:10, Rémi Cura wrote:
Hey,
I might be completly wrong, but when you say
get the connections to close if they are not being used,
I'd say that it is a bad client design to not close a connection when
it doesn't need it anymore.
The client should retrieve the data or close when
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
On Thu, Oct 31, 2013 at 5:46 AM, Raphael Bauduin rbli...@gmail.com wrote:
Hi,
I have a partitioned table events, with one partition for each month, eg
events_2013_03. The partition is done on the field timestamp, and
constraints are set, but insertion of data is done in the partition
It's postgresql 9.3, from the pgdg apt repository:
9.3.0-2.pgdg10.4+1
Raph
On Thu, Oct 31, 2013 at 1:48 PM, Merlin Moncure mmonc...@gmail.com wrote:
On Thu, Oct 31, 2013 at 5:46 AM, Raphael Bauduin rbli...@gmail.com
wrote:
Hi,
I have a partitioned table events, with one partition for
On 10/31/2013 12:53 AM, Pascal Tufenkji wrote:
Hello,
I am facing a weird permission problem with the views in our database.
While the system is up and running, suddenly a certain view gets
corrupted. When we try to query it, it returns “permission denied”.
Although the permission has not been
Pascal Tufenkji ptufen...@usj.edu.lb writes:
I am facing a weird permission problem with the views in our database.
While the system is up and running, suddenly a certain view gets corrupted.
When we try to query it, it returns permission denied. Although the
permission has not been changed
Raphael Bauduin rbli...@gmail.com writes:
An explain returns an error:
= explain select max(event-'_id') from events;
ERROR: no tlist entry for key 2
This is certainly a bug. Can we see a self-contained example that
triggers that?
regards, tom lane
--
Sent via
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
I have a table with only one Field ID type Serial Autonumeric and is a PK,
i want insert a new record but it show me error Not null violation, but if
i put a value the first INSERT work correctly but the next Insert it Show
me error Unique violation,
So i try adding a new field in this
-Original Message-
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
ow...@postgresql.org] On Behalf Of si24
Sent: Thursday, October 31, 2013 10:25 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Explanantion on pgbouncer please
Can some one please give me a
Where are you measuring the connections? From your app to PGBouncer, or
from PGBouncer to PostgreSQL?
If it is from your app to PGBouncer, that sounds strange, and like the app
is not properly releasing connections as it should. If it is from
PGBouncer to PostgreSQL, that sounds normal. I
On 10/31/2013 07:31 AM, Yostin Vargas wrote:
I have a table with only one Field ID type Serial Autonumeric and is a
PK, i want insert a new record but it show me error Not null violation,
but if i put a value the first INSERT work correctly but the next
Insert it Show me error Unique
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
My table is like this
Column | Type| Modifiers
--+---**+-**
--**--
id_fld | integer | not null default nextval('test_table_id_fld_
**seq'::regclass)
im using
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
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
For where you are measuring, everything looks normal to me.
Your application will make connections to the pooler as needed, and the
pooler will assign the application connection to a database connection it
has available in it's pool. This gets rid of the overhead of creating a
brand new
On 10/31/2013 07:55 AM, Yostin Vargas wrote:
My table is like this
Column | Type| Modifiers
--+---__+-__--__--
id_fld | integer | not null default
Yes i have a single field because is related to another table that
contains, the name
it's for to do multilanguage
Example
Table1
Column | Type| Modifiers
--+---**+-**
--**--
On Wed, Oct 30, 2013 at 3:16 PM, Brian Crowell br...@fluggo.com wrote:
Hello again!
I've been setting up my PostgreSQL server by doing something I've
never done before: I've joined a Linux server to a domain so I can use
integrated Kerberos authentication from server to server.
I've managed
On 10/31/2013 08:23 AM, Yostin Vargas wrote:
Yes i have a single field because is related to another table that
contains, the name
it's for to do multilanguage
Example
Table1
Column | Type| Modifiers
On 10/31/2013 5:34 AM, si24 wrote:
It seems for each person that they seem to get about +-20 or more
connections each depending on there use of the map if they add the layers
that are overlyed over the map like zones etc...
that sounds really broken.
--
john r pierce
On 10/31/2013 7:38 AM, Adam Brusselback wrote:
If it is from your app to PGBouncer, that sounds strange, and like the
app is not properly releasing connections as it should. If it is from
PGBouncer to PostgreSQL, that sounds normal. I haven't used
PGBouncer, but i've used other connection
Adrian Klaver-3 wrote
Table1
Column | Type| Modifiers
--+---__+-__--__--
id | integer | not null default
nextval('test_table_id_fld___seq'::regclass)
yes i can put other field for identifier , but i think that whit the name
of the table i can know it
2013/10/31 David Johnston pol...@yahoo.com
Adrian Klaver-3 wrote
Table1
Column | Type| Modifiers
On 10/31/2013 09:32 AM, David Johnston wrote:
Adrian Klaver-3 wrote
Table1
Column | Type| Modifiers
--+---__+-__--__--
id | integer | not null default
si24 wrote
Can some one please give me a bit more of a better explanation on how
exactly the pgbouncer works as I am now lost.
Working from theory here but:
Pool (PGBouncer) Connections: 1
PostgreSQL Connections: 1
Container Threads: 2 [A, B]
Thread A: get connection - OK
Thread B: get
On czw, paź 31, 2013 at 07:25:21 -0700, si24 wrote:
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
i really dont need a number generator, only a unique PK. but i want that
this PK be generate automatically
for example i have a Category calling Computer in English but i have the
same Category in Spanish (Computadora) i assigned the ID-1 for both
So if i put the Pk ID in the table2 number i
On 10/31/2013 11:12 AM, Yostin Vargas wrote:
i really dont need a number generator, only a unique PK. but i want that
this PK be generate automatically
for example i have a Category calling Computer in English but i have the
same Category in Spanish (Computadora) i assigned the ID-1 for both
postgresql-9.3.1-1-windows-x64.exe
[cid:image001.png@01CED62F.CDB7E0F0]
Problem running post-install step. Installation may not complete correctly
The database cluster initialization failed.
Is there an installation log I can examine to determine the problem more
completely?
System
On 10/31/2013 11:15 AM, John R Pierce wrote:
On 10/31/2013 5:34 AM, si24 wrote:
It seems for each person that they seem to get about +-20 or more
connections each depending on there use of the map if they add the layers
that are overlyed over the map like zones etc...
that sounds really
On 10/31/2013 10:02 AM, si24 wrote:
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
On 10/31/2013 1:09 PM, andy wrote:
I'm not sure if geoserver is like openLayers/mapserver, but in the
later case (which I use), you can set it up to have the browser
(running openLayers) request multiple layers at the same time... and
on top of that each layer can be requested in tiles. (That
On 10/31/2013 3:24 PM, John R Pierce wrote:
On 10/31/2013 1:09 PM, andy wrote:
I'm not sure if geoserver is like openLayers/mapserver, but in the
later case (which I use), you can set it up to have the browser
(running openLayers) request multiple layers at the same time... and
on top of that
Hello,
I'm running an application (with programs in Perl) through pgpool 3.1
with replication mode to two postgresql db servers (version 9.0.13).
Recently, I noticed that the following messages repeatedly showed in
postgres log files. As far as I know, the application programs do not
make
On Thu, Oct 31, 2013 at 11:51 AM, Gary Fu g...@sigmaspace.com wrote:
Hello,
I'm running an application (with programs in Perl) through pgpool 3.1 with
replication mode to two postgresql db servers (version 9.0.13). Recently,
I noticed that the following messages repeatedly showed in
I am running a somewhat unfamiliar Ruby automation results app using
ActiveRecord to manage the postgres 9.0 backend. During our automation runs we
sometimes get bursts of HTTP 500 errors coming back at us, and the Ruby app log
shows an Hstore::TooBig error:
Hstore::TooBig (Hstore::TooBig):
On Oct 31, 2013, at 3:46 PM, john gale j...@smadness.com wrote:
I don't quite know where this error is coming from. The ActiveRecord source
doesn't seem to have it, and I'm not familiar enough with Rails or
ActiveRecord to track definitively whether the failing function is actually
On Thu, Oct 31, 2013 at 11:51 AM, Gary Fu g...@sigmaspace.com wrote:
I'm running an application (with programs in Perl) through pgpool 3.1 with
replication mode to two postgresql db servers (version 9.0.13). Recently, I
noticed that the following messages repeatedly showed in postgres log
On 10/31/2013 03:46 PM, john gale wrote:
I am running a somewhat unfamiliar Ruby automation results app using
ActiveRecord to manage the postgres 9.0 backend. During our automation runs we
sometimes get bursts of HTTP 500 errors coming back at us, and the Ruby app log
shows an
On 10/31/2013 11:53 AM, Dann Corbit wrote:
postgresql-9.3.1-1-windows-x64.exe
Problem running post-install step. Installation may not complete correctly
The database cluster initialization failed.
Is there an installation log I can examine to determine the problem more
completely?
On Oct 31, 2013, at 4:44 PM, Adrian Klaver adrian.kla...@gmail.com wrote:
So to piece out the questions,
- is there a total size limitation of the hstore field? or is it
theoretically large enough (1GB) that it really shouldn't matter?
- is there a string size limitation of each key/val in
On Oct 31, 2013, at 4:44 PM, Adrian Klaver adrian.kla...@gmail.com wrote:
So to piece out the questions,
- is there a total size limitation of the hstore field? or is it
theoretically large enough (1GB) that it really shouldn't matter?
- is there a string size limitation of each key/val in
On 10/31/2013 5:11 PM, john gale wrote:
The further questions still apply though; are there documented size
limitations for hstore?
afaik only the practical limits of how big you want your tables to get,
and the 1GB limit of the underlying text representation. having many
1000s of keys in
The PostgreSQL installer for Windows 64 appears to be broken for Microsoft
Windows Server 2012 Standard.
Even after uninstalling, removing the entire postgresql directory structure,
and running the installer as administrator, I get this error:
fixing permissions on existing directory
54 matches
Mail list logo