Re: [GENERAL] InitDB: Bad system call

Hi Tom, Bad system call (core dumped) Have you tried running the initdb with strace or truss? That might give you a clue as to exactly what system call is failing. Your jail isn't allowing something fundamental here, but it's hard to guess what. Or even easier, gdb the core file ... As

[GENERAL] deadlock

We've got an app, I don't know all the details of the schema offhand, but its using date partitioned tables, its heavily multithreaded and processing continuous events... Under load, production (overseas) is getting a SQL deadlock... Process 20333: DROP table data_details_20100718 Pro

Re: [GENERAL] Is there a way to bypass sql?

On 08/10/10 10:31 PM, Samantha Atkins wrote: In many OO projects the majority of the work on persistent objects is navigational and inserts with relatively few updates. Queries are usually mainly for initial working set in many such systems and little else. When retrieving an object given a pe

Re: [GENERAL] Is there a way to bypass sql?

On Aug 9, 2010, at 11:57 AM, Merlin Moncure wrote: > On Mon, Aug 9, 2010 at 2:39 PM, samantha wrote: >> I have been digging into NoSQL of late. For navigational queries it would >> be great if there was a way to bypass SQL and directly pull from an >> identifier for a record or arbitrary byte s

Re: [GENERAL] fork() and dynamically loaded c functions....

Alvaro Herrera writes: > You probably should close any open file descriptors too, just to be > safe. (Or do we set FD_CLOEXEC on them?) We don't. It'd take an extra syscall per open(), which seems like rather a lot of overhead to deal with a case we aren't even trying to support.

Re: [GENERAL] fork() and dynamically loaded c functions....

Excerpts from Tom Lane's message of mar ago 10 19:49:18 -0400 2010: > Offhand the only clean way I can see to launch a child process is to > fork *and exec something*. You probably should close any open file descriptors too, just to be safe. (Or do we set FD_CLOEXEC on them?) -- Álvaro Herrera

Re: [GENERAL] InitDB: Bad system call

Greg Smith writes: > Torsten Zühlsdorff wrote: >> Bad system call (core dumped) > Have you tried running the initdb with strace or truss? That might give > you a clue as to exactly what system call is failing. Your jail isn't > allowing something fundamental here, but it's hard to guess what.

Re: [GENERAL] InitDB: Bad system call

Torsten Zühlsdorff wrote: selecting default max_connections ... Bad system call (core dumped) Bad system call (core dumped) Bad system call (core dumped) Bad system call (core dumped) Bad system call (core dumped) Bad system call (core dumped) 10 selecting default shared_buffers ... Bad system ca

Re: [GENERAL] MySQL versus Postgres

சிவகுமார் மா wrote: 1. Almost all webhosting providers have MySQL support, but PostgreSQL support is available from only a few who also have MySQL support. Hence MySQL is universal and PostgreSQL is present as also available. http://www.postgresql.org/support/professional_hosting lists far m

Re: [GENERAL] fork() and dynamically loaded c functions....

Jay Flattery writes: >> What exactly is that child process doing? It sure sounds like it thinks >> it's a valid backend. > Actually it's not doing anything, as I'm just trying to work it all out - > just a > bunch of printfs and waits. > But the library is a PG_MAGIC_MODULE. > I tried killin

Re: [GENERAL] fork() and dynamically loaded c functions....

Thanks for your reply >> I now fork() a process in _PG_Init() (both processes interact), but when I >> shutdown postgre I get: LOG: failed to find proc 0x1331110 in ProcArray >What exactly is that child process doing? It sure sounds like it thinks >it's a valid backend. Actually it's not doi

Re: [GENERAL] Read Committed Transaction Isolation and SELECT ... UNION ... SELECT

On Tue, Aug 10, 2010 at 6:46 PM, Tom Lane wrote: > > That's just one SELECT command.  Sub-SELECTs inside a query don't > count as separate commands for this purpose; the use of SELECT in > that way is just an artifact of the SQL grammar. Thanks. That's what I figured, but wanted to make sure. e

Re: [GENERAL] pl/pgsql editor and postgres developemnt tool

On 10/08/2010 13:54, atul.g...@globaldatapoint.com wrote: > Hi Ray, > > Thanks for reply. Are you using any editor for code formatting? I use the query editor in PgAdmin, and it works fine for me - syntax highlighting, auto-indent, keyboard shortcuts for indentation and block commenting, etc etc.

Re: [GENERAL] Read Committed Transaction Isolation and SELECT ... UNION ... SELECT

Eric Ridge writes: > http://www.postgresql.org/docs/8.4/static/transaction-iso.html says: > "Also note that two successive SELECT commands can see different data, > even though they are within a single transaction, if other > transactions commit changes during execution of the first SELECT." > I

[GENERAL] Read Committed Transaction Isolation and SELECT ... UNION ... SELECT

I think I've been studying the documentation too long and have thought myself into a circle. http://www.postgresql.org/docs/8.4/static/transaction-iso.html says: "Also note that two successive SELECT commands can see different data, even though they are within a single transaction, if other trans

Re: [GENERAL] fork() and dynamically loaded c functions....

Jay Flattery writes: > I have some functions written in C that are dynamically loaded. I persist > some > state between function calls, initialised by _PG_init. This works fine OK... > I now fork() a process in _PG_Init() (both processes interact), but when I > shutdown postgre I get: LOG: f

Re: [GENERAL] pgtune

Sim Zacks wrote: 1) Are these settings the maximum that the server will handle, if it is strictly dedicated to postgresql? Meaning if I am running other stuff on the server as well, this would be a bad idea. The idea is that they will be in the right general range for a system running nothi

Re: [GENERAL] pgtune

On Aug 9, 2010, at 11:40 AM, tuanhoanganh wrote: > What is the name of DW in --type=DW > Sorry for my English. > DW: Data Warehouse > Tuan Hoang Anh > > On Mon, Aug 9, 2010 at 6:21 PM, Amitabh Kant wrote: > 2010/8/9 Sim Zacks > > > > I just found out about pgtune and am trying it out o

[GENERAL] fork() and dynamically loaded c functions....

Hi there, I have some functions written in C that are dynamically loaded. I persist some state between function calls, initialised by _PG_init. This works fine I now fork() a process in _PG_Init() (both processes interact), but when I shutdown postgre I get: LOG: failed to find proc 0x1331110

Re: [GENERAL] MySQL versus Postgres

Randal L. Schwartz wrote: Do not overemphasize the example mode at the cost of presenting concepts or structure. You need all three. Hmm I recently had to find out the various options to get values from a tuple via SPI - referred by docs to the contrib examples :-( Docs did not help and the ex

Re: [GENERAL] Finding last checkpoint time

Bruce Momjian writes: > Greg Sabino Mullane wrote: >> Specifically, LANGUAGE changes the headers of pg_controldata >> (but not the actual output, LC_ALL does that). Thanks for the >> nudge, I'll get to rewriting some code. > pg_upgrade does this in controldata.c for this exact reason: >

Re: [GENERAL] RETURN QUERY SELECT & TYPE

On Tue, Aug 10, 2010 at 2:27 AM, Pavel Stehule wrote: > Hello > > 2010/8/10 screamge : >> Here is code of first procedure: >> CREATE TYPE some_item AS >> (id integer, >> title character varying, >> ... >> ); >> >> >> CREATE OR REPLACE FUNCTION some_func (integer) RETURNS some_item AS >> ... >> ite

Re: [GENERAL] Finding last checkpoint time

Greg Sabino Mullane wrote: [ There is text before PGP section. ] > > -BEGIN PGP SIGNED MESSAGE- > Hash: RIPEMD160 > > > > Hmm, wouldn't have it been easier to set LC_MESSAGES to C before > > calling pg_controldata? > > To be honest, I can't remember why that wasn't working for me when

[GENERAL] Numeric2 - help with library

Hi, I have a problem with running attached type numeric2 on PostgreSQL (8.4). The file is compiled and loaded properly into database. I can create table with this column, and store values there, but when I try to read those values I got segmentation fault. The PostgreSQL doesn't even call method n

Re: [GENERAL] need help with plphp installation

Also CC'ing the PL/php list. Excerpts from Pete Kay's message of mar ago 10 10:21:58 -0400 2010: > Hi, > > I am getting the following errors while trying to get plphp installed > on postgres 8.5: > > ERROR: could not load library "/usr/local/pgsql/lib/plphp.so": > /usr/local/pgsql/lib/plphp.so:

Re: [GENERAL] need help with plphp installation

On 10 August 2010 15:33, Pete Kay wrote: > sorry my mistake.  It is 8.4. > > On Tue, Aug 10, 2010 at 10:27 PM, Thom Brown wrote: >> On 10 August 2010 15:21, Pete Kay wrote: >>> Hi, >>> >>> I am getting the following errors while trying to get plphp installed >>> on postgres 8.5: >>> >>> ERROR:  

Re: [GENERAL] need help with plphp installation

sorry my mistake. It is 8.4. On Tue, Aug 10, 2010 at 10:27 PM, Thom Brown wrote: > On 10 August 2010 15:21, Pete Kay wrote: >> Hi, >> >> I am getting the following errors while trying to get plphp installed >> on postgres 8.5: >> >> ERROR:  could not load library "/usr/local/pgsql/lib/plphp.so"

Re: [GENERAL] need help with plphp installation

On 10 August 2010 15:21, Pete Kay wrote: > Hi, > > I am getting the following errors while trying to get plphp installed > on postgres 8.5: > > ERROR:  could not load library "/usr/local/pgsql/lib/plphp.so": > /usr/local/pgsql/lib/plphp.so: undefined symbol: sapi_globals > > ** Error *

[GENERAL] need help with plphp installation

Hi, I am getting the following errors while trying to get plphp installed on postgres 8.5: ERROR: could not load library "/usr/local/pgsql/lib/plphp.so": /usr/local/pgsql/lib/plphp.so: undefined symbol: sapi_globals ** Error ** ERROR: could not load library "/usr/local/pgsql/li

Re: [GENERAL] change owner strange behavior

David Galkowski writes: > On Mon, Aug 9, 2010 at 9:29 PM, Tom Lane wrote: >> Works for me ... what PG version are you dealing with? > 8.1.11 Oh. This is something we fixed in 8.2 and beyond: http://archives.postgresql.org/pgsql-committers/2006-09/msg00101.php It was not possible to back-patch

Re: [GENERAL] InitDB: Bad system call

Reko Turja schrieb: i've just compiled a new Jail at my FreeBDS 7.0-STABLE machine and trying to get PostgreSQL 9.0 Beta 4 running. Compiling etc works fine. Is the machine really running a pre-RELENG 7.0? As far as i now, we used the 7.0 versions some month after their release. So: no. Wh

Re: [GENERAL] InitDB: Bad system call

Torsten Zühlsdorff schrieb: i've just compiled a new Jail at my FreeBDS 7.0-STABLE machine and trying to get PostgreSQL 9.0 Beta 4 running. Compiling etc works fine. Is the machine really running a pre-RELENG 7.0? But when i call the initdb, i get "Bad System Call" messages. Here is the out

Re: [GENERAL] pl/pgsql editor and postgres developemnt tool

Hi Ray, Thanks for reply. Are you using any editor for code formatting? Regards, Atul Goel -Original Message- From: Raymond O'Donnell [mailto:r...@iol.ie] Sent: 10 August 2010 10:30 To: Atul Goel Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] pl/pgsql editor and postgres develo

Re: [GENERAL] InitDB: Bad system call

Torsten Zühlsdorff schrieb: i've just compiled a new Jail at my FreeBDS 7.0-STABLE machine and trying to get PostgreSQL 9.0 Beta 4 running. Compiling etc works fine. But when i call the initdb, i get "Bad System Call" messages. Here is the output: $ /usr/local/pgsql/bin/initdb -D /usr/local

Re: [GENERAL] Partitioning into thousands of tables?

"Data Growth Pty Ltd" wrote in message news:aanlktimzaio+7mtur=sx0jcqwu7uk+_xznudl4qrm...@mail.gmail.com... I have a table of around 200 million rows, occupying around 50G of disk. It is slow to write, so I would like to partition it better. Have you actually tested this? Why do you expect a

Re: [GENERAL] change owner strange behavior

8.1.11 On Mon, Aug 9, 2010 at 9:29 PM, Tom Lane wrote: > David Galkowski writes: >> In order to consolidate two users, user1 and user2, in the database I >> changed the owner of all tables and views that user2 owned to be owned >> by user1.  I then revoked all remaining privileges from user2 and

Re: [GENERAL] pl/pgsql editor and postgres developemnt tool

On 10/08/2010 09:39, atul.g...@globaldatapoint.com wrote: > Hi All, > > > > I am looking for a good tool for pl/pgsql / postgres developemnt tool. > Something like Toad for Oracle. > pgAdmin together with the pl/pgsql debugger plug-in are a pretty good combination by all accounts. Ray. --

[GENERAL] pl/pgsql editor and postgres developemnt tool

Hi All, I am looking for a good tool for pl/pgsql / postgres developemnt tool. Something like Toad for Oracle. Regards, Atul Goel SENIOR DEVELOPER Global DataPoint Middlesex House, 34-42 Cleveland Street London W1T 4LB, UK T: +44 (0)20 7079 4827 M: +44 (0)7846765098 www.globaldatapoint.com

Re: [GENERAL] InitDB: Bad system call

Hello Thom, See http://www.postgresql.org/docs/9.0/static/kernel-resources.html and the section under NetBSD/OpenBSD. I already know the FreeBSD section. My current values are: kern.ipc.shmall: 131072 kern.ipc.shmmax: 2684225436 kern.ipc.semmap: 4096 kern.ipc.semmnu: 512 kern.ipc.semmns: 102