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: pgsq
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 production
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) anymo
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.
>
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
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
>cou
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 se
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: http://wiki.postgresql.org/wiki/Streaming_Repli
h just yet.
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 wrote:
I g
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
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
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
Sent
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 broadcast)
nslookup isn't the easiest tool for use in diagnosing dns problems
as it goes through the whole messy nsswitch process, and doesn't
readily isolate much of anything.
the dig command focuses on dns only, skips nsswitch altogether,
and lets you rule dns problems in or out in one swell foop. if
dig i
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 se
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 th
[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
replication and realized
> that if you plan on using asynchronous
replication, your
> application should be designed from the outset
with that
> in mind because asynchronous replication is
not something
> that can be easi
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.
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 w
Randal L. Schwartz wrote:
>Absolutely not. It rejects 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 example in appendix
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
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
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
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 c
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 tr
[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 restricti
>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 i
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 d
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 wo
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.
che
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 m
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 contr
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
35 matches
Mail list logo
