configuration error

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@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

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@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
rod@iol.ie <javascript:;>

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org<javascript:;>
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--

Thanks & Regards
Rahul Saha

+91 8806351116

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.s@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.blooming@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 <rod@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
rod@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

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general