you just have a hardware problem with your
> storage.
We use fusionio ssd cards for storage. If there is something wrong with them I
would expect more problems than I am currently experiencing, and more random
problems...
/Lars
--
Sent via pgsql-general mailing list (pgsql-ge
archived log file give the symptoms we are seeing?
Would not Postgresql detect that the logfile was corrupt?
Are there some way I can analyze archived logs files to see if this is the
problem?
Regards
Lars Arvidson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make ch
only have one log row and that
looks similar to the other once and it was triggered by an insert "ERROR: could
not read block 2023 in file "base/16390/22841": read only 0 of 8192 bytes". The
offending file was an index. This problem was fixed with a VACCUM FULL on the
table
Thanks all for the help and insights. I will continue to read up on
the details of partitioning and pgpool.
best regards,
Lars
On Thu, Oct 11, 2012 at 2:47 AM, Gavin Flower
wrote:
> On 11/10/12 12:41, Tom Lane wrote:
>>
>> Gavin Flower writes:
>>>
>>> On 11
best practices?
best regards,
Lars Helge Øverland
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ment to the list there as well as a
> potentially useful tool. I figure it is worth noting this on the list
> because I can't imagine I am the only one doing this.
Yes, thanks. I could announce it too, in case the list is writeable for me.
--
Regards,
Lars Kanis
--
Sent via pgsql-general
y) or postgres-pr.gem (pure Ruby)
* Test mode which doesn’t do any changes to the DBMS
Homepage: https://github.com/larskanis/pg-ldap-sync
Is it something useful for someone apart of mine?
--
Kind regards,
Lars Kanis
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make ch
backend;"
I check the firewall logs and it seems like some responses get blocked in the
firewall could this be slow response or some kind of keep alive response.
Are there some settings to make the Pgsql db server to work better with a
firewall request/response the KeepAlive is turned off.
for 8.2.5, it installed fine.
Then I uninstalled 8.2.5 and launched the installer for 8.3 again, this
time using the same complex password I had successfully used to get
8.2.5 running - and voila, the install goes just fine.
Really too bad that the new installer does not specify why the creation
fa
ng buying these.
However, I'm probably going to kill myself if I find a new edition for
sale only a short while after I've bought them. Are there any plans to
release an updated set in the near future?
--
Lars Haugseth
"If anyone disagrees with anything I say, I am quite prepared no
ituation is a transaction that
touches the rows in a transaction and
keeps the transaction alive before vacuum runs.
- --
Viele Grüße,
Lars Heidieker
[EMAIL PROTECTED]
http://paradoxon.info
-
Mystische Erklärungen:
Die mystischen Erklärungen gelten für tie
let the database work out the new primary key itself.
If your primary key is a column named 'id' of type 'serial', you can
copy a record like this:
INSERT INTO my_table
SELECT nextval('table_name_id_seq'), foo, bar, baz, ...
FROM my_table
WHERE id =
--
L
-lpq
--
Viele Grüße,
Lars Heidieker
[EMAIL PROTECTED]
http://paradoxon.info
Mystische Erklärungen.
Die mystischen Erklärungen gelten für tief;
die Wahrheit ist, dass sie noch nicht einmal oberflächlich sind.
-- Friedrich Nietzsche
PGP.sig
Descrip
t mean we don't like postgres very much indeed :)
to get an idea of what drbd does for you, please,
if you are interessted, read some of the
http://www.drbd.org/publications.html,
maybe start with the LinuxConf 2007 pdf.
cheers,
--
: Lars EllenbergTel +43-1-8178
u can see, all of these command line utilities accept the -W
parameter followed by the password.
Alternatively you can configure PostgreSQL to allow connections
from certain clients without password authentication:
http://www.postgresql.org/docs/8.2/static/client-authentication.html
--
Lars Haugs
ms to be outdated. As far as I know it was supposed to warn for
the HyperThreading things.
- --
Viele Grüße,
Lars Heidieker
[EMAIL PROTECTED]
http://paradoxon.info
-
Mystische Erklärungen.
Die mystischen Erklärungen gelten für tief;
die Wahrheit ist, das
h (ltlocation_id, ltlocancester_id)
VALUES (new.id, workid);
SELECT INTO workid parent FROM ltlocation WHERE id =
workid;
END LOOP;
END IF;
RETURN new;
END;
$$ LANGUAGE plpgsql;
So it handles only the cases the foreign keys can't an
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 19 Dec 2006, at 10:30, Lars Heidieker wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 19 Dec 2006, at 08:56, Alban Hertroys wrote:
Not sure as I deleted them before, but currently I cant reproduce
it.
I just get the following
erstanding.
Thanks, yes the ltlocancester_id is invalid as it was changed by the
foreign key constraint before,
in the end it turned out to be some bad interaction between the
trigger and the foreign key constraint,
as Albe Laurenz found out.
That's where I got confused.
(Yes, u
key constraint.
So it makes sense to rewrite the trigger to take only care of those
cases that aren't handled by the cascading foreign keys.
- --
Viele Grüße,
Lars Heidieker
[EMAIL PROTECTED]
http://paradoxon.info
-
Mystische Erklärungen.
Die mys
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 18 Dec 2006, at 09:37, Alban Hertroys wrote:
Lars Heidieker wrote:
Hi all,
I just started to write my first stored procedure in plpgsql and
installed a trigger for it.
The two Tables are:
CREATE TABLE ltlocation (
"id" integ
g Alban Hertroys suggested to get an
better understanding of what is going on.
- --
Viele Grüße,
Lars Heidieker
[EMAIL PROTECTED]
http://paradoxon.info
-
Mystische Erklärungen.
Die mystischen Erklärungen gelten für tief;
die Wahrheit ist, dass sie noch n
rialized
path eg for the values (25, 25)
It works OK with ignoring the exception but why is the exception
thrown in the first place.
The postgresql version 8.1.5
- --
Viele Grüße,
Lars Heidieker
[EMAIL PROTECTED]
http://paradoxon.info
-
Mystische Erkl
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 28 Nov 2006, at 13:33, Olexandr Melnyk wrote:
Looks like I've missed your mail, so a late reply.
2006/11/11, Lars Heidieker <[EMAIL PROTECTED]>:
> > > While I agree in principle that such a thing should be
> > &g
ething ?
- --
Viele Grüße,
Lars Heidieker
[EMAIL PROTECTED]
http://paradoxon.info
-
Mystische Erklärungen.
Die mystischen Erklärungen gelten für tief;
die Wahrheit ist, dass sie noch nicht einmal oberflächlich sind.
-- Friedrich Nietzsche
--
* oleg@sai.msu.su (Oleg Bartunov) wrote:
|
| On Tue, 30 May 2006, Lars Haugseth wrote:
|
| > I've setup a database using tsearch2, configured with support for compound
| > words according to the excellent guide found here:
| >
| > http://www.sai.msu.su/~megera/
s
of the text being indexed. In many situations, this will lead to a lot
of 'false' matches, seen from a user perspective.
Ideas on how to handle this problem will be much appreciated.
--
Lars Haugseth
"If anyone disagrees with anything I say, I am quite prepared not only
t one match you can use a subselect and coalesce.
>
Bruno,
Thanks for the suggestion. I've come up with the following that appears to
work:
SELECT
COALESCE((SELECT id FROM map WHERE name = $1), -1)
FROM map_level
LIMIT 1
-- Lars
--
Lars Kellogg
xpressions, but the fact that a missing
value returns 0 rows continues to foil me.
Thanks,
-- Lars
--
Lars Kellogg-Stedman <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
* Michael Paesold:
| Peter Eisentraut wrote:
| > Lars Haugseth wrote:
| > > Version 8.0.0beta2 supports a global configuration file. It's should
| > > be located in '~postgres/etc/pgsql'.
| >
| > That would be pretty useless, since normal users often don'
-17 14:00 foo.pg_dump
-rw-r--r--1 postgres users3326 2004-09-17 14:00 test.pg_dump
--
Lars Haugseth
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
e
located in '~postgres/etc/pgsql'.
--
Lars Haugseth
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
bout 10-15 postgres processes are
on my linux machine. So what can i do ?
My postgres-command is: /usr/lib/pgsql/bin/postmaster -B
2048 -i -o -F -D/var/lib/pgsql
Thanks
Lars
---(end of broadcast)---
TIP 6: Have you searched our list archi
It may be ugly, but it sure works! Here is my query:
SELECT Date, interval(trunc(date_part('epoch', time)/1800) * 1800) AS
HALFHOUR, SUM(Data)
FROM Table
GROUP BY Date, HALFHOUR;
This seems to work great, and I don't see any performance hit either.
Thanks,
-Lars
On Thu, 20 Jul
utes. Does anyone know a good way to do this?
Thanks in advance,
-Lars
35 matches
Mail list logo
