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
`/data/
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 e
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.
Av
Leonardo =?iso-8859-1?Q?M=2E_Ram=E9?= 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 connection string.
If
On 2014-02-26 09:48:12 -0500, Tom Lane wrote:
> Leonardo =?iso-8859-1?Q?M=2E_Ram=E9?= 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 g
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,
recorded_dat
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 heav
-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.
> There is no relatio
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
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 shoul
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 :
>
>
>
> -
>
> -
>
>
> 16
>
>
>
>
> I want to extract the value of amperage as '16'. Like that
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 wrote:
> 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 sc
On Wed, Feb 26, 2014 at 9:56 AM, Alvaro Herrera
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 still never
>> fi
On Feb 26, 2014, at 2:59 AM, Tomas Vondra 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. Imagin
On Wed, Feb 26, 2014 at 1:34 PM, Scott Marlowe wrote:
> On Wed, Feb 26, 2014 at 9:56 AM, Alvaro Herrera
> 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
> >> autovacu
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
sch
On Wed, Feb 26, 2014 at 11:24 PM, itishree sukla
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 application.
>
> Pr
23 matches
Mail list logo
