No probably not. I mean they are all pretty easy (especially log
shipping) but it is definitely true they are slow, depending on the size
of the database.
As an alternative is there a clustering or multi master replication
scheme that would be useful in a WAN? Preferably with a prefered
Greg Smith wrote:
On Wed, 10 Dec 2008, Liraz Siri wrote:
Linux may still be behind Solaris in a few areas but I'll wager Linux
will catch up and make Solaris completely, utterly obsolete in the not
too distant future.
I shouldn't have posted this comment. It's flamebait.
Great, free money
On Thu, Dec 11, 2008 at 3:54 AM, Greg Smith [EMAIL PROTECTED] wrote:
On Wed, 10 Dec 2008, Liraz Siri wrote:
Besides Sun Microsystems hasn't been a financially healthy organization
for quite a few years, as evidenced by its rather dismal stock performance:
What do you folk think is the best way to manage deployments to databases?
This would include things like table/view/function creations/changes and
possibly static data changes.
Any good solutions out there?
Thanks
Thom
Greg Smith [EMAIL PROTECTED] writes:
Not exactly. What it said was To avoid a database shutdown, execute a
full-database VACUUM. In that context, full means you vacuum
everything in the database, but only regular VACUUM is needed. VACUUM
FULL, as you learned the hard way, is a more
Tom Lane wrote:
Greg Smith [EMAIL PROTECTED] writes:
Not exactly. What it said was To avoid a database shutdown, execute a
full-database VACUUM. In that context, full means you vacuum
everything in the database, but only regular VACUUM is needed. VACUUM
FULL, as you learned the hard
Alvaro Herrera [EMAIL PROTECTED] writes:
Tom Lane wrote:
Maybe we could rephrase it as whole-database VACUUM?
database-wide VACUUM?
Yeah, that's probably better, because I think we use that phrase in
the documentation already.
regards, tom lane
--
Sent via
Hi all
pgagent.sql creates a new schema for pgagent stuff but it shows it as catalog
whats the diference? as it seems they are created almost equal..
for pgagent 'catalog'
CREATE SCHEMA pgagent
AUTHORIZATION postgres;
COMMENT ON CATALOG pgagent IS 'pgAgent system tables';
for public schema
I'm asking this as a more general question on which will perform better.
I'm trying to get a set of comments and their score/rankings from two
tables.
*comments*
cid (integer, primary key)
title
body
*comment_ratings*
cid (integer, primary key)
uid (integer, primary key)
score
*Option 1*
I need to add some complex constraints at the DB.
For example.
Do not allow a line item of inventory to be changed if it does result in
the same number of joints originaly shipped.
These will involve several tables.
What is the best approach for this?
Here is what I have been trying.
On Wed, Dec 10, 2008 at 08:41:30PM -0700, Scott Marlowe wrote:
one of the real time replication. Failover in slony is pretty easy to
do and happens in seconds. But you do have to resubscribe the master
as a slave and copy everything over again after a failover to make the
old master the new
Greg Smith [EMAIL PROTECTED] writes:
On Thu, 11 Dec 2008, Phillip Berry wrote:
I'm not running PITR and checkpoint_segments is set to 100 as this is
home to a very write intensive app.
That's weird then. It shouldn't ever keep around more than 201 WAL
segments. I've heard one report of a
On Thu, Dec 11, 2008 at 9:59 AM, Tom Lane [EMAIL PROTECTED] wrote:
Greg Smith [EMAIL PROTECTED] writes:
On Thu, 11 Dec 2008, Phillip Berry wrote:
I'm not running PITR and checkpoint_segments is set to 100 as this is
home to a very write intensive app.
That's weird then. It shouldn't ever
On Thu, Dec 11, 2008 at 10:09 AM, Scott Marlowe [EMAIL PROTECTED] wrote:
Don't forget that the OP mentioned earlier that he had very long help
open connections with possible long help open transactions.
Long held. held. not help.
--
Sent via pgsql-general mailing list
On Wed, 2008-12-10 at 18:34 -0500, Rutherdale, Will wrote:
Thanks very much, Steve.
The main (but not only) type of data replication activity I'm interested
in right now would be the warm standby. Thus it appears from the
documents you showed me that log shipping is one solution currently
On Thu, 2008-12-11 at 17:09 +, Simon Riggs wrote:
On Wed, 2008-12-10 at 18:34 -0500, Rutherdale, Will wrote:
Thanks very much, Steve.
Yes, everything you need for log shipping has been contributed to the
main project. If you read things elsewhere, please refer closely to the
docs which
On Thu, Dec 11, 2008 at 5:30 AM, Thom Brown [EMAIL PROTECTED] wrote:
What do you folk think is the best way to manage deployments to databases?
This would include things like table/view/function creations/changes and
possibly static data changes.
The easiest way I've found to do it is to
On Thu, 2008-12-11 at 09:14 -0800, Joshua D. Drake wrote:
On Thu, 2008-12-11 at 17:09 +, Simon Riggs wrote:
On Wed, 2008-12-10 at 18:34 -0500, Rutherdale, Will wrote:
Thanks very much, Steve.
Yes, everything you need for log shipping has been contributed to the
main project. If
2008/12/11 Angel Alvarez [EMAIL PROTECTED]:
Hi all
pgagent.sql creates a new schema for pgagent stuff but it shows it as catalog
whats the diference? as it seems they are created almost equal..
They are the same. pgAdmin just classes the pgagent schema as a
catalog so it doesn't get in the
On Thu, 2008-12-11 at 17:37 +, Simon Riggs wrote:
On Thu, 2008-12-11 at 09:14 -0800, Joshua D. Drake wrote:
I think this statement is misleading. The only thing core contains is
the ability to use a bunch of utilities (with the exception of
pg_standby) that aren't in core to provide
Scott Marlowe scott.marl...@gmail.com writes:
On Thu, Dec 11, 2008 at 9:59 AM, Tom Lane t...@sss.pgh.pa.us wrote:
AFAIK the only non-PITR reason for WAL files to not get recycled is if
checkpoints were failing. Do you still have the postmaster log from
before the original crash, and if so is
I installed the Postgres Database on my work planning replace Oracle on the new
IT systems. I have noticed some differences (between Oracle and Posrgres) that
I would like clarify.
On postgres, I create 2 users and their schemas. Schema User1 owned by
User1 and Schema User2 owned by User2.
Hi guys,
you knowns a tool for automatic converter plsql in pgplsql?
this tool exist?
Thanks
Paulo Moraes
Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com
I have a question concerning psql. I found that psql has a defined
command '-t' and that it turns off printing of column names
and result
row count footers, etc.
what I look for, is a command, which would turn off result row count
footer, but would print column names.
is there an
On Thu, 2008-12-11 at 09:52 -0800, Joshua D. Drake wrote:
On Thu, 2008-12-11 at 17:37 +, Simon Riggs wrote:
On Thu, 2008-12-11 at 09:14 -0800, Joshua D. Drake wrote:
I think this statement is misleading. The only thing core contains is
the ability to use a bunch of utilities
On Thu, 2008-12-11 at 19:24 +, Simon Riggs wrote:
True, we rely on the existence of rsync, scp etc.. and go to great pains
to provide as much choice as possible.
If you think other things are required you are welcome to contribute
them so they can be verified fault free by the
On Thu, 2008-12-11 at 11:29 -0800, Joshua D. Drake wrote:
As I said before, if you think something is missing, submit a software
or a doc patch and submit it to peer review. Until then, I think its
misleading to claim that only your magic spice makes replication work
correctly and to
On Thu, 2008-12-11 at 19:33 +, Simon Riggs wrote:
On Thu, 2008-12-11 at 11:29 -0800, Joshua D. Drake wrote:
As I said before, if you think something is missing, submit a software
or a doc patch and submit it to peer review. Until then, I think its
misleading to claim that only your
On Friday 12 December 2008 03:59:42 Tom Lane wrote:
Greg Smith gsm...@gregsmith.com writes:
On Thu, 11 Dec 2008, Phillip Berry wrote:
I'm not running PITR and checkpoint_segments is set to 100 as this is
home to a very write intensive app.
That's weird then. It shouldn't ever keep
paulo matadr wrote:
you knowns a tool for automatic converter plsql in pgplsql?
this tool exist?
EnterpriseDB claim that they can do something like this,
but I don't believe that there is any tool which can do
more than assist you.
Yours,
Laurenz Albe
--
Sent via pgsql-general mailing list
Hi PostgreSQL,
I'd like to specify a pattern then apply that pattern to match each
element of an array:
rconover=# select 'foobar%' ~~ ANY (ARRAY['bar', 'cat', 'foobar:asdf']);
?column?
--
f
(1 row)
I'd like the the pattern would be evaluated against all of the array
elements,
We are planning to use Postgres for one of our production database
system. I noticed when I go to http://www.postgresql.org/download/,
the one click binary package for Linux is actually an enterpriseDB
package (http://www.enterprisedb.com/products/pgdownload.do#linux-x64)
I also noticed that
32 matches
Mail list logo