development.
I thank you in advance for your replies via email or this newsgroup.
There's a fix for Postgresql 7.0.3 here:
http://www.freebsd.org/~alfred/vacfix
I'm strongly considering taking the patches offline and reselling them
as I seem to be the only source for them nowadays.
--
-Alfred
it to explain that the vacfix is not a
cure-all, certain degenerate conditions cause it to perform as
bad if not worse than a traditional vacuum.
--
-Alfred Perlstein - [[EMAIL PROTECTED]]
Represent yourself, show up at BABUG http://www.babug.org/
---(end of broadcast
* Joel Dudley [EMAIL PROTECTED] [010327 11:29] wrote:
Hello All,
I am writing my first C function for postgres and failing miserably. my C
function needs to get passed a username (char) , uid(int), and gid(int) and
right, wrong and wrong.
char *, uid_t, gid_t.
--
-Alfred Perlstein
I deleted Bruce's email and promptly lost the URL, anyone care to
forward it to me please?
thanks,
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send
rule should bomb out and explain why.
As a safety precaution, i would also make a rule that automagically
bombs out on a direct update to the 'lower' column.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
---(end of broadcast)---
TIP 3: if pos
* Shaw Terwilliger [EMAIL PROTECTED] [010222 15:49] wrote:
Alfred Perlstein wrote:
As a general safety precaution I would close a connection after a
timeout or N uses.
My application is running on the same host as PostgreSQL, so connection
timeouts should be rare (I guess this would only
and users here so I could
back up my recommendations.
NFS == Not F** Stable, don't do it. :) Any DBA will want to
hurt you when he hears about you running a production DB over NFS.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar
on the machine where
the storage is.
Agreed. :)
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
* Shaw Terwilliger [EMAIL PROTECTED] [010209 16:18] wrote:
Alfred Perlstein wrote:
Actually NFS has very strong write ordering semantics, it just has
terrible cache coherency. Meaning two machines accessing the same
file will most likely see different things if the file is updated
read that indices on CHAR are faster than those on VARCHAR.
No clue, but as a somewhat related note, I don't think indexes work
properly when a join is attempted on a CHAR and VARCHAR column.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I
* Dave Cramer [EMAIL PROTECTED] [010124 09:08] wrote:
Tom,
Thanks for the hint, and no I wasn't looking in the right place. Here is the
backtrace
This isn't a backtrace, you need to actually type 'bt' to get a backtrace.
-Alfred
r
than using Oracle.
It should, but I havne't read up on it much.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
sort of like /proc for mysql?
What a terrible waste of time and resources. :(
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
with only an exclusive lock on the database being manipulated(*)?
(*) to avoid having to start up the postmaster with weird options
and/or stop activity on other databases under the postmaster's
control.
thanks,
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the
ple expect computers to do everything
for them, the burden of using tools properly belongs to the user.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
ctions you shouldn't call.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
http://www.postgresql.org/mhonarc/pgsql-committers/
errors out with:
'Cant load template [search.htm]! '
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
should be able to deal with this limitation by
using more than one file per table.
But if you really want to support large files on a free UNIX,
I'd try FreeBSD.
best of luck,
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
a problem on your end, post_util.o references 'floor'
and even with -lm it's not being found. Can you compile something
with post_util.o without t_postgresql.o to see if it's you or us? :)
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I
* Enrico Comini [EMAIL PROTECTED] [001117 04:04] wrote:
I use postgres with php3. Now I have to write some little applications.
What language I can use ?
Give me a valid idea.
Perl should work, you just need to install the postgresql module.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL
* Philip Hallstrom [EMAIL PROTECTED] [001109 20:37] wrote:
Yeah, that's what I've seen... I guess I was wondering if there were any
guidelines to raising them.. I mean should I up the defaults by 10? Or
up them by a percentage (to keep the relationship), etc...
here's what I use:
s, not sure how much though)
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
s booting or running your system.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
ns SEMUME=40 # /* max # of undo entries per process */
options SEMMNU=120 # /* # of undo structures in system */
I have a gig of RAM though.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
for the life
of the PGconn object.
It's described in the 'libpq' section of the programmer's manual.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
ing system, if you want an application on unix
to use less CPU then put it on a box with a slower CPU. If you
want to limit its priority against other processes so that it
shares CPU in a more friendly manner, then you want to read the
manpage for nice(1).
--
-Alfred Perlstein - [[EMAIL PROTECT
that I'd like
to not have to change later.)
huh? How are you copying to an unmounted partition?
Afaik you need the device node to be mounted before you can write to
it.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
* Roderick A. Anderson [EMAIL PROTECTED] [001016 12:32] wrote:
On Mon, 16 Oct 2000, Alfred Perlstein wrote:
huh? How are you copying to an unmounted partition?
Sorry I left that step out of the description. I usually mount it to some
dumy point long enough to copy the files
database engines.
WAL is a backup system.
afaik WAL means the end of the dreaded 'vacuum', it allows the system
to reuse free space without explicitly scanning the datafiles, it should
also do it in a manner that still allows transactional dumping.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL
and compensated
for his work rather than trying to squeeze it into his everyday
life like so many other opensource authors with "real jobs" on the
side?
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
* Bruce Momjian [EMAIL PROTECTED] [001009 22:11] wrote:
As many of you know, several businesses are involved in providing
PostgreSQL support.
After careful consideration, I have decided to accept a job with Great
Bridge. There will be a press announcement tomorrow (Tuesday) with more
makes meta data changes
(in this case file creation/removal) asyncronously, the same actually
happens with most other logging filesystems that don't support
transactions.
Since afaik postgresql doesn't use lots and lots of tempfiles you
may want to play it safe and not use softupdates.
--
-Alfred
;
does work.
I still don't understand the point of the 1's and 2's in the command though.
It tells the shell to hook the child's stderr to stdout so that all
output should go to /home/postgres/postgres.log.
Why is everyone else's script working without the -l and mine wasn't?
Check su's m
* Ian Turner [EMAIL PROTECTED] [000903 22:37] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
When I try to do this:
CREATE TABLE test (
a Integer,
b Integer,
CHECK ((SELECT SUM(t.a) FROM test t WHERE t.b = b) 1000)
);
INSERT INTO test (a, b) VALUES (100,
* Zlatko Calusic [EMAIL PROTECTED] [000903 07:59] wrote:
Hi!
This is my first post (not counting those failed because I posted them
from the other email address) so please be gentle.
I have recently started playing with PostgreSQL and found what I think
is a bug in postgres. I'm using
From: "Matthew Kennedy" [EMAIL PROTECTED]
I have a ton of data in a text delimited file from an old legacy system.
When uploading it into postgres, I'd do something like this:
COPY stuff FROM 'stuff.txt' USING DELIMITERS = '|';
The problem is some of the rows in stuff.txt may not
Chris Bitmead wrote:
That's very helpful. Can you also tell us if Proprietry 1 or Proprietry
2 was definitely NOT MS-SQL Server?
* Ned Lilly [EMAIL PROTECTED] [000815 18:59] wrote:
Er... let me put it this way. Proprietary 2 prefers to run on Windows NT.
It's oracle??? j/k
You have
* Marcos Barreto de Castro [EMAIL PROTECTED] [000721 12:45] wrote:
Hi,
Can someone tell me how can I disable the more
command at the end of any one page display in
PostgreSQL 7.0 ? I simply don't want to be asked to
press a key to continue displaying the result of a
query.
* Prasanth A. Kumar [EMAIL PROTECTED] [000717 08:49] wrote:
Gilles DAROLD [EMAIL PROTECTED] writes:
Hi,
Please don't use RPM if you don't want to have a Win$ based install.
It's remember me a very old question: Where are the DLL ?
The better way is to get the tarball and do a
* Steven [EMAIL PROTECTED] [000717 11:28] wrote:
I'm pretty new using postgres, but is there any way to add a field to a
table without droping the table and recreating it?
it's in the docs:
http://www.postgresql.org/docs/user/sql-altertable.htm
--
-Alfred Perlstein - [[EMAIL PROTECTED
* The Hermit Hacker [EMAIL PROTECTED] [000705 12:03] wrote:
just to curtail this while thread to a certain point ... switching the
license to GPL is *not* on the table, nor has it every been, nor will it
ever be ...
Good to hear, I was getting worried for a bit that the code might
become
* Michael Blakeley [EMAIL PROTECTED] [000601 19:09] wrote:
I hope someone on the list can suggest a solution for me - given a table like
CREATE TABLE EVENTS( stamp date, id varchar(16), event varchar(128) );
I'm trying to find the average age of the records. I've gotten as far as:
* Tom Lane [EMAIL PROTECTED] [000526 15:43] wrote:
"Bryan White" [EMAIL PROTECTED] writes:
4, I could probably get by with just 2 If I had to. I will give it a
try.
With the indexes deleted I am now getting 40 or 50 updates per second
instead of 5.
That's good, but does it mean
FreeBSD:
http://www.freebsd.org/
:)
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
sense to me because it makes it more complex to submit
changes.
How does one submit changes to the manpages now? Is there some way
to get them via cvsup/cvs?
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
time especially
when getting a new repo.
thanks,
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
pg_dumpall then using psql to source the file went off perfectly.
Just a nit, where's the manpages in 7.0? :)
Thanks for the excellent database system, and best of luck with
the recent step up in the business and political open source world!
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL
and
time zone part?
Thnx a lot!
I think the date_trunc() function is what you need to use.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
e count(*) is a bad idea because we only need to know
if a single entry besideds the one we are deleteing exists, not the
actual count.
Any suggestions?
thanks,
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
range (let's say a month) and perform
sums on some of the columns however "group by" the day, so that I
get rows returned that are the sum of all the day's statistics for
several days.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I k
ocket '5432'?"
well, is it at least running?
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
, but i think what you want to
look at is the RULES section of the documentation, it seems that
would be what you're looking for.
I haven't done it myself, but there's some decent examples there.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
le corruption?
I've dropped and re-created the "formatted" table (DROP/CREATE) and
this still happens.
Any ideas? (i'm using 6.5.3)
thanks,
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
* Dean Browett [EMAIL PROTECTED] [000218 15:55] wrote:
Hi,
We are running postgres-6.5.3 on a dual pentium 300 machine, 0.5Gb RAM under
Linux Redhat 6.0 (kernel 2.2.14). The machine we are using sits on a 100Mb
network and the nics are 3com3c590's. We are also using a DPT Raid
controller
* Peter Eisentraut [EMAIL PROTECTED] [000116 09:30] wrote:
On 2000-01-14, Alfred Perlstein mentioned:
issue: how to secure cgi's that access postgres
problem: passwords for postgres database are stored
in plain text in scripts. (lets assume, perl,
not a compiled
* Ron Chmara [EMAIL PROTECTED] [000116 16:18] wrote:
Peter Eisentraut wrote:
On 2000-01-14, Alfred Perlstein mentioned:
issue: how to secure cgi's that access postgres
problem: passwords for postgres database are stored
in plain text in scripts. (lets assume, perl
in advance.
Jeff MacDonald
[EMAIL PROTECTED]
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
user, not root) or
use some sort of cgiwrapper.
-Alfred
On Fri, 14 Jan 2000, Alfred Perlstein wrote:
* Jeff MacDonald [EMAIL PROTECTED] [000114 13:38] wrote:
hey folks,
this is a security issue i'd like to get some info
on, i'm sure it's more with cgi than postgres, but
heck
59 matches
Mail list logo