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
somewherearound 1.5GB
