Re: error in postgresql

From: Sharmad Naik <sharmad(at)goatelecom(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: error in postgresql
Date: 2001-11-15 06:56:01
Message-ID: 20011115122601.A878@goatelecom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi Tom,
It's not there. Now do i say
postmaster -D <directory name of dbase> ulimit -c 0
Is this right?
-TIA
Sharmad

On Sun, Nov 11, 2001 at 12:00:39PM -0500, Tom Lane wrote:
> Sharmad Naik <sharmad(at)goatelecom(dot)com> writes:
> > When I gave a search for core file I didn't seems to
> > exist.pg_dump didnot create the core file
>
> pg_dump isn't coring, it's the backend. Backend core files normally
> appear in $PGDATA/base/whicheverdb/. If you don't see one there,
> it's likely because you started the postmaster under "ulimit -c 0"
> (this seems to be the default for init-script-started processes on
> at least some Linux distros :-(). Restart it with "ulimit -c unlimited"
> and try again.
>
> regards, tom lane

--
Feel free to contact me (flames about my english and the useless of this
driver will be redirected to /dev/null, oh no, it's full...).
(Michael Beck, describing the PC-speaker sound device)
---------------------
__ _ _ _ _
|_|_||_||_||\/||_|| \
_|| || || \| || ||_/
"What we cannot speak about we must pass over in silence."
Ludwig Wittgenstein (1889-1951), Austrian philosopher

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Aasmund Midttun Godal 2001-11-15 13:38:13 Unable to use '-' in column names in PLPGSQL
Previous Message Jason Earl 2001-11-14 17:17:44 Re: Optimization with dates