On Fri, Oct 04, 2002 at 12:59:22PM -0700, Chad R. Larson wrote:
> At 11:05 AM 10/4/02 , Chris Miles wrote:
> >I have been looking at Kimberlite, but it doesn't look like it supports
> >NFS shared storage, only locally attached. Otherwise it is almost perfect.
>
> The
Hi, we have 2 PostgreSQL servers running multiple instances and would like
to automate failover between them. We store db data on NFS storage on
dedicated Netapps. We can currently perform manual failover by dropping
the instance on one server and starting in on the other (the init scripts
handl
On Sun, Oct 06, 2002 at 12:47:55AM +0200, Ragnar Kjørstad wrote:
> On Fri, Oct 04, 2002 at 07:05:28PM +0100, Chris Miles wrote:
> > Hi, we have 2 PostgreSQL servers running multiple instances and would like
> > to automate failover between them. We store db data on NFS storage o
On Sun, Oct 06, 2002 at 03:21:14PM +0200, Ragnar Kjørstad wrote:
> Well; if you have a single NetApp then you still have a single point of
> failure (avoiding that is the whole purpose of failover, right?), and if
> you have two of them then it's one pretty damn expensive
> postgresql-server :)
I
On Thu, Oct 10, 2002 at 10:09:55AM -0400, Bruce Momjian wrote:
> We also don't recommend NFS directories because the NFS file behavior is
> not 100% the same as a local file system.
Can you comment on what the incompatabities are? (related to PostgreSQL
only).
We currently run PostgreSQL on Lin
Hi, we are in the process of migrating our customer data from MSSQL
to PostgreSQL. The pgadmin / migration wizard works well for
migrating data across in one go. But to get minimal down-time
are there any tools which will allow us to replicate any further
updates to the MSSQL DB directly across
On Sat, Oct 12, 2002 at 11:11:53AM -0400, Bruce Momjian wrote:
> Good question. It is my understanding that fsync, locking, and the
> order of writes is not guaranteed in NFS like it is for local file
> systems. I question how well it would handle any of the failure modes
> that local file syste
tually do
> anything. I believe that V3 gets locking right, but I don't know about fsync.
--
Chris Miles
[EMAIL PROTECTED]
http://www.psychofx.com/chris/
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an app
>
> The solution is a bit dirty, but would most certainly work.
> updatepostgresql.php and some crontab-solution should do it. Perhaps Perl?
> Shouldn't be difficult, and with some effort one might be able to make a
> more dynamic solution too... That, of course,
an be run in a web server (or similar) environment to keep a pool
of postgresql connections, and perhaps cache common queries also?
Regards,
Chris
--
Chris Miles
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet,
, altho it works
reasonably well, and all software elements are free.
Cheers,
CM
--
Chris Miles
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
issue
(despite what you may think) and is done to provide HA
failover using heartbeat.
Any tuning tips for servers this large would be appreciated.
Cheers
CM
--
Chris Miles
http://chrismiles.info/
---(end of broadcast)---
TIP 8: explain analyze is
If there are any PostgreSQL server and SQL performance
experts (ie: you understand tuning PostgreSQL servers and
optimising queries, indexes, etc) in London who are
available for some consulting work, please drop me an
email.
Regards,
Chris.
---(end of broadcast)--
s,
CM
--
Chris Miles
http://chrismiles.info/
Ramil Sagum wrote:
is there any way to see what statements/queries are currently being passed
on to the database?
---(end of broadcast)---
TIP 7: don't forget to increase your free space ma
other).
The only fix I can think of is to dump and restore the whole DB, based on
the fact that a newly restored DB appears to work much better, but surely
I shouldn't have to do this? What else can i do to fix it?
Cheers,
CM
--
Chris Miles
http://chrismiles.info/
---(
Stephan Szabo wrote:
On Tue, 19 Aug 2003, Chris Miles wrote:
I have a DB that appears to perform badly. A test of one table
with one of the typical queries gives me a query plan indicating
a Seq Scan;
What does it give if you set enable_seqscan=off; before the explain?
ok, with enable_seqscan=off
lave pair.
Regards,
Chris.
--
Chris Miles
http://chrismiles.info/
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
ore) in at least
7.3 and above. Also, it's somewhat depricated in favor of using the
.pgpass file.
--
Chris Miles
http://chrismiles.info/
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
j
source
version just released is a modified version of 1.2 basically.
Cheers,
Chris.
Andrew Sullivan wrote:
On Tue, Aug 26, 2003 at 06:19:12PM +0100, Chris Miles wrote:
eRServer
http://www.erserver.com/
Commercial, looks professional. Not free.
However, No trial or evaluation ?
There's (about
want data files
growing indefinitely (any more than they need to) so I hope
the routine VACCUM ANALYSE will take care of this.
My pg is version 7.2.x but the question can apply to newer
versions as well if the functionality has changed.
Regards,
Chris.
--
Chris Miles
http://chrismiles
20 matches
Mail list logo
