2007/10/18, Bill Moran <[EMAIL PROTECTED]>:
> I don't know of any system that will just hand you those capabilities.
>
> Every multi-master system I've ever heard of requires high-speed links
> between the masters, otherwise the synchronization is far too slow to
> be usable.
I supposed so. Howeve
I am considering pgsql as the RDBMS in a project with the following constraints:
- there's a master and reserve instance of the RDBMS on every remote location
- there's a master and reserve instance of the RDBMS on a central location
- the connections are DSL connections and therefore unreliable
-
2007/10/16, Sualeh Fatehi <[EMAIL PROTECTED]>:
> SchemaCrawler for PostgreSQL will allow you to do the diffs. With
> SchemaCrawler for PostgreSQL, you can take human-readable snapshots
> of the schema and data, for later comparison. SchemaCrawler outputs
> details of your schema (tables, views, pr
Looking at the mailing list archive, this is just one in a rather long
line of questions regarding diffing db schema dumps, but I've been
unable to find what I was looking for in any of the prior
conversations. I know of apgdiff (seems to work very nicely) and of
other specialized pg diff tools (as
2007/4/3, Andrus <[EMAIL PROTECTED]>:
I needd to re-write a lot of compliatated SQL select statements to run them
in server which generate reports.
Currently they are running in client side.
Client application uses procedural language to do additional processing of
data retrieved from PostgreSQ
For small and moderate size databases, I find that the simplest way to
estimate the database size is to do:
du -ks /var/lib/postgresql/data
...create a new database, restore a backup of the database in whose
size you're interested in
du -ks /var/lib/postgresql/data
Compare the first and second "
I have a problem with query optimization. Since it's a bit hard to
explain, I'll describe the database structure and list the queries
first. The database holds contacts information for a call center. The
general idea is to have operators call a random contact and record
the results. Rules for pick
2007/3/8, Raymond O'Donnell <[EMAIL PROTECTED]>:
On 08/03/2007 12:32, Hakan Kocaman wrote:
> i work with Clay in Eclipse:
> http://www.azzurri.jp/en/software/clay/
I use Clay also, from time to time. The only downside is that you can't
print from the free version, and the commercial version isn
2007/2/25, Tom Lane <[EMAIL PROTECTED]>:
If the objective is to claim a world record, we'd look pretty silly
trying to do so with a nonstandard, non-certified test. The point
of certification in this context is that you have someone else
attesting to the validity of your results. Without that,
2007/2/24, Joshua D. Drake <[EMAIL PROTECTED]>:
Ron Johnson wrote:
> On 02/24/07 11:00, Tom Lane wrote:
>>> "Tomi N/A" <[EMAIL PROTECTED]> writes:
>>>> ...which made me think: postgresql aims at the same (or very similar)
>>>> clients a
I just ran into an article about Oracle setting a world record in some
kind of test:
http://www.oracle.com/corporate/press/2007_feb/TPC-H_300GB_Benchmark_wHP.html?rssid=rss_ocom_pr
...which made me think: postgresql aims at the same (or very similar)
clients and use cases as Oracle, DB2 and MSSQ
This is probably a question more appropriate on a gentoo mailing list,
but I'll ask anyway as it obviously has to do with postgresql and I've
a feeling someone will probably know: can anyone explain what is it
that happens here when I try to stop the postmaster? What can I do
about it?
# /etc/ini
2007/2/3, George Weaver <[EMAIL PROTECTED]>:
>it's a windows-related problem
Is the Task Scheduler service running? (Start > Settings > Control Panel >
Administrative Tools > Services - Task Scheduler?).
If the Task Scheduler service is running , what does the Task Scheduler log
indicate abou
2007/2/2, George Weaver <[EMAIL PROTECTED]>:
And the .bat file script?
The .bat script is of no importance: it's a windows-related problem
(or, to be more precise, the problem of my ignorance when it comes to
windows scripting). The most trivial .bat scripts containing only a
simple echo state
2007/2/2, George Weaver <[EMAIL PROTECTED]>:
From: "Tomi N/A"
> At this point, I decided to try a much more primitive approach: using
> a windows scheduled task running a .bat or .cmd script which in turn
> calls pg_dump.
It might be helpful if you provided the exac
I'm trying to set up an automatic backup mechanism and have a number
of questions about issues I've encountered.
First of all, I tried to install pgAgent (the server is running win2k3
and pgsql 8.1.5). Trying to start the pgagent service results in an
"error 193", one google knows very little abou
Besides being easy to schedule and very flexible, manipulating data
with queries is extremely powerful and fairly easy to maintain
assuming you know a little SQL -- thanks to postgresql's huge array of
built in string manipulation functions. Your skills learned here will
pay off using the databas
2007/1/23, Paul Lambert <[EMAIL PROTECTED]>:
G'day,
Is there an equivalent in Postgres to the DTS Packages available in M$
SQL server.
I use these in SQL server to pre-load data from CSV files prior to
enabling replication from my primary application. Any pointers on where
best to go for this
2006/12/27, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
Hi everybody,
I'm looking for a database system for a SCADA system. The major
probles I think it's on performance because the application it's going
to poll about 4k variables per second from hardware and has to register
the values on the procces
Bill makes several valid points, but in spite of them, the app I'm
writing has almost no logic in the database.
Why? Well, mostly because it would be too much trouble to remove all
of it. :) No, seriously...
Lack of a good language. Postgresql understands a growing number of
languages and that's
2006/12/13, Tom Lane <[EMAIL PROTECTED]>:
Martijn van Oosterhout writes:
> I don't beleive you have to explicitly grant access to the database, or
> the schema, but you definitly have to grant access to the tables
> directly.
They're completely separate privileges. GRANT ON DATABASE grants or
2006/9/28, Najib Abi Fadel <[EMAIL PROTECTED]>:
when u connect to the database type:
\h GRANT
and you will get all the Grant options:
GRANT { { CREATE | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] }
ON DATABASE dbname [, ...]
TO { username | GROUP groupname | PUBLIC } [, ...] [ WITH G
Ragnar, Marc, thanks so much for the help: DISTINCT ON was *exactly*
what I needed.
It's not a part of any SQL standard I know of, but does the job _wonderfully_.
Cheers,
t.n.a.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
Don't really know where to ask this...the general mailing list sounds
like the closest.
Let's say I have three tables: owner, factory and product with a 1:N
relationship at each step.
Assuming that a product has a production date, how would you go about
returning a factory for every owner, where
I'm trying to optimize performance on my development laptop, one of
the main bottlenecks beeing a 4200 rpm disk.
It's a fairly good machine (Pentium M, 1,73GHz, 1GB RAM), but pg
doesn't seem to use the processing power: the disk works all of the
time.
I'm working with a database with a couple of
2006/12/9, Martijn van Oosterhout :
On Sat, Dec 09, 2006 at 12:08:08PM +, Tomi N/A wrote:
> A variable called search_path is set to public at the begining of the
> fuzzystrmatch script.
> Can anyone tell me what it does?
Check the documentation for the details, but it's bas
A variable called search_path is set to public at the begining of the
fuzzystrmatch script.
Can anyone tell me what it does?
Cheers,
t.n.a.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose a
2006/12/6, Markus Schiltknecht <[EMAIL PROTECTED]>:
Hi,
Tomi N/A wrote:
>> > When the subselect returns a lot of results, pgsql really takes it's
>> time.
>
> 8.1.something
PostgreSQL 8.2 improved a lot for IN clauses with lots of values. I
think it now perform
2006/12/5, Scott Marlowe <[EMAIL PROTECTED]>:
On Tue, 2006-12-05 at 16:32, Tomi N/A wrote:
> One type of query does come to mind, now that I think about it.
> pgsql has trouble handling queries like
> SELECT * FROM t0 WHERE t0.id_t1 IN (SELECT t1.id FROM t1 WHERE...)
>
2006/12/5, Tom Lane <[EMAIL PROTECTED]>:
These sorts of reports would be far more helpful if they contained some
specifics. What queries does MSSQL do better than Postgres, exactly?
You are of course correct, Tom.
I'm sorry I'm not in a position to replay what I've been doing a year
ago...I w
2006/12/4, Ian Harding <[EMAIL PROTECTED]>:
On 11/13/06, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> On Mon, 2006-11-13 at 15:36, novnov wrote:
> > OK, thanks everyone, I gather from the responses that postgres performance
> > won't be an issue for me then. If MS SQL Server and Postgres are in the
2006/11/29, Guy Rouillier <[EMAIL PROTECTED]>:
John DeSoi wrote:
> There are supposedly some native Mono toolkits for
> the Mac, but I have yet to see any Mac application that uses it.
I'm aware there is substantial anti-Java bias here, but the Standard
Widget Toolkit (SWT) uses native widgets o
2006/11/29, Joshua D. Drake <[EMAIL PROTECTED]>:
On Wed, 2006-11-29 at 17:31 +, Tomi N/A wrote:
> 2006/11/29, Joshua D. Drake <[EMAIL PROTECTED]>:
> > On Wed, 2006-11-29 at 10:17 -0600, Tony Caduto wrote:
> > > Joshua D. Drake wrote:
> > > > The cl
2006/11/29, Joshua D. Drake <[EMAIL PROTECTED]>:
On Wed, 2006-11-29 at 10:17 -0600, Tony Caduto wrote:
> Joshua D. Drake wrote:
> > The closest I think you would find is Eclipse or maybe KDevelop.
> >
> Actually NetBeans 5.5 is the closest thing I have seen for Java that is
> even close to visual
2006/11/28, Andrus <[EMAIL PROTECTED]>:
Only MONO/WinForms is a way to go in any serious application.
Mono needs to show a lot more than beagle and f-spot to be even
considered interesting, let alone a platform to base industrial
strength applications on.
As long as that doesn't radically cha
35 matches
Mail list logo
