From: | saravanan Chow <saravananchow(at)yahoo(dot)com> |
---|---|
To: | Rahul Saha <rahul(dot)blooming(at)gmail(dot)com>, "rod(at)iol(dot)ie" <rod(at)iol(dot)ie> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: configuration error |
Date: | 2014-02-20 05:41:00 |
Message-ID: | 1392874860.82189.YahooMailNeo@web194903.mail.sg3.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
Saravanan S
Database Developer
Mob:+919567066647| Tel:+91 0484 4031713
Email:saravanan(dot)s(at)sodtechnologies(dot)com
www.sodtechnologies.com
Open Source ERP | Mobile Apps | IT Consulting | Staff Augmentation
On Thursday, 20 February 2014 12:35 AM, Rahul Saha <rahul(dot)blooming(at)gmail(dot)com> wrote:
As much my knowledge. There is no pre requisite.
It would work fine after your change. As said by Ray, have a closer look to the log file as mentioned.
Regards
Rahul Saha
On Wednesday, February 19, 2014, Raymond O'Donnell <rod(at)iol(dot)ie> wrote:
On 19/02/2014 12:21, saravanan Chow wrote:
>> Hi,
>> I'm working in postgresql-9.1.1 on windows 7 ,so i want to know what is
>> the pre-requiest to change the shared buffer in windows 7.
>> In my test machine i've 4gb ram. I tried to increase the shared buffer 1gb
>> to 2gb and restart the services, but it shown the error like " the
>> postgresql-9.1 - postgresql server 9.1 service on local computer started
>> and
>> then stopped.some service stop automatically if they are not in use by
>> other
>> services or programs ".
>> thanks for reply
>
>PostgreSQL maintains its own log, separate to the Windows event log -
>it'll be in the "pg_log" directory, under the data directory. Have a
>look there for further clues as to what's going wrong.
>
>Ray.
>
>--
>Raymond O'Donnell :: Galway :: Ireland
>rod(at)iol(dot)ie
>
>
>--
>Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-general
>
--
Thanks & Regards
Rahul Saha
+91 8806351116
From | Date | Subject | |
---|---|---|---|
Next Message | Sameer Kumar | 2014-02-20 06:21:44 | Re: Possible to improve optimisation / index usage based on domain properties of a function |
Previous Message | Sameer Kumar | 2014-02-20 04:32:07 | Re: Simple Web-based alternative to PgAdmin |