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:saravana...@sodtechnologies.com www.sodtechnologies.com Open Source ERP | Mobile Apps | IT Consulting | Staff Augmentation On Thursday, 20 February 2014 12:35 AM, Rahul Saha <rahul.bloom...@gmail.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 <r...@iol.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 >r...@iol.ie > > >-- >Sent via pgsql-general mailing list (pgsql-general@postgresql.org) >To make changes to your subscription: >http://www.postgresql.org/mailpref/pgsql-general > -- Thanks & Regards Rahul Saha +91 8806351116
