Hi,
I had a problem today and i fixed it by restarting postgres.
That doesn't seem to make sense to me, what could have been going on?
This is the log:
2014-02-26 04:30:45 CET db: ip: us: FATAL: could not send data to WAL
stream: SSL error: sslv3 alert unexpected message
cp: cannot stat
On 26 Únor 2014, 8:45, john gale wrote:
Does anybody have any ideas about this.
We restarted the postmaster and the issue persists. So previously in
9.0.4 where we could clean corruption, it seems in 9.3.2 we can no longer
clean corruption.o I'm assuming this because our data insert
This is very probably an OpenVZ issue, it can be solved by bringing down
the shared_buffers a lot.
The restart works because the server is in fact down. I think pg_lsclusters
showed online because of a stale runfile.
I was hoping that the memory allocation improvements in postgres 9.3 would
solve
Hi, we found characters with different enconding in our database. As our
system is accessed by many PCs I would like to know if it's possible to
know the encoding of each connection, without going to each PC to check
its connection string.
Regards,
--
Leonardo M. Ramé
Medical IT - Griensu S.A.
Leonardo =?iso-8859-1?Q?M=2E_Ram=E9?= l.r...@griensu.com writes:
Hi, we found characters with different enconding in our database. As our
system is accessed by many PCs I would like to know if it's possible to
know the encoding of each connection, without going to each PC to check
its
On 2014-02-26 09:48:12 -0500, Tom Lane wrote:
Leonardo =?iso-8859-1?Q?M=2E_Ram=E9?= l.r...@griensu.com writes:
Hi, we found characters with different enconding in our database. As our
system is accessed by many PCs I would like to know if it's possible to
know the encoding of each
It seems that crosstab queries assume there is going to be a value for every
possible row in the source query. That's not what I have, and I am not getting
the result I need.
Here is the definition of my source table:
CREATE TABLE plc_values
(
plc_values_key bigserial NOT NULL,
As some of you folks know I work on some pretty beefy machines. Some
of these machines don't see rest for months or days on end. And
autovacuum keeps cancelling. I set it more aggressive, it still never
finishes.
We've now had to schedule manual vacuums because autovac never
finishes on large
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/26/2014 07:56 AM, Rob Richardson wrote:
It seems that crosstab queries assume there is going to be a value
for every possible row in the source query. That?s not what I
have, and I am not getting the result I need.
snip
There is no
sparikh wrote
Hi,
My current database version is PostgreSQL 9.1.11 on
x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat
4.4.7-3), 64-bit.
I am trying to use function xpath in my query and got following error.
ERROR: function xpath(unknown, text) does not exist
Scott Marlowe escribió:
As some of you folks know I work on some pretty beefy machines. Some
of these machines don't see rest for months or days on end. And
autovacuum keeps cancelling. I set it more aggressive, it still never
finishes.
No matter how heavily updated, regular activity should
sparikh wrote
Thanks David for your quick response. My original objective was to get the
value of a particular node in xml which is stored as text datatype in the
table.
For example :
?xml version=1.0?
-
settings
-
F999
amperage
16
/amperage
amperagesteps/
/F
/settings
I
I'm having a very strange problem where any queries I make that have more
than 1692 characters in them hang forever (cancel backend doesn't work
either). It only happens on my computer which is OSX 10.9 and I've tried
psql 9.2.1 and 9.3.3. The server is 9.2.2 and it only happens when querying
this
On 02/26/2014 12:09 PM, Jason McKellar wrote:
I'm having a very strange problem where any queries I make that have
more than 1692 characters in them hang forever (cancel backend doesn't
work either). It only happens on my computer which is OSX 10.9 and I've
tried psql 9.2.1 and 9.3.3. The server
On Wed, Feb 26, 2014 at 8:15 AM, Scott Marlowe scott.marl...@gmail.comwrote:
As some of you folks know I work on some pretty beefy machines. Some
of these machines don't see rest for months or days on end. And
autovacuum keeps cancelling. I set it more aggressive, it still never
finishes.
On Wed, Feb 26, 2014 at 9:56 AM, Alvaro Herrera
alvhe...@2ndquadrant.com wrote:
Scott Marlowe escribió:
As some of you folks know I work on some pretty beefy machines. Some
of these machines don't see rest for months or days on end. And
autovacuum keeps cancelling. I set it more aggressive, it
On Feb 26, 2014, at 2:59 AM, Tomas Vondra t...@fuzzy.cz wrote:
On 26 Únor 2014, 8:45, john gale wrote:
munin2=# delete from testruns where ctid = '(37069305,4)';
ERROR: tuple concurrently updated
AFAIK this error is raised when a before trigger modifies the row that is
being deleted.
On Wed, Feb 26, 2014 at 1:34 PM, Scott Marlowe scott.marl...@gmail.comwrote:
On Wed, Feb 26, 2014 at 9:56 AM, Alvaro Herrera
alvhe...@2ndquadrant.com wrote:
Scott Marlowe escribió:
As some of you folks know I work on some pretty beefy machines. Some
of these machines don't see rest for
On 02/26/2014 08:56 AM, Alvaro Herrera wrote:
...
No matter how heavily updated, regular activity should not cause
autovacuum kills. Only heavier operations would do that (say ALTER
TABLE, etc).
Considered harmful got my attention. What, if any, known harm is caused?
We have many errors of
On 02/26/2014 04:40 PM, Steve Crawford wrote:
On 02/26/2014 08:56 AM, Alvaro Herrera wrote:
...
No matter how heavily updated, regular activity should not cause
autovacuum kills. Only heavier operations would do that (say ALTER
TABLE, etc).
Considered harmful got my attention. What, if any,
Hi All,
According to the documentation
here:http://www.postgresql.org/docs/9.1/static/libpq-ssl.html
For backwards compatibility reasons sslmode=require works the same as
sslmode=verify-ca if a root certificate is put into place.
From what I can tell sslmode=prefer seems to react the same.
As I
Hi all,
I am in a requirement to have multiple schema in one Database.
Schema structure will be same with respect to DB all db objetcs like
tables, procedure.
However each schema will be accessed by one one application.
Problem is as all DB objects are same, when application is calling to a
On Wed, Feb 26, 2014 at 11:24 PM, itishree sukla
itishree.su...@gmail.com wrote:
Hi all,
I am in a requirement to have multiple schema in one Database.
Schema structure will be same with respect to DB all db objetcs like tables,
procedure.
However each schema will be accessed by one one
23 matches
Mail list logo