i used it for a project about 6 months ago. it took a little bit of effort to
get things going, and the documentation could use some work, but it was
reliable once i got oriented.
the developer does read the mailing list, and responds to requests for help.
i think you could use it in
Edson Richter [edsonrich...@hotmail.com] writes:
I don't know much about PostgreSQL with plJava, but I can give a few
tips about memory stability when using Java (see inline):
...
In the past, one choice was using static classes whenever possible. This
is not true (neither recommended) anymore,
Edson Richter [edsonrich...@hotmail.com] writes:
Em 19/11/2012 15:26, Welty, Richard escreveu:
PL/Java requires that the methods being directly called from PostgreSQL are
static.
while i don't disagree with the advice, PL/Java is limited in this respect.
:-) as I said, I know little about pl
19, 2012 5:56 PM
To: Welty, Richard; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Experiences with pl/Java
thanks - not sure how plJava works here and if the implementation is
identical to Apache Derby - what I can tell however is that defining the
types the way I did (integer on one side vs
port numbers are restricted to 2 octets (16 bits). they are TCP/IP entities and
are restricted in size by the RFCs (internet standards.)
richard
-Original Message-
From: pgsql-general-ow...@postgresql.org on behalf of Alberto Zanon
Sent: Wed 5/23/2012 10:19 AM
To: Merlin Moncure
Cc:
in the RHEL and related linux systems (Fedora, CentOS, Amazon EC2 Linux), use
this
command:
chkconfig postgresql on
to set up postgresql to start at boot. it needs to be executed as root.
richard
-Original Message-
From: pgsql-general-ow...@postgresql.org on behalf of leaf_yxj
some of you may have seen this in the NYT two weeks ago:
http://bits.blogs.nytimes.com/2012/04/05/pentagon-pushes-crowdsourced-manufacturing/
just FYI, the database being used by the MIT/GE team is PostgreSQL 9.1.3
cheers,
richard
can anyone recommend an open source tool for diffing schemas?
(it should go without saying that i'm looking for ddl to update production and
QA DBs from development DBs, but i'll say it, just in case.)
thanks,
richard
.
richard
-Original Message-
From: Michael Nolan [mailto:htf...@gmail.com]
Sent: Mon 4/2/2012 7:19 PM
To: Welty, Richard
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] 9.1.3: launching streaming replication
On Mon, Apr 2, 2012 at 4:21 PM, Welty, Richard rwe...@ltionline.com wrote:
I
i have a server in the ec2 cloud which in theory is set up as a master; it
starts and runs. i've got an amazon s3 bucket mounted using s3fs on both the
master and the standby (the standby is also set up in the ec2 cloud.)
i followed the steps here:
does anyone have any tips on this? Linux Software Raid doesn't seem to be doing
a very good job here, but i may well have missed something.
i did a fairly naive setup using linux software raid on an amazon linux
instance,
10 volumes (8G each), (WAL on a separate EBS volume) with the following
On Mon 3/19/2012 4:30 PM Mike Christensen writes:
I've been running my site on RackSpace CloudServers (similar to EC2)
and have been getting pretty good performance, though I don't have
huge amounts of database load.
One advantage, though, is RackSpace allows for hybrid solutions so I
could
Scott Marlowe writes:
However, on the command line, the polarity is reversed (vague Star Trek
reference there)
reversing the polarity of the neutron flow: classic dr who reference,
actually
and PostgreSQL enjoys a MUCH richer and easier to use
set of utilities. I find psql to be much much
Gregory Youngblood wrote:
Is corruption a problem? I don't think so - but I want to make sure I haven't
had my
head in the sand for a while. :) I realize this instance appears to be on
Windows,
which is relatively new as a native Windows program. I'm really after the
answer on
more mature
Wes Williams writes:
Even with a primary UPS on the *entire PostgreSQL server* does one still
need, or even still recommend, a battery-backed cache on the RAID controller
card? [ref SCSI 320, of course]
If so, I'd be interest in knowing briefly why.
it can be a lot faster.
if the raid
Brent Wood wrote:
Two? I haven't used Firebird, but have heard lots of positive comments
from users. Firebird/Postgres/MySQL together maybe? Or with all the
embedded SQLlite users out there, perhaps all four :-)
i can't think of a single good reason why anyone in the PostgreSQL
community
Marc G. Fournier wrote:
Stupid question, but what does MySQL bring to the equation? Why not just
use PostgreSQL in the first place?
really.
to my mind, the best thing the PostgreSQL community can do for the
MySQL community is provide simple, easy to use migration tools
and documentation.
Simon Riggs wrote:
IBM have previously bought Informix (who bought Illustra, RedBrick,
Cloudscape) and Oracle have previously bought DEC RDB, so both have
track record of successful competitor take-overs. None of those take-
overs has led to a product actually surviving.
Informix to some
Neil Dugan wrote:
If I was to develop a 'C' project that only used the libpg.so library and the
rest was my own stuff would I need to preserve the copyright to somehow?
I wouldn't be distributing any source at all just my executable and the
library.
license preservation is relevant if you
L van der Walt writes:
The big problem is that the administrators works for the client and not
for me. I don't want the client to reverse engineer my database.
i think you're trying to get native OS security to perform the function
of a well crafted legal document.
richard
L van der Walt wrote:
Then, I might as well just leave the whole PostgreSQL DB and write my
own mini DB with encrypted XML files. I am sure someone must have an
answer for me.
i think the answer is that windows is giving you a false sense of
security.
in an environment where you cannot
[EMAIL PROTECTED] wrote:
You could look at what SELinux extensions now available in at least the Red
Hat (and Fedora) distro offer. I have never done anything with SELinux,
and a quick review of the archives indicates it is not a slam dunk to use.
It is designed to create the kind of restrictive
No I can not trust the clients administrators.
I have played now with MySQL and with MySQL you can change the password
for root in MySQL (same as postgres in PostgreSQL). If you use the
command line tools like dump you require the password. Just because
your root doesn't mean your root in
Aaron Glenn wrote:
On 10/4/05, Richmond Dyes [EMAIL PROTECTED] wrote:
From my understanding of the license for Postgresql, there is no
licensing fees as long as you are not selling it yourself for a profit.
Completely incorrect. You can do whatever you like with PostgreSQL;
you just can't
Russ Brown wrote:
Apologies for going slighly off topic, but isn't this basically how
MySQL does replication?
Or am I missing something?
in the immortal words of mothers everywhere: if all your friends
jumped off of a bridge, would you do it too?
there are a lot of things that are good
Randal L. Schwartz wrote:
Absolutely not. It rejects fred[EMAIL PROTECTED] which is a perfectly
valid email address. (Try it, you'll get my autoresponder.)
Google for RFC 822 and RFC 2822 to see the *real* rules. An
actual regex for an email address is rather large.
there's an extended
Jim C. Nasby wrote:
No more or less so than putting your main database on RAID0. If any
drive fails, you lose everything.
perhaps it's time to start writing it [^r]A[^i]D 0 to try and make
the point.
richard
---(end of broadcast)---
TIP 5: don't
[mailto:[EMAIL PROTECTED] Behalf Of Michael Meskes
Am Mittwoch, 24. August 2005 14:21 schrieb Carlos Henrique Reimer:
One possible solution is replicate the headquarter DB into the two
branches.
I read about slony-i, but then the replicated DBs will be read-only.
That's because it's a
Carlos Henrique Reimer
wrote:
I read some documents about
replicationand realized
that if you plan on using asynchronous
replication, your
application should be designed from the outset
with that
in mind because asynchronousreplication is
not something
that can be easily added on after
Jeff Davis writes:
I hope this is helpful. Let me know if there's some reason my plan won't
work.
look at the solution in pgreplicator. site ids are embedded in the
id columns in the tables, so there only m tables, and a bit less insanity.
That doesn't work with Slony-I unfortunately. I
Jeff Davis writes:
The disadvantages:
one more: if you actually have m tables and n servers, you have
m x n tables in reality, which is pretty miserable scaling behavior.
i should think that rules, triggers, and embedded procedures would
explode in complexity rather rapidly.
i know i wouldn't
Aly Dharshi [mailto:[EMAIL PROTECTED] wrote:
Having read both books would your recommendation be
to go with Korry Douglas' book ?
a qualified probably. one of the things i'm going to do when
i actually write the review is make a quick pass over douglas
for a compare and contrast; i think that
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Aly Dharshi
does anybody have any recommendations which one to get ?
1) PostgreSQL by Korry Douglas (SAMS)
http://www.samspublishing.com/title/0672327562
i like the first edition of Douglas very much, i presume that this
Hrishikesh Deshmukh writes:
I have 7.4.7 version, my question is what are OIDS user for? What can
one do with it!
they're for internal use only, they may go away, so don't do anything
with them, pretend that they aren't even there.
richard
---(end of
34 matches
Mail list logo