Thanks Tom. It's all working again now.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 14, 2006 6:10 PM
To: Rob Owen
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Out of memory (Failed on request size 24)
"Rob Owen" &l
"Rob Owen" <[EMAIL PROTECTED]> writes:
> Breakpoint 1, 0x000119dc in errfinish () from postmaster
> (gdb) bt
> #0 0x000119dc in errfinish () from postmaster
> #1 0x0001a680 in AllocSetAlloc () from postmaster
> #2 0x00012a1c in MemoryContextAlloc () from postmaste
) cont
Continuing.
Program exited normally.
(gdb)
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 14, 2006 11:01 AM
To: Rob Owen
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Out of memory (Failed on request size 24)
"Rob Owen&quo
"Rob Owen" <[EMAIL PROTECTED]> writes:
> Attached to backend postmaster and got the following. Hope this helps.
Nope, you got the postmaster itself there, you need to look at the new
child process. (It should look like "postgres: startup" in ps.)
regards, tom lane
--
.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 14, 2006 11:01 AM
To: Rob Owen
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Out of memory (Failed on request size 24)
"Rob Owen" <[EMAIL PROTECTED]> writes:
> PostgreSQL 8.0.3 runni
:113
<2006-11-14 05:53:49 EST>LOG: 0: logger shutting down
<2006-11-14 05:53:49 EST>LOCATION: SysLoggerMain, syslogger.c:361
<2006-11-14 05:53:49 EST>DEBUG: 0: proc_exit(0)
<2006-11-14 05:53:49 EST>LOCATION: proc_exit, ipc.c:95
<2006-11-14 05:53:49 EST>
"Rob Owen" <[EMAIL PROTECTED]> writes:
> PostgreSQL 8.0.3 running on AIX 5.3 (same thing happens on 5.1 though).
> DBMS was running fine for some months but now one of the databases isn't
> accessible. Any help would be greatly appreciated.
Just one database? Sounds like it might be corrupt da
On Tue, Nov 14, 2006 at 05:53:08AM -0500, Rob Owen wrote:
> PostgreSQL 8.0.3 running on AIX 5.3 (same thing happens on 5.1 though).
> DBMS was running fine for some months but now one of the databases isn't
> accessible. Any help would be greatly appreciated.
>
> DBMS starts up fine, but any op
PostgreSQL 8.0.3 running on AIX 5.3 (same thing happens on 5.1 though).
DBMS was running fine for some months but now one of the databases isn't
accessible. Any help would be greatly appreciated.
DBMS starts up fine, but any operation on the files database (psql files,
vaccumdb files, pgdump f
