Re: [GENERAL] InitDB: Bad system call

2010-08-10 Thread Torsten Zühlsdorff
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

2010-08-10 Thread John R Pierce
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?

2010-08-10 Thread John R Pierce
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?

2010-08-10 Thread Samantha Atkins
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....

2010-08-10 Thread Tom Lane
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....

2010-08-10 Thread Alvaro Herrera
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

2010-08-10 Thread Tom Lane
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

2010-08-10 Thread Greg Smith
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

2010-08-10 Thread Greg Smith
சிவகுமார் மா 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....

2010-08-10 Thread Tom Lane
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....

2010-08-10 Thread Jay Flattery
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

2010-08-10 Thread Eric Ridge
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

2010-08-10 Thread Raymond O'Donnell
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

2010-08-10 Thread Tom Lane
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

2010-08-10 Thread Eric Ridge
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....

2010-08-10 Thread Tom Lane
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

2010-08-10 Thread Greg Smith
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

2010-08-10 Thread Vibhor Kumar
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....

2010-08-10 Thread Jay Flattery
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

2010-08-10 Thread Jacqui Caren-home
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

2010-08-10 Thread Tom Lane
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

2010-08-10 Thread Merlin Moncure
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

2010-08-10 Thread Bruce Momjian
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

2010-08-10 Thread rsmogura
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

2010-08-10 Thread Alvaro Herrera
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

2010-08-10 Thread Thom Brown
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

2010-08-10 Thread Pete Kay
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

2010-08-10 Thread Thom Brown
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

2010-08-10 Thread Pete Kay
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

2010-08-10 Thread Tom Lane
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

2010-08-10 Thread Torsten Zühlsdorff
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

2010-08-10 Thread Reko Turja
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

2010-08-10 Thread Atul.Goel
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

2010-08-10 Thread Torsten Zühlsdorff
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?

2010-08-10 Thread Davor J.
"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

2010-08-10 Thread David Galkowski
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

2010-08-10 Thread Raymond O'Donnell
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

2010-08-10 Thread Atul.Goel
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

2010-08-10 Thread Torsten Zühlsdorff
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