esponse to 2.6.9 or .10 but
even before you get into all that. I am curious to know what do you mean by
"standard Linus kernel". Do you not compile your own kernels for the hardware
platform being used?
--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, In
home of Mammoth PostgreSQL - S/ODBC and S/JDBC
> Postgresql support, programming shared hosting and dedicated hosting.
> +1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com
> PostgreSQL Replicator -- production quality replication for PostgreSQL
>
>
The only additiona
ows variants so for security sake increased an network complexity is
justified.
My point is that along with the performance issues this thread has point out,
data security is another reason to consider a non-windows platform to run your
production database.
--
Keith C. Perry, MS E.E.
Di
iding that setting.
>
> richard
>
> ---(end of broadcast)---
> TIP 3: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faq
>
--
Keith C. Perry, MS E.E.
Direct
h Usenet, please send an appropriate
>subscribe-nomail command to [EMAIL PROTECTED] so that your
>message can get through to the mailing list cleanly
>
--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com
hrs_idx is defined as:
iprism=# \d hrs_idx
Index "public.hrs_idx"
Column | Type
+--
stamp | timestamp with time zone
btree, for table "public.report", predicate (thehour(stamp) >= 0::double
precision AND thehour(stamp) <= 23::do
Quoting Tom Lane <[EMAIL PROTECTED]>:
> "Keith C. Perry" <[EMAIL PROTECTED]> writes:
> > This might have been discussed before but I wanted to know if clustering
> tables
> > by partial indexes will be availble in a later release of pgSQL?
>
> What i
uild a bigger machine.
I'm not sure I heard any mention of filesystems but I've been moving all my EXT3
filesystems to XFS. Some other journaling filesystem that you might want to
look into are JFS and ReiserFS.
--
Keith C. Perry, MS E.E.
Director of Networks
; >
> > > >
> > > >
> > > >
> > > > ---(end of
> broadcast)---
> > > > TIP 9: the planner will ignore your desire to choose an index scan if
> your
> > > > joining
> ' LANGUAGE 'sql';
>
>
>
>
>
> How do I get these functions to import correctly if it
> fails due to this "current_transaction" table not
> being found? (only due to it being a temporarily table
> created by a different command)
I had
p exactly what I was trying to get out. We can put all the
material together that someone would use to be certified but there should not be
an emphasis on it. After reading/studying a training manual or guide, it should
be completely a personal choice.
--
Keith C. Perry, MS E.E.
Director of Ne
| http://candle.pha.pa.us
> [EMAIL PROTECTED] | (610) 359-1001
> + If your life is a hard drive, | 13 Roberts Road
> + Christ can be your backup.| Newtown Square, Pennsylvania 19073
>
> ---(end of broadcast)-
Quoting Peter Eisentraut <[EMAIL PROTECTED]>:
> Keith C. Perry wrote:
> > That situtation is a little different though since Linux comes is
> > various distributions. Eventually people with get that Linux = Red
> > Hat is NOT true. Heck, IBM is probably the best at pro
Quoting "Marc G. Fournier" <[EMAIL PROTECTED]>:
> On Thu, 11 Dec 2003, Peter Eisentraut wrote:
>
> > Keith C. Perry wrote:
> > > That situtation is a little different though since Linux comes is
> > > various distributions. Eventually people with ge
re how to mange them with oracle...
> http://www.engin.umich.edu/caen/wls/software/oracle/server.901/a88856/c04space.htm
>
> http://www.siue.edu/~dbock/cmis565/ch8-tablespaces.htm
> http://www-rohan.sdsu.edu/doc/oracle/server803/A54641_01/ch8.htm
>
>
> -Original
---
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
>
Just FYI...
Typically the "other" perl module is Pg.pm
(http://gborg.postgresql.org/project/pgperl/projdisplay.php).
--
Kei
purposes got zapped by lightning in August.
> --
> Mike Nolan
>
> ---(end of broadcast)---
> TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
>
I think that is what I was getting confused with before- schemas...
Quoting Greg Stark <[EMAIL PROTECTED]>:
> "Keith C. Perry" <[EMAIL PROTECTED]> writes:
>
> > Ok, thats for the response. I take it a PG namespace = Oracle table space
> (or
> > namespace is simply the generic term).
>
> Actually if you check
quickly have quite a
bit of "trainers" once we decide how to divide up the knowledge (i.e. training
levels). I think Bruce's said his materials are on his web site so perhaps we
should start there with the intention of repackaging that information for
community d
ql supports SSL natively but you can always tunnel the
connection with ssh if your ISP supports it. If you are using 7.4 you could
even use pg_dump with ssh in a similar manner.
--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com
ill switch to PG anywhere soon but sometimes it's
> hard to
> > > > > > > > find whatever information I need. Google is a great help but I
> would
> > > > > > > > expect it in the docs.
> > > > > > >
> > > >
t sure what that
meant but I looked for at the 3 inch doubled side binded of my 7.3.2 docs-
admin,user &,programmer- its as big as my J2EE binder.
Not very scientific I know :)
Seriously though, when people indicate PG is "hard", I hear, "if it was easy
everone would be doing it&
.11
server for a bunch of PCs and MACs and pulling coax. Did I want to do that- I
can't really say because at the time I had to eat. That for me is on the outer
fringes of this thread. Few organzations are NOT using Windows somewhere, and
an increasing number of organizations are starting
-(end of broadcast)-------
> TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org
>
--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com
This email accou
ink I qualified to write
for the main docs, I definitely can contribute to the techdocs in the manner I
just mentioned.
Matter a fact, I finally finish my first one "Using PostgreSQL for Domino 6
RDBMS Backends". I'm doing the final read now so hopefully I can get it over to
Robert f
t; Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC - S/JDBC
> Postgresql support, programming, shared hosting and dedicated hosting.
> +1-503-222-2783 - [EMAIL PROTECTED] - http://www.commandprompt.com
>
>
--
Keith C. Perry, MS E.E.
Director of Networks & Appl
27;%423'"
> and "~ '00423'" both won't - it's like searching a telephone book for
> somebody, whose last name ends with "erry" (as opposed to begins with
> "Perr").
>
> Dima
>
>
> Keith C. Perry wrote:
>
>
le "-D/global/pg_control" for reading: No such file or directory"
I wonder if that is because I didn't use a locale when I initialized the
database. (My locale -a return "C")
--
Keith C. Perry, MS E.E.
Director of Networks & Applica
> ---(end of broadcast)---
> TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faqs/FAQ.html
>
--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com
gt; (he was using Mysql 4.0.15)
Once again proof is in the pudding!
> regards
>
> Mark
>
>
>
>
>
> ---(end of broadcast)---
> TIP 7: don't forget to increase your free space map settings
>
--
Keith C. P
rg in the sense that they point you toward the
> various
> >distributions of Linux.
> >
> >Comments?
> >
> >
> >
>
>
> --
> Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
> Postgresql support, programming shared hostin
hands on and in
depth information. There is also http://gborg.postgresql.org where you can
download some of the other software tools, interfaces, etc that you may need
develope and deploy your applications.
--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com
___
box and follow the directions in the man page of pg_dumpall (see the
"-h" parameter).
If you are not on a network, you could install 7.4 version in a different
directory and configure to run on a different port. You still dump via IP this
way. You can run both systems head to head that
ing space in the table. I hoping a
partial index or a function index will solve this and be just as efficient.
However, that method **does** work. Is there a better way?
Thanks to all in advance.
--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vc
Quoting Richard Huxton <[EMAIL PROTECTED]>:
> Keith C. Perry wrote:
> >
> > I have a table with with 1 million records in it. Here is the definition
> >
> > CREATE TABLE report
> > (
> > match int4,
> > action varchar(16),
> > stam
art of
the database nightly vacuum is to first delete any account that did not have any
actions for over a year. You don't need to do a trigger to do that. You just
need to make a cron job that run at whatever is an acceptable interval.
--
Keith C. Perry, MS E.E.
Director of Networks &
Quoting Peter Eisentraut <[EMAIL PROTECTED]>:
> Keith C. Perry writes:
>
> > What am I missing?
>
> A reproduceable test case.
>
> --
> Peter Eisentraut [EMAIL PROTECTED]
>
???
Ok, lets try the question this way...
What is a method of dumping and r
pg_restore: [archiver] input file does not appear to be a valid archive
I'm also tried pg_restore with a 7.3.4 database file and the result was the same
on the 7.4 server.
What am I missing?
--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN,
end of broadcast)---
> TIP 4: Don't 'kill -9' the postmaster
>
I had this same issue as well but now I'm *slightly* concerned since most of my
code is perl. How soon would issue be reviewed? (not that I'm NOT going to use
your patch for right
Quoting "Keith C. Perry" <[EMAIL PROTECTED]>:
> Quoting Gianni Mariani <[EMAIL PROTECTED]>:
>
> > Gianni Mariani wrote:
> >
> > >
> > > Before I go deep into this - does anyone have the quick fix for this ?
> > >
> >
Quoting Gianni Mariani <[EMAIL PROTECTED]>:
> Keith C. Perry wrote:
>
> >I had this same issue as well but now I'm *slightly* concerned since most of
> my
> >code is perl. How soon would issue be reviewed? (not that I'm NOT going to
> use
> >your
use is PosgreSQL then this might not be a big deal.
Performance-wise I'm not qualified to speak to which is "better". As always, it
is going to depend on your specific application and environment.
--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http:
tically writes rules). To handle that, you
could cron a job to renumber the rules with whole numbers so again:
current rule order:
10.0
11.0
12.0
after 1st update
10.0
10.5
11.0
12.0
after second update
10.0
10.5
11.0
11.5
12.0
after 3rd update
10.0
10.25
10.5
11.0
11.5
12.0
after a renumber
x27;t know what is running.
'Course these days you can tune your kernel and shell parameters to minimize
that. Still, I would ask first to see if maybe they'll install it system-wide
first...
As previously mentioned you could just go with an ISP that has already been
running Postg
all that but how the GC is going to work in this
project is something that I'm curious about.
--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com
Quoting Jan Wieck <[EMAIL PROTECTED]>:
> The following is more or less a brain-dump ... n
bles. On the otherside of the spectrum you can
have perl read/send parameters to your users and have pages build dynamically
based on that. I generally do this way so I rarely write a complete page of
HTML. I just use perl to assemble those pieces based on user input and the
required business
I think I might have described this wrong- "\dt" works the same in
version 6 and 7. However "\d *" shows you the detail of **each** table
in the database. So if you two tables called "status" and "tasks", the
output of "\d *" would be:
Table= status
+--+
47 matches
Mail list logo
