Postgres Pro
Downloads
Home   >   mailing lists

Thread: configuration error

configuration error

From
saravanan Chow
Date:
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



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

  



Re: configuration error

From
Raymond O'Donnell
Date:
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

Re: configuration error

From
Rahul Saha
Date:
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

Re: configuration error

From
saravanan Chow
Date:
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




Re: configuration error

From
Thomas Kellerer
Date:
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