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/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. However, I
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,
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
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 PostgreSQL
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
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't
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 and use cases as Oracle, DB2 and MSSQL. I pose the question
from an advocacy
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,
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?
#
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 about the
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
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 exact pg_dump command you are trying
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
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
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
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/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
2006/12/13, Tom Lane [EMAIL PROTECTED]:
Martijn van Oosterhout kleptog@svana.org 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
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
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
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?
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
2006/12/9, Martijn van Oosterhout kleptog@svana.org:
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
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 performs as good as an equal join query.
Thats
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 same
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
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...)
When the subselect returns
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 studio
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 closest I think you would find is Eclipse or maybe KDevelop
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 on
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
34 matches
Mail list logo