On Mon, Jun 15, 2009 at 11:36 AM, John R Pierce wrote:
> Jim Mlodgenski wrote:
>>
>>
>> also is it possible to paritition without changing client code
>>
>> Yes, but it depends on the SQL in your client code. If you are just using
>> simple SQL with no stored functions, you should be able to sli
I thought pgool II was abandonware...
On Fri, Jun 26, 2009 at 7:50 PM, wrote:
> Hey john
> thanks
> i did read both extensively, but finishing all the steps parallel mode or
> horizontal partitioning mode doesnot work!
> but this is my conf file
>
> # backend_hostname, backend_port, backend_weigh
On Tue, 23 Jun 2009, Hartman, Matthew wrote:
Is there a recommended approach when trying to use EXPLAIN on a
function? Specifically, a function that is more than the typical SELECT
statement or tiny loop. The one in question that I'm hoping to optimize
is around 250 lines.
Take a look at
http
Hey johnthanks
i did read both extensively, but finishing all the steps parallel mode or
horizontal partitioning mode doesnot work!
but this is my conf file
# backend_hostname, backend_port, backend_weight
# here are examples
backend_hostname0 = 'localhost'
backend_port0 = 5432
backend_weight0
mobiledream...@gmail.com wrote:
can someone show how to setup pgpool 2 in parallel *query* mode ie
horizontal partitioning
did you look at
http://pgpool.projects.postgresql.org/pgpool-II/doc/tutorial-en.html#parallel
?
I'd pay close attention to the restrictions here, too...
http://pgpool.
can someone show how to setup pgpool 2 in parallel replication modethanks a
lot
On Thu, Jun 25, 2009 at 10:28 AM, Scott Marlowe wrote:
> On Thu, Jun 25, 2009 at 12:03 AM, wrote:
> > GOals are to scale our game for 1 simultaneous connection to db
> > right now db crashing at 500 or 1000 sim c
can someone show how to setup pgpool 2 in parallel *query* mode ie
horizontal partitioningthanks a lot
On Fri, Jun 26, 2009 at 5:35 PM, wrote:
> can someone show how to setup pgpool 2 in parallel replication modethanks
> a lot
>
>
> On Thu, Jun 25, 2009 at 10:28 AM, Scott Marlowe
> wrote:
>
>>
Dimitri Fontaine wrote:
Hi,
Le 25 juin 09 à 11:26, Jasen Betts a écrit :
On 2009-06-23, Mike Christensen wrote:
Does anyone actually have that (any node
can go down and the others still replicate amongst themselves?)
you are describing usenet. (it was not designed for relational database
r
On Fri, Jun 26, 2009 at 1:37 PM, wrote:
>
> Obfuscated function source code (not wanted) Obfuscating function source
> code has minimal protective benefits because anyone with super-user access
> can find a way to view the code. At the same time, it would greatly
> complicate backups and other adm
Hi,
Le 25 juin 09 à 11:26, Jasen Betts a écrit :
On 2009-06-23, Mike Christensen wrote:
Does anyone actually have that (any node
can go down and the others still replicate amongst themselves?)
you are describing usenet. (it was not designed for relational
database
replication but it does
Hi,
Le 26 juin 09 à 10:56, luca.cicirie...@email.it a écrit :
Do exist a way to mask the code of the store procedure shipped with
my DB?
There's a way to do it which is not intended to cover this need: write
the procedure code in C, and only ship the .so and .sql, not the .c
code. You'll
I asked a question similar to this a couple of weeks ago, but the
requirement has changed a bit and I want to be sure I'm designing my
tables correctly.
I have the following table:
CREATE TABLE workorder (
numberVARCHAR(8),
quantity INTEGER,
generic BOOLEAN,
PRIMARY KEY
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
(blush) (blush)
Sorry for the noise
I forgot to ssl=on in postgresql.conf
(blush) (blush)
Pedro Doria Meunier
GSM: +351 96 17 20 188
Skype: pdoriam
Pedro Doria Meunier wrote:
> Hi (again :] )
>
> PGSQL 8.3.7 rpms for x86_64 aren't compiled w
Obfuscated function source code (not wanted) Obfuscating function source code
has minimal protective benefits because anyone with super-user access can find
a way to view the code. At the same time, it would greatly complicate backups
and other administrative tasks. To prevent non-super-users f
- Original Message -
From: "Andreas Kretschmer"
To: pgsql-general@postgresql.org
Sent: Friday, June 26, 2009 1:58:08 AM GMT -08:00 US/Canada Pacific
Subject: Re: [GENERAL] Custom runtime variables
Scott Bailey wrote:
> Thanks Tom. So how about accessing it from from plpgsql or sq
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi (again :] )
PGSQL 8.3.7 rpms for x86_64 aren't compiled with ssl support?!
I've my server.* files in the data folder but this is what I get:
Error connecting to the server: server does not support SSL, but SSL
was required
BR,
- --
Pedro Doria M
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thank you Scott!
As always your advice is right to the point ;-)
That solved it.
Best regards,
Pedro Doria Meunier
GSM: +351 96 17 20 188
Skype: pdoriam
Scott Marlowe wrote:
> On Fri, Jun 26, 2009 at 12:52 PM, Pedro Doria
> Meunier wrote:
>> --
On Fri, Jun 26, 2009 at 12:52 PM, Pedro Doria
Meunier wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi all,
>
> I'm wondering what are the correct values in postgresql.conf for
> max_connections = 500 ...
>
> The values I had in 8.2.13 conf file worked without a problem but with
> th
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
I'm wondering what are the correct values in postgresql.conf for
max_connections = 500 ...
The values I had in 8.2.13 conf file worked without a problem but with
the new 8.3.7 postmaster simply refuses to start.
Any pointers would be highly
Hello Richard,
OK, understood it and looks to me a good system with whole block overwrite
and then the deltas.
Thnx.
Ciao,
Gerhard
--
http://www.wiesinger.com/
On Fri, 26 Jun 2009, Richard Huxton wrote:
Gerhard Wiesinger wrote:
Hello,
OK, what's then the difference doing a pg_start_bac
Ok, it seem that is not what I am seeking.
I have a triggered function that works quite well on an insert into a table.
What I would like to do is trigger that same function when conditions are
updated in an other table.
I'm trying to avoid having to copy the whole function over to an update
On Fri, Jun 26, 2009 at 1:28 PM, Bob Pawley wrote:
> However, perhaps I don't understand the idea of a function.
Please review the manual for examples.
http://www.postgresql.org/docs/8.3/static/plpgsql.html
Specifically,
http://www.postgresql.org/docs/8.3/static/plpgsql-structure.html
--
Jo
That worked.
However, perhaps I don't understand the idea of a function.
If the , in this case ('1'), was in fact an unknown variable what would the
return be?
Bob
- Original Message -
From: "John R Pierce"
To: "Bob Pawley" ;
Sent: Friday, June 26, 2009 10:15 AM
Subject: Re: [GEN
Bob Pawley wrote:
Hi
I want to try using functions but I am having trouble understanding
return.
...
The error message - "control reached end of function without RETURN"
I have attempted adding - Return integer; to the end of the function
with no success.
I'd try adding
RETURN
Hi
I want to try using functions but I am having trouble understanding return.
This is the function -
CREATE OR REPLACE FUNCTION p_id.ip_orient_3()
RETURNS integer AS
$BODY$
Begin
Insert into fluids (fluid_id) values ('1') ;
End;
$BODY$
LANGUAGE 'plpgsql' VOLATILE
COST 100;
ALTER
On Fri, Jun 26, 2009 at 10:56:34AM +0200, luca.cicirie...@email.it wrote:
> I've wrote a PLPGSQL stored procedure for a DB I've to delivery to
> my customer. The problem is that I want to hide the code of the
> stored procedure. I don't want that my customer is able to read the
> code of the my sp.
2009/6/25 Jack W
>
> Maybe for maintainence purpose or schema change. For example as you
> mentioned above, if using several tablespaces located on different hard
> drives. If one hard drive is damaged, the database on that hard drive will
> not be available. How about other databases managed by
Sam Wun writes:
> I had been running postgresql 8.3.7 in freebsd for some time, but
> after I changed its postgresql.conf file, it can't start any more
> eventhoguh I changed the config back to its original file.
> Anything wrong?
> Jun 26 15:58:52 twp1 postgres[1394]: [1-1] FATAL: could not cre
Hi Laurenz,
Thanks for the suggestion. It sure wasn't easy, but I should have done that
right away. It turned out not to be in the ecpg module, but somewhere in my own
code (of course ;-) ). At least I haven't been able to reproduce it in a simple
example and I haven't figured out where i
Hello
I thing, so quote_ident is secure.
you can add more security via explicit casting to regclass type -
check if value of variable is really relation identifier:
postgres=# select quote_ident('omega b')::regclass;
quote_ident
-
"omega b"
(1 row)
postgres=# select quote_ident('o
Since this stripped down example function looks a bit meaningless, I'd like to
rephrase the question to make it more clear: Does quote_ident() prevent all
ways of trying to inject SQL into $1 so that the testinjection function cannot
be used to do anything else than setting column c to null in a
hello Arndt,
Thanks for the input. I was successfully able to implement "rubyrep", on a
windows system (I used windows 7). Is there any way i can implement Master
Slave replication by rubyrep.
Regards
Nishkarsh
Arndt Lehmann-2 wrote:
>
> Hi Merlin,
>
> you could also consider giving "rubyre
Is there any known way to inject SQL into a function similar to this?
create function testinjection(text,integer)
returns void as
$BODY$
declare
begin
execute 'update '||quote_ident($1)||' set c=null where id='||$2;
return;
end;
$BODY$
language 'plpgsql' volatile security definer;
grant execute o
a biglietti metallico!
> Spese di spedizione escluse. Offerta limitata, fai in fretta!
> Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=8956&d=20090626
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your
di spedizione escluse. Offerta limitata, fai in fretta!
> Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=8956&d=20090626
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/
Scott Bailey wrote:
> Thanks Tom. So how about accessing it from from plpgsql or sql?
test=# select * from current_setting('myvar.foo');
current_setting
-
(1 Zeile)
Zeit: 0,163 ms
test=*#
test=*# set myvar.foo='bla';
SET
Zeit: 0,117 ms
test=*# select * from current_setting('my
fferta limitata, fai in fretta!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=8956&d=20090626
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
2009/6/26 Scott Bailey :
>
>> Scott Bailey writes:
>>>
>>> I added the following lines to my postgresql.conf file:
>>> custom_variable_classes = 'foo'
>>> foo.name = '1s'
>>
>>> Now if I do "show foo.name" I get '1s'
>>> But it does not show up in show all or in pg_settings.
>>
>> No, it doesn't.
Scott Bailey writes:
I added the following lines to my postgresql.conf file:
custom_variable_classes = 'foo'
foo.name = '1s'
Now if I do "show foo.name" I get '1s'
But it does not show up in show all or in pg_settings.
No, it doesn't. It should still work in set/show though.
Also, can t
39 matches
Mail list logo
