ghts?
No. PL/R is untrusted because R gives access to system commands and the
file system. No way around it at the moment, nor in the foreseeable future.
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Su
ack traces and so forth, so that
> is awesome. Your patience and willingness to help has been awesome.
Sounds good -- let us know if the problem resurfaces.
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, &
00:00:47 postgres: stats
collector process
postgres 26631 17001 0 10:22 ?00:00:00 postgres: postgres
contrib_regression [local] idle
#gdb /usr/local/pgsql-head/bin/postgres 26631
(gdb) continue
Continuing.
Session #1: (run crashing function)
-
run your PL/R function tha
(8.3.0.13)?
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/m
Don't try to free an array element value when the
array element is NULL
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
scern), the backend crashes.
Is this always related to use of PL/R or is it sometimes happening
independently?
If you believe it is PL/R specific, please give us R version and PL/R
version. Also, any chance we can get a debugger on a core file? Can you
reproduce this on a development machine?
Tha
you maybe getting bitten by the OOM killer?
http://www.postgresql.org/docs/8.3/interactive/kernel-resources.html#AEN22246
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
--
Sent via pgsql-admin mai
ma
called foobar. The work "schema" here has two different meanings.
HTH,
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
--
Sent via pgsql-admin mailing list (pgsql-admin@post
t' exist PERFORM dblink_disconnect('conn_test');
> else
>
> PERFORM dblink_connect('conn_test', 'dbname=database_test');
> How can write my new function?
See dblink_get_connections():
http://www.postgresql.org/docs/9.0/interactive/contrib-dbl
roll-your-own kind of thing?
plperl with Net::FTP?
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
signature.asc
Description: OpenPGP digital signature
On 04/05/2010 01:46 PM, Kevin Grittner wrote:
> Scott Marlowe wrote:
>> Timothy Madden wrote:
>
>>> My scenario is how to protect the database if the machine is
>>> stolen (it is a mini-laptop), and I would like to encrypt the
>>> entire database, that is all columns of all tables, and if
>>> p
On 04/03/2010 06:35 AM, Timothy Madden wrote:
> I can only see how PostgreSQL encrypts the password or the connection
> in the documentation, and for the database I can see application-level
> encryption with pgcrypto (and filesystem level encryption), How could
> I get database level encryption in
lcar...@ucsd.edu wrote:
> Does anyone have experience using the feature in PG 8.4 (maybe earlier
> versions too??) to store specific columns in an encrypted format? We are
> gathering sensitive data for medical studies and want to use Postgresql,
> however, we need to insure that the data is secur
Jessica Richard wrote:
Everything was running fine under the default number 5432. After the
port number was changed to another number in postresql.conf file and
the server was restarted, dblink is broken, it is still looking for the
old port number 5432... not sure if everything else is broken
Sofer, Yuval wrote:
last_message := dblink_error_message('dbname=postgres
user=postgres password=manager') ;
Am I not using dblink_error_message correctly?
Yes, you are not using dblink_error_message correctly. From the docs:
==
Jessica Richard wrote:
I need to joint select from table A in the current database A and dblink
to table B in database B, the result coming from tableB in db B is very
slow because I have to select all the rows from tableB from dblink then
do "where" with table A in the current dbdoing dbli
Jessica Richard wrote:
I installed the dblink module, run dblink.sql to my current database to
use the dblink function, but I have not been successful to select a
table from a remote database (cross reference).
Whoever knows how to use dblink, please show me the syntax to select
another table
Joshua Marsh wrote:
Does/Can the index track each element in the array, or does it track
only the array as a whole?
Built in index support works on the array as a whole, not the individual
elements.
How can I increase the speed of a query like: SELECT * FROM table WHERE
123 = ANY(array_of_
Matthew D. Fuller wrote:
On Wed, Nov 16, 2005 at 10:29:09AM -0500 I heard the voice of
Tom Lane, and lo! it spake thus:
The existence of this algorithm is disturbing, since it implies that
MD5 is weaker than people thought,
It occurs to me that, controlling everything that would be poking int
Chris Hoover wrote:
Has anyone had problems with memory exhaustion and dblink? We were
trying to use dblink to convert our databases to our new layout, and had
our test server lock up several times when trying to copy a table that
was significantly larger than our memory and swap.
Basically whe
Marek Lewczuk wrote:
I've made some tests with plperl and I see that when plperl function is
executed for the first time, then it takes much more time. I know that
this is a "shared library" problem - is there a way to preload plperl
every connection or maybe I can build plperl into postgresql s
Mª José Sempere wrote:
We are interested in installing the pgcrypto module of PostgreSQL for
Windows, In order to use the function digest() for creating index on
bytea type fields:
create unique index my_index on my_table (digest(my_bytea_field,
'md5'));
Um, why would you want to use digest() jus
Devrim GUNDUZ wrote:
I think we can release beta4 rpms this weekend or so. I'll also try to
build rpms for RCs.
I haven't found the time to update it since beta2, but you might want to
start with this:
http://www.joeconway.com/postgresql-8.0.0beta/SRPM/postgresql-8.0.0beta2-1PGDG.src.rpm
HTH,
Jo
Tom Lane wrote:
Joe Conway <[EMAIL PROTECTED]> writes:
On that, note that I specifically removed jdbc and tcl options from the
spec file because the 8.0.0 release notes said they were removed from
the distribution. I suppose at lease jdbc should be put back? It didn't
seem right to
Tom Lane wrote:
Well, *Marc* is working on including less stuff; the rest of us don't
necessarily agree. In particular I've got to re-incorporate any major
pieces that get removed from the core distribution, since people expect
to find those in the RPM set. (In principle I suppose they could be
h
Tom Lane wrote:
Joe Conway <[EMAIL PROTECTED]> writes:
Hopefully the third try is a charm ;-)
Version 3 is now available: fixes the init script. Previously
/etc/init.d/postgresql worked the first time used (i.e. would initdb and
start postgres) but not the second and subsequent times.
[
Joe Conway wrote:
Version 2 of the source rpm is now available here:
http://www.joeconway.com/postgresql-8.0.0beta1/SRPM/postgresql-8.0.0beta1-2PGDG.src.rpm
I've also put up i386 binary rpms for fc1 and fc2, and x86_64 binary
rpms for fc2.
Hopefully the third try is a charm ;-)
Version 3 i
Joe Conway wrote:
Steve Bergman wrote:
Anyone have an SRPM of spec file for the beta?
I just created and posted a source RPM for 8.0.0beta1. As I'm not the
usual packager, and a pure hack when it comes to building my own RPMs,
it would be a Good Thing(tm) if someone else could vet this pa
Steve Bergman wrote:
Anyone have an SRPM of spec file for the beta?
I just made one; see:
http://www.joeconway.com/postgresql-8.0.0beta1/
There are also Fedora Core 2 binaries there.
One caveat -- I am not the normal package maintainer, so no guarantees ;-).
HTH,
Joe
---(e
Lee Wu wrote:
I have some C functions (was compiled against 7.3.2, I think)
Do I need to re-compile C functions against 7.4.3 or something else I
missed?
Yes, you need to recompile against 7.4.3
HTH,
Joe
---(end of broadcast)---
TIP 5: Have you check
Tom Lane wrote:
Joe Conway <[EMAIL PROTECTED]> writes:
select 'GRANT EXECUTE ON ' || 1142::regprocedure;
ERROR: array value must start with "{" or dimension information
BTW, it seems like there's something pretty broken here. How did
arrays get into it? A
Tom Lane wrote:
Um. Sooner or later we ought to do something about the whole
automatic-casting-to-and-from-text issue. Datatypes shouldn't have to
supply both I/O procedures and text cast procedures.
I thought automatic (i.e. implicit) casting-to-and-from-text was a no-no
because it could cause
Tom Lane wrote:
Also, casting the function's OID to regprocedure may be useful.
Random example:
regression=# select 1142::regprocedure;
regprocedure
date_mii(date,integer)
(1 row)
That's even better -- I tried regproc, but forgot about regprocedure. I
think the prob
Jean-Denis Giguere wrote:
But, the problem is more complex for functions because you have to give
the arguments. You can find the list in the pg_proc table but they are
store in a array by oid. So you can resolve the type with the table
pg_type. After, you have to reproduce the correct syntax (w
Tom Lane wrote:
I'm fairly sure that Oracle's pricing scales with the iron you plan to
use: the more or faster CPUs you want to run it on, the more you pay.
A large shop can easily get into the $100K license range, but Oracle
figures that they will have spent way more than that on their hardware.
T
Silvana Di Martino wrote:
4) What could actually solve our problem is something like the following
scenario. Imagine that postmaster (or pg_ctrl) could accept a new CL
parameter called "pw". This parameter would contain a sequence of
comma-separated databasename/encryption-password pairs. I mean
Remi wrote:
I've installed redhat enterprise 3 on a system to use as a db server.
Manually I can install and run postgresql 7.3 (the one on the extras
CD). The problem is when you try to add postgres as a service, it
might add it, but it will not start it. To do this, we got a
postgresql script, pl
JinNet Picker wrote:
What i need is, when ever a NEW record is inserted in
'MyDb1' , i want fire a Trigger or Rule to insert the
Same Record to MyDb2 database.
Anybody Got Idea how to do this?
See the dblink documentation for dblink_exec(), and see the Postgres
documentation for how to create tr
Jodi Kanter wrote:
I am not sure I understand your question. why does the type of backup
matter? It is a tape backup and it includes the entire /var directory
where the pgsql directory exists. I am trying to determine what
particular files need to be retrieved in order to restore the database
a
Kris Kiger wrote:
Is there a way to force a shared object to reload? I've compiled a new
version of a .so, but postgres seems to be pulling the old version out
of memory. I've tried deleting the .so and recompiling it, but postgres
is insistant, for some reason, of using the old version. Any
David F. Skoll wrote:
For PG < 7.4, does the index grow without the free space being
reclaimed?
I believe so.
Would this affect performance substantially?
Yes, it could.
I have had reports from customers who said our applications speed
improved tremendously after a database dump/drop/recreate/res
Jonathan Gardner wrote:
$ ./configure --with-openssl
I forget the exact reason, but I ran into this before. There is some
kind of dependency between openssl and kerberos 5. Try:
./configure --with-openssl --with-krb5=/usr/kerberos
Joe
---(end of broadcast)---
Erwin Brandstetter wrote:
Still the solution looks ugly and will perform likewise. PostgreSQL
urgently needs improvment on array handling. Hopefully new versions take
care of that (haven't tested 7.3+).
7.4 array functionality is significantly improved. Still room for more
improvements, but well
Stephan Szabo wrote:
On Wed, 20 Aug 2003, Brian McCane wrote:
4) Can I disable the compression to improve storage speed
if the compression algorithm is not as good as deflate
See ALTER TABLE ALTER COLUMN SET STORAGE (I would guess you would want
external, but I'm not 100% sure, c
Marco Kaerger wrote:
hi there,
i have got a problem concerning arrays in postgres
i created a function in which i want to know if the index 8 of var_array
ist not NULL:
IF var_array[8] IS NOT NULL
THEN
(query)
shreedhar wrote:
Hi All,
I Updated my Postgresql Server from 7.2.4 which came along with RH7.3 to
7.3.2. After updating I could not able to connect database through PHP. So I
recompiled PHP4.1.2 (same version which have earlier in my system), even
then I am not able to connect through PHP. Is ther
Tom Lane wrote:
I added code to inline_function to stop inlining if a parameter
expression to be substituted multiple times has cost greater than
10*cpu_operator_cost (which roughly means that it contains more than
10 operators or functions). This seems to cut off the problem nicely,
at least for
Tom Lane wrote:
Yeah. The problem is that the SQL function inliner generates an
enormous expression tree from this function definition. 7.3 had no
inliner so no problem.
But I wonder why it isn't at all a problem when the function is also
defined STRICT?
I also looked back at the greatest() exa
Tom Lane wrote:
It seems to be running out of memory. I'm not sure what's eating so
much RAM --- the expression isn't that complex. Also it seems that
elog.c's ability to handle a shortage of memory has regressed ...
'ERROR: ERRORDATA_STACK_SIZE exceeded' is better than a core dump,
I suppose, b
Tom Lane wrote:
I think you'd need to generate a separate function definition for
each number of arguments you wanted to deal with, which is a bit
of a pain in the neck, but it still beats writing an extension
function in C ...
I thought I'd whack out this example similar to the GREATEST/LEAST
fun
Donald Fraser wrote:
Could someone be please inform me what the correct syntax for accessing arrays
is or tell me if its not possible with pl/pgSQL functions.
It won't work in 7.3.x or before, as you've noted. In 7.4 this will work:
CREATE OR REPLACE FUNCTION test_arrays() RETURNS int4[] AS '
DECL
Naomi Walker wrote:
I need to grant access to all tables for all users on a particular
database. I've tried:
GRANT ALL ON databasename to public;
But it complained the databasebase (relation) does not exist. Do I have to
grant on each table in a separate statement? I'm guessing not.
The syn
Kris Kiger wrote:
Here's my problem. I have user X calling a database function. The
function inserts data into table Y. User X only has select access to
this table. Is there some way to allow user X to call a function that
does an insert for him/her without user X having to have write access
Jodi Kanter wrote:
We have a set of records in a table that needs to be ranked. We thought
of adding a ranking field, but the problem is that the ranking could
change often and there could be additions and deletions from the list.
Updating this ranking field is quickly going to get messy.
Is an
Sidar Lopez Cruz wrote:
how can i link 2 servers and share db info between both
the servers are on separated machines...
See contrib/dblink
Joe
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Ben Schneider wrote:
fine. The only change I made to the DB was to drop the feedback_notes table
and recreate it with an additional column (New column = 'status'). The
select was working before I made this change and now it doesn't.
I can't explain the exact cause in this case, because I don't see
Jodi Kanter wrote:
Can someone tell me how to create a query that will list values in a
field across columns instead of listing them in row form. Can this be
done in one sql query? Thanks Jodi
Are you referring to a crosstab, i.e.:
select * from cth;
id | rowid |rowdt| attribut
Oliver Elphick wrote:
WHERE grosysid = rec.grosysid;
Thanks, nice catch!
You exposed my lack of adequate testing. I guess I should have added a
disclaimer ;-)
Joe
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, p
Rob Abernethy IV wrote:
Does anyone have a good recipe for a view that will display users/gruops in a
way that can be used with Tomcat's JDBCRelam configuration? In other words,
instead of seeing a *list* of users in a group (grolist), I'd like to see a
separate row for every group/user combinati
Jie Liang wrote:
I expect to see something like:
List of relations
Schema | Name | Type | Owner
+--+---+---
public | foo | table | robot
t | foo | table | robot
That's because schema t is not in your search path. By default,
search path is:
regression=#
David F. Skoll wrote:
No, I'm sure a btree will work. However, won't the index be
inefficient (i.e., very flat) if there are many entries with the same
value? Or is this not a problem?
If you're concerned, why not try a partial index?
Joe
---(end of broadcast)--
Jodi Kanter wrote:
> We are currently using the pg_passwd utility to encrypt passwords.
> Someone here told me that I can now encrypt passwords within postgresql
> so that they are not stored in plain text in the pg_shadow file.
> Is this true? I cannot seem to find any mention of it in my postg
Nathan Mueller wrote:
>>Can anyone make suggestions on backup systems? I was thinking that
>>some sort of DVD writing system would be good for accessing one or two
>>files in the backup quickly. It would probably also complete backups
>>faster. However, I think DVD's only hold a few Gigs on them.
Geoff wrote:
> I don't think either COPY or PG_DUMP will help in this case...
>
> I have a users table in database ADMIN with a primary key user_id. I have a
> users_access table in database LIVE which I was hoping to have a foreign key
> user_id reference the user_id column in the ADMIN database
Nick Fankhauser wrote:
> Hi-
>
> We need to increase the length of a varchar field, and couldn't find
> a way to do it using "alter table". Since the alternative is copying
> & re-creating a very large table, we starting poking around under
> the hood & found that pg_attribute.atttypmod seem
Jodi Kanter wrote:
> We are currently trying to determine if their is a performance
> difference with postgres in using an IN statement in the where clause
> vs. using a join between tables.
>
> Is there any published documentation or someone with personal experience
> that can answer this que
Jie Liang wrote:
> I did, it didn't work.
>
> Jie Liang
Works for me. Did you change postgresql.conf? Here's what mine looks like.
#
# Syslog
#
# requires ENABLE_SYSLOG
syslog = 1 # range 0-2
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
From the online docs:
Jie Liang wrote:
> In postgresql.conf:
> # Syslog
> # requires ENABLE_SYSLOG
> How to do it?
> My OS is FreeBSD4.5
> I installed Postgres-7.2
>
>
> Urgent!
>
I think you need to make sure that PostgreSQL was built with
--enable-syslog during configure.
Joe
--
Felipe Nascimento wrote:
> Is there a max length (number of characters) to column names??
>
> I received the following:
> identifier "petb_convidado_partida_participante" will be truncated to
> "petb_convidado_partida_particip"
>
> Tks
> Felipe
>
Yes -- it is 31 characters max by default. You
Raymond Chui wrote:
> Previous DBA create a lot of triggers and functions without
> documentation like:
>
> CREATE TRIGGER trigger_name [BEFORE | AFTER] event ON table_name
> FOR EACH ROW EXECUTE PROCEDURE function_name();
>
> Now he is gone. I couldn't find his PL/PGSQL source codes!
>
> I can
Jodi Kanter wrote:
> Can anyone tell me the sql that is being sent to the database when
> typeing this command? I am working on writing some code that will show a
> list of columns in a table. Is there a describe statement?
>
> Thanks
>
> Jodi Kanter
Start up psql with the -E switch. It wil
Hello,
I am getting the following error when trying to use pg_dump:
***
pg_dump cymi > cymi.2000_04_16.dmp
FATAL 1: Memory exhausted in AllocSetAlloc()
PQendcopy: resetting connection
SQL query to dump the contents of Table 'cymi_de
reduce the collected data). Is there anything I can do to
cache some or all of this table in memory in order to speed queries against it? The
physical file is about 130 MB. The server is a dual Pentium Pro 200 with 512 MB of RAM.
Any suggestions would be appreciated.
Joe Conway
p.s. I tried to
73 matches
Mail list logo
