On Mon, 28 Jan 2008 14:11:21 -0800
"Dann Corbit" <[EMAIL PROTECTED]> wrote:
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:pgsql-general-
> > [EMAIL PROTECTED] On Behalf Of John Gateley
> > Sent: Monday, January 28, 2008 2:04 PM
> >
I managed to get in this state,
if it was something I did, or perhaps caused by killing the
postmaster the wrong way (I don't think I ever did this, but
maybe), or a crash.
I did do a brief search, didn't find anything seemingly related to this.
Thanks,
j
--
John Gateley <[EM
On Mon, 28 Jan 2008 21:36:35 -0500
Tom Lane <[EMAIL PROTECTED]> wrote:
> John Gateley <[EMAIL PROTECTED]> writes:
> > Somehow I have managed to have two tables with duplicate keys.
> > ...
> > But, mostly, I'm wondering how I managed to get in this state
On Tue, 29 Jan 2008 12:53:11 -0500
Tom Lane <[EMAIL PROTECTED]> wrote:
> John Gateley <[EMAIL PROTECTED]> writes:
> > Tom Lane <[EMAIL PROTECTED]> wrote:
> >> John Gateley <[EMAIL PROTECTED]> writes:
> >>> Somehow I have managed to have two
e NO transactions in
mydbtest until I come in and start testing, does this mean
auto-vacuum won't analyze it? Is this maybe related to question
1 where I think auto-vacuum actually wasn't running?
Thanks,
j
--
John Gateley <[EMAIL PROTECTED]>
--
Sent via pgsql-general mailing li
On Thu, 8 May 2008 10:54:32 -0400
Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> John Gateley wrote:
> > Hi, I have a couple of questions on the auto-vacuum daemon:
> >
> > 1) How do I know it is running.
>
> Open a session and run "SHOW autovacuum".
On Thu, 8 May 2008 10:58:47 -0700
Alan Hodgson <[EMAIL PROTECTED]> wrote:
> On Thursday 08 May 2008, John Gateley <[EMAIL PROTECTED]> wrote:
> > But the new database, mydbtest, always has slow queries.
> > I run an analyze and they speed up.
>
> Do the query
't seem to close the connection.
Any ideas?
Thanks,
j
--
John Gateley <[EMAIL PROTECTED]>
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi,
My database stopped responding last night (Postgres 8.1.4).
at 2 am, a vacuum began running:
/usr/local/pgsql/bin/vacuumdb -afz
When I came in to work this morning, I could query some tables
but not others. There were many(100) processes like:
postgres 11791 6901 0 02:07 ?00:00:00
On Wed, 07 Mar 2007 09:27:04 -0800
Reece Hart <[EMAIL PROTECTED]> wrote:
> On Wed, 2007-03-07 at 10:08 -0600, John Gateley wrote:
> > I'm guessing it's something related to table locks.
> ...
> > Any pointers on what I should be looking for to prevent t
Sorry if this is a FAQ, I did search and couldn't find much.
I need to make my Postgresql installation fault tolerant.
I was imagining a RAIDed disk array that is accessible from two
(or multiple) computers, with a postmaster running on each computer.
(Hardware upgrades could then be done to each
Thanks very much to all who responded, the replies were very helpful.
j
On Thu, 10 May 2007 20:43:20 -0500
John Gateley <[EMAIL PROTECTED]> wrote:
> I need to make my Postgresql installation fault tolerant.
> ...
---(end of broadcast)-
On Thu, 17 May 2007 09:45:18 -0400
Kenneth Downs <[EMAIL PROTECTED]> wrote:
> The last one left that I have is the sticky issue of a paypal IPN
> transaction coming in. I believe it applies generally to financial
> transactions. The user is sent by our application to the Paypal site.
> When
Take a search through the archives for:
Fault Tolerant Postgresql (two machines, two postmasters, one disk array)
I recently posted this question and got a lot of good responses.
j
On Fri, 25 May 2007 18:59:34 +0100
Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
> On 25/05/2007 18:56, Arnaldo Gand
14 matches
Mail list logo
