On Dec 18, 2010, at 5:55 PM, Vishnu S. wrote:
>
>
> Hi,
>
>
> I am usinf Slony slony-I-2.0.2 in windows. I have a Master and a slave
> machine. When the master machine is failed, I have executed the failover
> script and the slave is switched to master. My problem is that while
> inserting a
"Tsing, Vadim" wrote:
> We are trying to select a database engine for a new product we plan
> to start developing. One of the requirements is to be able to ship
> the data on the media and install it on the user's hard-drive.
>
> One of the issues we've run into is that pg_restore takes a lot of
Martin von Oertzen wrote:
> why i can't move the last table rows to the beginning step by step?
I believe that if you search the hackers list from somewhere around
six to twelve months ago, someone posted a client program which did
that. I think it wasn't pursued for lack of interest -- it's
Kevin,
I realize that copying database directory is not supported since OIDs
sequencing will be broken. I also verified that Postgres makes sure that
it creates unique file names when writing pages to the disk, that is why
I've kind of hoped that Postgres may somehow deal with it. :-)
As far as s
"Tsing, Vadim" wrote:
> Out databases vary in size, bat many of the have tables with
> millions of rows. Those tables are indexed. One of the databases
> that we've timed, took about 12 min to load the data and another
> 10-12 min to re-create indexes. The dump file is about 400 MB. This
> is by
Actually, that same app we ship on the media is also available as a web
app. The media is offered to customers who are requesting local access
or that have slow or unreliable Internet access. These are the
requirements we have to deal with. :-(
-Original Message-
From: Kevin Grittner [ma
Syed Khan wrote:
> I have setup a warm stanby solution using Postgres 8.4.2 on windows
> 2008 64 bit server every few hours the primary "live" database goes
> down with the following messages. Is there a fix to the issue ?
> Please tell me what could be happening...?
>
> I know the servers are
