Hi,
one of our pgsql instances recently started to segfault multiple times a
week. I tried a couple of things to pin it down to a certain query
or job but failed to find any pattern. All I can offer is some notes
and a set of similar looking back traces.
Thanks in advance.
Machine details
Alvaro Herrera wrote:
pgsql wrote:
Hi,
one of our pgsql instances recently started to segfault multiple times a
week. I tried a couple of things to pin it down to a certain query
or job but failed to find any pattern. All I can offer is some notes
and a set of similar looking back traces
Tom Lane wrote:
pgsql writes:
Looking at debug_query_string in the core dumps would
at least show what SQL command is calling the function(s) --- and I
wouldn't be surprised if there's exactly one function involved here.
Content of debug_query_string:
core.21207
$1 = 63106368
cor
Tom Lane wrote:
pgsql writes:
Tom Lane wrote:
Looking at debug_query_string in the core dumps would
at least show what SQL command is calling the function(s) --- and I
wouldn't be surprised if there's exactly one function involved here.
Content of debug_query_string:
cor
Tom Lane wrote:
pgsql writes:
Tom Lane wrote:
Um, that's not too helpful, we want to see the string it's pointing at.
Sorry about that. All statements are calling one of two pl/pgsql
functions. While that information already helps me a lot, it'll take me
a while to step t
mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
thon2.4/site-packages/yum/comps.py", line 23, in ?
iterparse = cElementTree.iterparse
AttributeError: 'module' object has no attribute 'iterparse'
root@s1 [/000/yuyuyum/2012/2012]#
2012/3/10, Adrian Klaver-3 [via PostgreSQL]
:
>
>
> On 03/09/2012 07:48 PM, PgSQL wr
3:28 -0800, Adrian Klaver wrote:
>> On 03/10/2012 09:59 AM, PgSQL wrote:
>> > Thanks.
>> >
>> > You can see:
>> >
>> > root@s1 [/000/yuyuyum/2012/2012]# yum install mx
>> > Traceback (most recent call last):
>> > File "/usr/bin
Thanks..
>>>Is there another mechanism to install mx, other than yum in the mean time?
I unknow if exist.
But I need YUM in my CentOs 5.7
:'(
Any command, any form please???
2012/3/10, Adrian Klaver-3 [via PostgreSQL]
:
>
>
> On 03/10/2012 09:59 AM, PgSQL wrote:
>&
Thanks Martin.
Sure!, I download this packages to same folder, but I used:
rpm -Uvh *.rpm
to install all this packages.
PD:
mi ingles es pobre, mi lenguaje es español.
Gracias
2012/3/12, Martin Gregorie-2 [via PostgreSQL]
:
>
>
> On Sat, 2012-03-10 at 14:08 -0800, PgSQL wrote:
>
I'm writing the database backend to a web application. Being paranoid I
want to limit the damage/exposure that the application can do.
One way would be to create a database user for each application user
(i.e. login name) and to create views for each user, not giving them any
permissions on sens
On Wed, May 02, 2001 at 05:50:49PM -0700, [EMAIL PROTECTED] wrote:
> > Instead of making a kajillion views
>
> I limit what others can see using php scripting:
Wrong approach for me. I am not writing the php scripts and I don't
want to trust those who are. Even if I were writing the scripts, I
I was trying this example program out of a well known postgresql book and keep
getting errors whenever I try to compile.
Error messages ##make client1
cc -g -I /usr/include -I /usr/include/pgsql -I /usr/include/pgsql/server -c
-o client1.o client1.c
cc -g client1.o -L /usr/lib -L /usr/lib
- 192.168.1.201 us...@a.domain.tld >
DETAIL: Connection matched pg_hba.conf line 87: "host all
all 192.168.1.0/24 gss include_realm=1
map=testnet krb_realm=A.DOMAIN.TLD"
Is this something that is possible, or is it something where I need to
pick one way to do it?
Thanks in advance,
Ryan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ap:
$ psql -h db0 #Implied -U user1 -d user1
$ psql -h db0 -U user1 -d user1
I can get one style or the other to work, but I just can't get both to work a
the same time.
If this is something that can't be done, I understand, but it looks like it should be possible per
the documentation.
Thanks,
Ryan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
relationship.
HTH,
Rob
Hi Rob,
How would that work? I was under the impression the first column was for socket type and limited to
local, host, hostssl, and hostnossl?
Thunderbird's config has been fixed, so here is the line from pg_hba.conf line without the
formatting issues:
h
f works. Setting the maps below maps the users straight across. 'user1' == 'user1' and
'us...@a.domain.tld' == 'us...@a.domain.tld', so it's partially working.
pg_indent.conf:
testnet /^([0-9A-Za-z_-]+)@A\.DOMAIN\.TLD$ \1
testnet /^([0-9A-Za-z_-]+)@A\.DOMAI
rovide a better
example.
Cheers,
Rob
Hi Rob,
That's my understanding of the syntax and workflow from the reading and
small experiments I've done as well.
There's two of us, so we're on our way to a consensus. :)
Thanks!
Ryan
--
Sent via pgsql-general mailing list (pg
Demokratie gefordert 85. M. und
Demokratie 412. M. und Judentum 350 f., 352, 498. Staatsauffassung 420. V
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
s!
--
Ian Smith
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
d into code
that got run a LOT and so that was causing those tables to grow out
of control.
With that query removed I am no longer seeing the db expand.
Thanks for the hints!
--
Ian Smith
www.ian.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi all,
I'm looking into PostgreSQL. Coming from a MySQL
background, I have made heavy use of its very useful
GROUP_CONCAT function. You can read about the function
here:
http://dev.mysql.com/doc/refman/4.1/en/group-by-functions.html
Is there a PostgreSQL alternative to GROUP_CONCAT?
Thanks,
K
Hi,
I got stuck with the following problem and strangely couldn't find
anything similar in the list:
Assume two tables:
table: warehouse, columns: id, incoming, outgoing
table: articles, columns: id, articles_in_stock
All I want is to create a rule, that everytime when articles leave or
get in t
hello,
I have read the documentation couple of times and I still can not figure
out
the following aspects.
if a function does insert/update/delete it needs to be stable or
volatile ?
if a immutable function executes 'nextval' should itself be also
volatile ?
thanks,
Razvan Radu
---
Hello everybody,
Since I am new to PostgreSQL mailing lists, I am not sure which mailing list to
use for my problem, I issue it to this group. If there is a more appropriate
list, please let me know and I will happily post there.
The situation:
While porting an existing application from Sybase
Hello,
We have been putting a lot of work into Part IV of the book.
We would appreciate some fresh feedback on the chapters 9 and 10.
As always, the link:
http://www.opendocspublishing.com/entry.lxp?lxpe=92
Thanks!
OpenDocs
---(end of broadcast)--
Hello,
Heh... I wrote that :)
J
On Sat, 2 Jun 2001, Michael wrote:
> http://www.zend.com/zend/art/databases.php
>
> Needless to say Postgresql comes out looking pretty good. Good to have
> links like this to show the advantages of Postgresql when I'm trying to
> convert others to using it.
>
>
Hello,
We have decided that we will not be including GreatBridge PostgreSQL and
instead will be focussing on the community released version.
As always updated information on the book can be found on the web at:
http://www.opendocspublishing.com/entry.lxp?lxpe=92
Joshua Drake
-
Hi -
Issue:
How to return a sequence value generated upon INSERT of records into a
partitioned table using trigger functions (without having to insert into the
child table directly).
Current implementation:
The master table of the partitioned table uses a trigger function to
alter an inco
> On 2010-12-16, pgsql(dot)30(dot)miller_2555(at)spamgourmet(dot)com
> wrote:
> > --0015174c1e4aaf077604977d7e62
> > Content-Type: text/plain; charset=ISO-8859-1
> >
> > Hi -
> >
> > Issue:
> > How to return a sequence value generated upon
00803/1390: pl/pgsql and controling loops
200803/1391: Re: pl/pgsql and controling loops
200803/1392: dunction issue
200803/1393: Re: pl/pgsql and controling loops
200803/1394: Re: pl/pgsql and controling loops
200803/1395: Re: Survey: renaming/removing script binaries (createdb,
with Mono?
200803/1345: Using tables in other PostGreSQL database
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
3/1378: Re: Timezones in 8.2.7
200803/1379: Re: Survey: renaming/removing script binaries (createdb,
createuser...)
200803/1380: Re: Survey: renaming/removing script binaries (createdb,
createuser...)
200803/1381: Re: Using tables in other PostGreSQL database
--
Sent via pgsql-general ma
: Re: Performance of update
200803/1362: Re: returned value from SQL statement
200803/1363: Re: Using tables in other PostGreSQL database
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
createuser...)
200803/1420: Re: Survey: renaming/removing script binaries (createdb,
createuser...)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Message Digest
Volume 1 : Issue 8036 : "index" Format
Messages in this Issue:
200803/1440: Re: Need help on how to backup a table
200803/1441: Persistent user-defined functions
200803/1442: Merge Joins and Views
200803/1443: Re: Persistent user-defined functions
200803/1444
tables in other PostGreSQL database
200803/1424: Re: Survey: renaming/removing script binaries (createdb,
createuser...)
200803/1425: Re: Survey: renaming/removing script binaries (createdb,
createuser...)
200803/1426: Re: trouble selecting from array
200803/1427: pl/pgsql debugger rpms?
2
3/1471: Re: table of US states' neighbours
200803/1472: Re: Survey: renaming/removing script binaries (createdb,
createuser...)
200803/1473: Re: Persistent user-defined functions
200803/1474: Re: Users, groups and inheritance questions
--
Sent via pgsql-general mailing list (pgsql-general
Where does PostgreSQL rank nulls when sorting a column of timestamps, is this
behaviour deterministic, and can I rely on it not changing in the future?
Apologies if this shows up as a repost, I've had gateway problems at this end.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinion
Many thanks Tom. Inconvenient from the point of view of the application but
still useful information.
The situation is that I've got a query with numerous subselects, each of which
has to return exactly one row so I was doing a union with a nulled record then
selecting the most recent: obviously I
On Sat, Apr 15, 2006 at 10:31:26AM -0400, Francisco Reyes wrote:
> [EMAIL PROTECTED] writes:
>
> >Usage is to match data from the key and val tables to fetch the data
> >value from the sid table.
>
> What is the relation between key and val tables?
> Will key.id and val.id be equal?
This benchma
I have a benchmark test which runs a query very slowly under certain
circumstances. I used Ethereal to capture the packet traffic, and
also enabled debug5 logging out of curiousity. While the slow query
is in progress, there is no log or packet activity, but the cpu is
busy. These packets are be
Can a single database be split over multiple filesystems, or does the
filesystem size under e.g. Linux (whatever it is these days) constrain
the database size?
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or
colleagues]
--
Ian Willis wrote:
>
> Postgresql transparently breaks the db into 1G chunks.
Yes, but presumably these are still in the directory tree that was
created by initdb, i.e. normally on a single filesystem.
> The main concern is during dumps. A 10G db can't be dumped if the
> filesustem has a 2G limi
Marco Colombo wrote:
> BTW, the document contains some limits. FS size limit is reported to be
> 2TB (block-device size limit). I don't know if it applies to LVM logical
> volumes. Ext2 FS size limit is 16TB (for 4kB blocks FS). You need to put
> some effort to place 16TB on a single FS.
Thanks
Martijn van Oosterhout wrote:
> What the limit on NT?
I'm told 2^64 bytes. Frankly, I'd be surprised if MS has tested it :-)
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or
colleagues]
---(end of
I'm successfully storing
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or
colleagues]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister com
Tony Grant wrote:
>
> These are film and director pages in a movie site. I am looking at
> HTML->XML tools then with a parser I should be able to create a tab
> delimited text file.
I'm successfully storing scripts in tables which are pulled and executed
on a client system, works well so far exc
Justin Clift wrote:
>
> Did you get any feedback on this? :-)
Unfortunately not, but I live in hope. [If you live in Hope, you'll die
in Caergwrle]. I can afford very little time to play with it at present,
however I'll come back to it as soon as I can since one of our ongoing
issues is trying t
Hello,
this fails with "duplicate key value":
CREATE TABLE x (
i INT NOT NULL UNIQUE
);
INSERT INTO x (i) VALUES (1), (2), (3);
UPDATE x SET i = i + 1;
are there any plans to make this work?
--
Roman Neuhauser
--
Sent via pgsql-general mailing list (pgs
50 matches
Mail list logo
