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 sys
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
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 at
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, a
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
> I have never used pgbouncer myself. But my guess is you have to look at the
> Timeout parameters in the configuration
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'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
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 n
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
On Thu, Oct 31, 2013 at 5:46 AM, Raphael Bauduin 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 directly
> (so not
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 wrote:
> On Thu, Oct 31, 2013 at 5:46 AM, Raphael Bauduin
> wrote:
> >
> > Hi,
> >
> > I have a partitioned table events, with one partition for each month, eg
> > events
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" 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 and if I check
Raphael Bauduin 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 pgsql-general m
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
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 table
> -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
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 haven'
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 violati
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
My table is like this
Column | Type| Modifiers
--+---**+-**
--**--
id_fld | integer | not null default nextval('test_table_id_fld_
**seq'::regclass)
im using Yi
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 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 connecti
On 10/31/2013 07:55 AM, Yostin Vargas wrote:
My table is like this
Column | Type| Modifiers
--+---__+-__--__--
id_fld | integer | not null default
nextval('t
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 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 to make t
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 p
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
> 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
nextval
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 conn
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
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 h
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 informatio
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 broken
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 ea
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 a
On Thu, Oct 31, 2013 at 11:51 AM, Gary Fu 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 postgres log
> files.
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 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
> performing a DB ope
On Thu, Oct 31, 2013 at 11:51 AM, Gary Fu 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 files.
> As far as I
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 Hstore::TooBig
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?
http://w
On Oct 31, 2013, at 4:44 PM, Adrian Klaver 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 9.x, or is it st
On Oct 31, 2013, at 4:44 PM, Adrian Klaver 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 9.x, or is it st
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 a
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 C:/Progra
54 matches
Mail list logo
