| From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: configuration error |
| Date: | 2014-02-20 15:14:18 |
| Message-ID: | le563t$6ft$1@ger.gmane.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
saravanan Chow, 20.02.2014 06:41:
> There is nothing in the pg_log.
> Log files contains : "2014-02-20 10:58:55 IST LOG: received fast shutdown request
> 2014-02-20 10:58:55 IST LOG: aborting any active transactions
> 2014-02-20 10:58:55 IST LOG: autovacuum launcher shutting down
> 2014-02-20 10:58:55 IST LOG: shutting down
> 2014-02-20 10:58:55 IST LOG: database system is shut down "
> It is working upto 1.5GB , more than 1.5GB its throwing the error.
>
Sounds as if you are using 32bit Windows (or Postgres).
Under 32bit, a single process cannot allocate more than 2GB in total.
Windows also reserves some memory from that maximum and therfor the actual maximum memory for a 32bit process is somewhere around 1.5GB
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Willy-Bas Loos | 2014-02-20 15:45:18 | [postgis-users]postgis in postgresql apt and upgrades |
| Previous Message | Dev Kumkar | 2014-02-20 13:04:31 | Re: UTF-8 collation on Windows? |