After having seen this Perl / Java debate go back and forth...
I can't help myself...
The answer is Python !!!
For the best middleware you're ever likely to integrate with Postgresql :
http://www.zope.org
To see its "enterprise scalability":
http://www.zope.org/About
To see it taking LOTS of h
Hi,
from: http://www.postgresql.org/idocs/index.php?backup.html :
"pg_dump -h host1 dbname | psql -h host2 dbname"
You could run this out of cron on your internal DB server (host1)
And use a firewall rule like:
# Allow internal DB server to use TCP for DB dumps
pass in quick proto tcp from
>This is almost certainly a lousy idea. You do *not* want to chew up all
>available memory for PG shared buffers; you should leave a good deal of
>space for kernel-level disk buffers.
I decided to start high on buffers because of Bruce's:
http://www.ca.postgresql.org/docs/hw_performan
Hi,
I am about to put a 7.1.2 server into production on RedHat 7.1
The server will be dedicated to PostgreSQL, running a bare minimum of
additional services.
If anyone has already tuned the configurable parameters on a dual PIII w/
1GB RAM then I
will have a great place to start for my performa