Re: [GENERAL] Postgres forums ... take 2
On Mon, Dec 20, 2010 at 7:26 PM, Thom Brown t...@linux.com wrote: I know this topic has gone quiet, I still think it's worth investing time and resources in. I don't expect any progress to be made until the new year now, but I hope we can continue this after the Christmas period is over. And nice work collating the discussions so far onto the wiki. That should make it easier for everyone to keep up with developments :) I would like to be more involved in this! I've got lots of time to devote and available resources so let me know what is needed. I would like to see this grow into a full dedicated official web forums. -Carlos Mennens -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Row-level permissions?
Is it possible, with PostgreSQL 9.0, to restrict access to specific table rows by `id`? I want a user to be able to INSERT new rows but not UPDATE or DELETE rows with `id` 1616. gvim -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Row-level permissions?
On 30 December 2010 16:30, gvim gvi...@gmail.com wrote: Is it possible, with PostgreSQL 9.0, to restrict access to specific table rows by `id`? I want a user to be able to INSERT new rows but not UPDATE or DELETE rows with `id` 1616. gvim I think the simplest way would be creating a trigger in which you would check all operations you want to restrict. regards Szymon
Re: [GENERAL] Row-level permissions?
On Thu, Dec 30, 2010 at 7:30 AM, gvim gvi...@gmail.com wrote: I want a user to be able to INSERT new rows but not UPDATE or DELETE rows ... This part is easily done: http://www.postgresql.org/docs/9.0/interactive/sql-grant.html http://www.postgresql.org/docs/9.0/interactive/sql-revoke.html http://www.postgresql.org/docs/9.0/interactive/sql-createrole.html ... with `id` 1616. This cannot be done using ordinary DDL. -- Regards, Richard Broersma Jr. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Cursors WITH HOLD
Hello. I use Postgres 8.4.5 via perl DBI. And i try to use cursors WITH HOLD to materialize often used queries. My question is how many cursors may be declared per session and which memory setting s to adjust for them ? regards. pasman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Understanding Roles Grant Options
I've been reading the documentation and I'm trying to understand what 'GRANT' options make up a 'superuser' in PostgreSQL. I've got my account which is 'carlos' and then I have an account called 'jason'. Can someone please explain the difference between the two roles: postgres=# \dg List of roles Role name | Attributes | Member of ---+--+--- carlos | Superuser| {it} it| Cannot login | {} jason | Create role | {it} : Create DB postgres | Superuser| {} : Create role : Create DB Obviously 'Carlos' is a superuser but what does that exactly entail beyond CREATEDB CREATEROLE? http://www.postgresql.org/docs/8.1/static/app-createuser.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Understanding Roles Grant Options
Carlos Mennens carlos.menn...@gmail.com writes: I've been reading the documentation and I'm trying to understand what 'GRANT' options make up a 'superuser' in PostgreSQL. Superuser-ness is not a grantable privilege; it's an attribute of a role. See CREATE/ALTER ROLE. Obviously 'Carlos' is a superuser but what does that exactly entail beyond CREATEDB CREATEROLE? A superuser succeeds at any privilege test whatsoever. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Restore problem
Le mercredi 29 décembre 2010 à 11:09 -0800, Tim Bruce - Postgres a écrit : On Wed, December 29, 2010 10:59, John R Pierce wrote: I'd also like to throw in Context for Windows as an Editor. It's also free and has syntax highlighting for almost everything imaginable (on Windows and *ix). I'm partial to Emacs, but I'm surprised nobody mentionned Abiword : http://www.abisource.com/ -- Vincent Veyron http://marica.fr/ Progiciel de gestion des dossiers de contentieux et d'assurance pour le service juridique -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Restore problem
On Thu, Dec 30, 2010 at 06:02:54PM +0100, Vincent Veyron wrote: I'm partial to Emacs, but I'm surprised nobody mentionned Abiword : http://www.abisource.com/ I think Abiword would be a very bad editor for any kind of database work, no? It's intended as a word processor rather than a text editor, isn't it? A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Automate Scripts to make for managing Large Database Servers.
On Wed, Dec 29, 2010 at 11:20 PM, Adarsh Sharma adarsh.sha...@orkash.com wrote: Dear all, I am working on some common tasks that need to be performed on regular intervals in a large Database Servers. I find below lists of tasks that need to be performed and Please tell me if i missed some. 1. Tacking Daily, Weekly Backups. 2. Finding Space Occupied and Remaining in Data Paths or Hard Disks. 3. Performing Updates of Softwares. 4. Checking Servers Power Status. Please guide me some more tasks that need a proper attention. That looks like a good start. I recommend looking at the check_postgres.pl documentation ( http://bucardo.org/check_postgres/check_postgres.pl.html ) for ideas on more things to check. And of course, using that package will make the actual monitoring easy as well. Josh -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] query stuck at SOCK_wait_for_ready function call
Hi All I am using postgres-8.1.2 and have been using psqlodbc-08.03.0200 driver to connect to the databse. One of the queries I executed from my appilcation have got stuck for an indefinite amount of time causing my application to hang. So I cored the application. The core file gives a backtrace which shows it got stuck while waiting for a socket to get ready as follows : #0 0xb7fe4410 in ?? () #1 0xbfca07b8 in ?? () #2 0x in ?? () #3 0x0001 in ?? () #4 0xb7d0fdc4 in poll () from /lib/tls/libc.so.6 #5 0xb6fef7b4 in SOCK_wait_for_ready (sock=0x87171d0, output=0, retry_count=1) at socket.c:529 #6 0xb6fefe9a in SOCK_get_next_byte (self=0x87171d0, peek=0) at socket.c:929 #7 0xb6ff005c in SOCK_get_id (self=0x87171d0) at socket.c:692 ---Type return to continue, or q return to quit--- #8 0xb6fc851b in CC_send_query_append (self=0x8717d30, query=0x87222c0 SELECT RUMaster(2) AS call_proc_result, qi=0x0, flag=0, stmt=0x8720730, appendq=0x0) at connection.c:2524 #9 0xb6ff9bb4 in SC_execute (self=0x8720730) at statement.c:1838 #10 0xb6fda7b6 in Exec_with_parameters_resolved (stmt=0x8720730, exec_end=0xbfca2be8) at execute.c:386 #11 0xb6fdbe62 in PGAPI_Execute (hstmt=0x8720730, flag=1) at execute.c:1062 #12 0xb70038ea in SQLExecute (StatementHandle=0x8720730) at odbcapi.c:374 #13 0xb7e8713c in SQLExecute (statement_handle=0x8720158) at SQLExecute.c:283 Can anyone please let me know what can cause this. Even if it didnt find the socket ready , why not it simply come out giving some error instead of getting stuck for an indefinite period. Thanks... Tamanna
Re: [GENERAL] query stuck at SOCK_wait_for_ready function call
On 30/12/2010 10:28, tamanna madaan wrote: Hi All I am using postgres-8.1.2 and have been using psqlodbc-08.03.0200 driver to connect I'd imagine you're going to get a *flood* of responses saying this, but here goes anyway - the version of Postgres you're using is VERY old, and missing 21 sets of bug fixes; the 8.1 branch is up to 8.1.23. In fact, to my knowledge the entire 8.1 branch is end-of-life; certainly on Windows anyway. I can't shed any light on your problem, but you should certainly upgrade if you can, as there's a fair chance that your problem might arise from a bug fixed in a later version. Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] query stuck at SOCK_wait_for_ready function call
tamanna madaan tamanna.ma...@globallogic.com writes: I am using postgres-8.1.2 and have been using psqlodbc-08.03.0200 driver to connect to the databse. One of the queries I executed from my appilcation have got stuck for an indefinite amount of time causing my application to hang. Are you sure you didn't simply issue a very long-running query? Or one that is waiting for a lock? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] 2 versions of an entity worth distinct table?
gvi...@gmail.com (gvim) writes: If a table representing contact details can have 2 but no more than 2 email addresses is it really worth factoring-out email addresses to a separate table. Technically it's a 1-to-many relationship so should be done this way but what is the general practice out there in such max. 2 situations? Keeping them as: Primary Email Secondary Email also preserves priority though not strictly normalised, I know. I'd be inclined to normalize this, as it's: a) difficult to guarantee that it will only ever be 2. b) mighty nice to be able to attach validation rules to ONE simple email table, rather than having to put them on several columns possibly spread across more tables. -- wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','gmail.com'). http://linuxfinances.info/info/internet.html If nothing ever sticks to Teflon, how do they make Teflon stick to the pan? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Standard schemas for common features?
gvi...@gmail.com (gvim) writes: I'm putting together a database for a web project which has a lot of HR components which I imagine are fairly standardised so, to avoid re-inventing the wheel, is there a source of standard, downloadable schemas for common projects? One might imagine so... The last time I was looking for such (albeit not specifically in an HR context), what I found was that there were enough local complications resulting from the vagaries of local company structure that the bits that could be treated as standard were minor in comparison to the specialized structures. There are things that get pretty ugly when you try to go standardised: - You're sure to use addresses... Will they be: a) Something localized to your country, complete with constraints encoded in the schema? (e.g. - as with telephone number formats, zip codes, states, and such) b) Something intended to be generic across multiple countries? In that case, the schema generally CANNOT enforce country-specific rules, thereby increasing the risk of the data turning into crud - What normalization do you do concerning employees and their attributes? It's attractive to keep the model simple, but if there are legal requirements to track information about applicants (who may never actually become employees), simple mayn't be an option. - What genders do you store? Male/Female actually *isn't* specific enough, with the simple counterexample where someone fails to specify a value. (Which oughtn't be controversial even to folk that might be uncomfortable with more, erm, outre gender options...) - You operate in some legal jurisdiction. (or perhaps several?) Different jurisdictions assortedly require or forbid the collection of particular pieces of information, and may require that to be encoded into your schema. What is allowed/forbidden will vary, and if you operate in multiple jurisdictions, there's some need to follow *all* of the legal impositions. A generic schema leads to considerable risk of allowing in nonsense data, whilst *my* non-generic schema is quite likely to be terrible for *you* when you have somewhat different business requirements. There are enough conflicts available across these issues to mean that you shouldn't just take the first sample schema you might happen across. -- wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','linuxfinances.info'). http://linuxfinances.info/info/slony.html Always remember that you're unique, just like everyone else. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] The system cannot execute the specified program in windows xp (service pack 3)
Dear All,We are using Postgresql 9.0.1(binary) in our Java Application.In some windows xp sp3 machines, we found that the executable files related to postgresql are not working. while executing those files(ex: initdb.exe), following error thrown in console "The system cannot execute the specified program" .Other executable files not related to postgresql working fine.By comparing working and non-working machines, came to know that some *.VC90.* files and directories are missing from C:\Windows\WinSxS\Then we copied *.VC90.* related files and directories from C:\Windows\WinSxS\Manifests\ ,C:\Windows\WinSxS\Policies\ (working system) to non-working system.After that, executable files under postgresql seems to be working but facing locale problems.(ex:Informations are in swedish).If any one knows please help me out.Thanks in Advance.Thanks,Prabakaran A
Re: [GENERAL] The system cannot execute the specified program in windows xp (service pack 3)
On 12/30/10 6:39 AM, prabakaran.a wrote: Dear All, We are using Postgresql 9.0.1(binary) in our Java Application. In some windows xp sp3 machines, we found that the executable files related to postgresql are not working. while executing those files(ex: initdb.exe), following error thrown in console The system cannot execute the specified program .Other executable files not related to postgresql working fine. By comparing working and non-working machines, came to know that some *.VC90.* files and directories are missing from C:\Windows\WinSxS\ Then we copied *.VC90.* related files and directories from C:\Windows\WinSxS\Manifests\ ,C:\Windows\WinSxS\Policies\ (working system) to non-working system. After that, executable files under postgresql seems to be working but facing locale problems.(ex:Informations are in swedish). If any one knows please help me out. Blindly copying files into the Windows Side by Side assembly cache sounds very sketchy to me. My guess is, those systems need the VC90 runtime redistributables package installed. http://www.microsoft.com/downloads/en/details.aspx?familyid=a5c84275-3b97-4ab7-a40d-3802b2af5fc2displaylang=en http://www.microsoft.com/downloads/en/details.aspx?familyid=a5c84275-3b97-4ab7-a40d-3802b2af5fc2displaylang=en -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] seg fault crashed the postmaster
Hi, Running Centos, just upgraded our production db from 8.4.4 to 9.0.2 last night. About 20 hours later, an update statement seg faulted and crashed the server. This is a typical update that has worked fine for a long time. 20898 datafeed (58628) 2010-12-30 19:28:14 EST [103]LOG: process 20898 acquired ShareLock on transaction 1286738762 after 90174.969 ms 20898 datafeed (58628) 2010-12-30 19:28:14 EST [104]STATEMENT: update v_messages set status = 'S', updated_on = now() where id in (select id from v_messages where author_id = 34409854 and status != 'S' limit 1) 5802 2010-12-30 19:28:14 EST [4]LOG: server process (PID 20898) was terminated by signal 11: Segmentation fault 5802 2010-12-30 19:28:14 EST [5]LOG: terminating any other active server processes 15426 pipeline (36834) 2010-12-30 19:28:14 EST [1]WARNING: terminating connection because of crash of another server process15426 pipeline 10.10.11.54(36834) 2010-12-30 19:28:14 EST [2]DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server pro cess exited abnormally and possibly corrupted shared memory. One hint that something might be wrong was this: 18235 datafeed (44228) 2010-12-30 18:16:37 EST [11]LOG: process 18235 acquired ShareLock on transaction 1285952031 after 29966.703 ms 18235 datafeed (44228) 2010-12-30 18:16:37 EST [12]STATEMENT: update v_messages set status = 'S', updated_on = now() where id in (select id from v_messages where author_id = 25301995 and status != 'S' limit 1) 18235 datafeed (44228) 2010-12-30 18:16:43 EST [13]ERROR: compressed data is corrupt 18235 datafeed (44228) 2010-12-30 18:16:43 EST [14]STATEMENT: update v_messages set status = 'S', updated_on = now() where id in (select id from v_messages where author_id = 25301995 and status != 'S' limit 1) How concerned should I be? Thanks! Gordon -- View this message in context: http://postgresql.1045698.n5.nabble.com/seg-fault-crashed-the-postmaster-tp3323117p3323117.html Sent from the PostgreSQL - general 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
Fwd: [GENERAL] Postgres forums ... take 2
Sorry folks, this is an old message I forgot to copy pgsql-general on. Begin forwarded message: From: Elliot Chance elliotcha...@gmail.com Date: 21 December 2010 11:48:07 AM AEDT To: Thom Brown t...@linux.com Subject: Re: [GENERAL] Postgres forums ... take 2 On 21/12/2010, at 11:26 AM, Thom Brown wrote: On 29 November 2010 04:31, Elliot Chance elliotcha...@gmail.com wrote: Discussion will continue on the wiki page: http://wiki.postgresql.org/wiki/Forums_at_postgresql.com.au Even though the discussion has moved I still intent to keep pushing the issues to a resolution. The wiki is not shelving the idea for another time. I know this topic has gone quiet, I still think it's worth investing time and resources in. I don't expect any progress to be made until the new year now, but I hope we can continue this after the Christmas period is over. And nice work collating the discussions so far onto the wiki. That should make it easier for everyone to keep up with developments :) Yeah, most people are either away or busy with holiday plans. I intended to revisit this in January. When the attention rises again I might have to start enforcing dead lines otherwise it could drag out forever. Dead lines and caffeine seem to be the only things that gets a developers attention... Everyone have a good christmas! -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935
Re: [GENERAL] Postgres forums ... take 2
On 31/12/2010, at 12:43 AM, Carlos Mennens wrote: On Mon, Dec 20, 2010 at 7:26 PM, Thom Brown t...@linux.com wrote: I know this topic has gone quiet, I still think it's worth investing time and resources in. I don't expect any progress to be made until the new year now, but I hope we can continue this after the Christmas period is over. And nice work collating the discussions so far onto the wiki. That should make it easier for everyone to keep up with developments :) I would like to be more involved in this! I've got lots of time to devote and available resources so let me know what is needed. I would like to see this grow into a full dedicated official web forums. -Carlos Mennens I just forwarded an old message, you should see it on the mailing list. I don't think many people are interested in doing work right around the christmas period, so I wanted to give some time to let all that pass. The more help the better! At the moment the major priority is discussing the issues here: http://wiki.postgresql.org/wiki/Forums_at_postgresql.com.au -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] seg fault crashed the postmaster
Gordon Shannon gordo...@gmail.com writes: Running Centos, just upgraded our production db from 8.4.4 to 9.0.2 last night. About 20 hours later, an update statement seg faulted and crashed the server. This is a typical update that has worked fine for a long time. Could we see a stack trace from that? Or at least a self-contained test case? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] seg fault crashed the postmaster
I'd love to send you a stack trace. Any suggestions on how to get one? It has since happened again, on the same update command, so I'm guessing I can repeat it. On Thu, Dec 30, 2010 at 6:52 PM, Tom Lane-2 [via PostgreSQL] ml-node+3323151-436577542-56...@n5.nabble.comml-node%2b3323151-436577542-56...@n5.nabble.com wrote: Gordon Shannon [hidden email]http://user/SendEmail.jtp?type=nodenode=3323151i=0 writes: Running Centos, just upgraded our production db from 8.4.4 to 9.0.2 last night. About 20 hours later, an update statement seg faulted and crashed the server. This is a typical update that has worked fine for a long time. Could we see a stack trace from that? Or at least a self-contained test case? regards, tom lane -- Sent via pgsql-general mailing list ([hidden email]http://user/SendEmail.jtp?type=nodenode=3323151i=1) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- View message @ http://postgresql.1045698.n5.nabble.com/seg-fault-crashed-the-postmaster-tp3323117p3323151.html To unsubscribe from seg fault crashed the postmaster, click herehttp://postgresql.1045698.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=3323117code=Z29yZG8xNjlAZ21haWwuY29tfDMzMjMxMTd8LTEwNjcwMjEwNDQ=. -- View this message in context: http://postgresql.1045698.n5.nabble.com/seg-fault-crashed-the-postmaster-tp3323117p3323171.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
Re: [GENERAL] seg fault crashed the postmaster
Gordon Shannon gordo...@gmail.com writes: I'd love to send you a stack trace. Any suggestions on how to get one? It has since happened again, on the same update command, so I'm guessing I can repeat it. http://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] query stuck at SOCK_wait_for_ready function call
Thanks Tom for your reply . However, This is not a very long running query. This was supposed to update only one row in a table. Moreover, it cant be waiting for a lock as other processes were able to update the same table at the same time. restarting the process which was stuck because of this query, also resolved the issue. That means after restart, the process was able to update the same table. Had it been waiting for a lock before , it wouldn't have been able to update the table after restart either. Regards Tamanna -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Thu 12/30/2010 11:23 PM To: tamanna madaan Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] query stuck at SOCK_wait_for_ready function call tamanna madaan tamanna.ma...@globallogic.com writes: I am using postgres-8.1.2 and have been using psqlodbc-08.03.0200 driver to connect to the databse. One of the queries I executed from my appilcation have got stuck for an indefinite amount of time causing my application to hang. Are you sure you didn't simply issue a very long-running query? Or one that is waiting for a lock? regards, tom lane
Re: [GENERAL] seg fault crashed the postmaster
Stack trace: #0 0x0031a147c15c in memcpy () from /lib64/libc.so.6 #1 0x00450cb8 in __memcpy_ichk (tuple=0x7fffb29ac900) at /usr/include/bits/string3.h:51 #2 heap_copytuple (tuple=0x7fffb29ac900) at heaptuple.c:592 #3 0x00543d4c in EvalPlanQualFetchRowMarks (epqstate=0x3cd85ab8) at execMain.c:1794 #4 0x005440db in EvalPlanQual (estate=0x1e0db420, epqstate=0x3cd85ab8, relation=value optimized out, rti=4, tid=0x7fffb29aca20, priorXmax=value optimized out) at execMain.c:1401 #5 0x005592eb in ExecUpdate (node=0x3cd85a28) at nodeModifyTable.c:527 #6 ExecModifyTable (node=0x3cd85a28) at nodeModifyTable.c:748 #7 0x00545953 in ExecProcNode (node=0x3cd85a28) at execProcnode.c:359 #8 0x00544881 in ExecutePlan (queryDesc=0x1e727990, direction=1039265768, count=0) at execMain.c:1190 #9 standard_ExecutorRun (queryDesc=0x1e727990, direction=1039265768, count=0) at execMain.c:280 #10 0x2ab002c0f2b5 in explain_ExecutorRun (queryDesc=0x1e727990, direction=ForwardScanDirection, count=0) at auto_explain.c:203 #11 0x005f9c81 in ProcessQuery (plan=0x2112ad60, sourceText=0x1b3e59e0 update v_messages set status = 'S', updated_on = now() where id in (select id from v_messages where author_id = 33138761 and status != 'S' limit 1), params=value optimized out, dest=0x2112ae40, completionTag=0x7fffb29ace20 ) at pquery.c:197 #12 0x005f9e99 in PortalRunMulti (portal=0x1b32aed0, isTopLevel=1 '\001', dest=0x2112ae40, altdest=0x2112ae40, completionTag=0x7fffb29ace20 ) at pquery.c:1268 #13 0x005fa965 in PortalRun (portal=0x1b32aed0, count=9223372036854775807, isTopLevel=1 '\001', dest=0x2112ae40, altdest=0x2112ae40, completionTag=0x7fffb29ace20 ) at pquery.c:822 #14 0x005f7455 in exec_simple_query ( query_string=0x1b3e59e0 update v_messages set status = 'S', updated_on = now() where id in (select id from v_messages where author_id = 33138761 and status != 'S' limit 1)) at postgres.c:1058 #15 0x005f7d14 in PostgresMain (argc=value optimized out, argv=value optimized out, username=value optimized out) at postgres.c:3929 #16 0x005c7ce5 in ServerLoop () at postmaster.c:3555 #17 0x005c89ec in PostmasterMain (argc=5, argv=0x1b31ea00) at postmaster.c:1092 #18 0x005725fe in main (argc=5, argv=value optimized out) at main.c:188 On Thu, Dec 30, 2010 at 7:32 PM, Tom Lane-2 [via PostgreSQL] ml-node+3323177-1417305259-56...@n5.nabble.comml-node%2b3323177-1417305259-56...@n5.nabble.com wrote: Gordon Shannon [hidden email]http://user/SendEmail.jtp?type=nodenode=3323177i=0 writes: I'd love to send you a stack trace. Any suggestions on how to get one? It has since happened again, on the same update command, so I'm guessing I can repeat it. http://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend regards, tom lane -- Sent via pgsql-general mailing list ([hidden email]http://user/SendEmail.jtp?type=nodenode=3323177i=1) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- View message @ http://postgresql.1045698.n5.nabble.com/seg-fault-crashed-the-postmaster-tp3323117p3323177.html To unsubscribe from seg fault crashed the postmaster, click herehttp://postgresql.1045698.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=3323117code=Z29yZG8xNjlAZ21haWwuY29tfDMzMjMxMTd8LTEwNjcwMjEwNDQ=. -- If I had more time, I could have written you a shorter letter. (Blaise Pascal) -- View this message in context: http://postgresql.1045698.n5.nabble.com/seg-fault-crashed-the-postmaster-tp3323117p3323277.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.