Go to the directory /var/lib/pgsql/data. You will find a file named postmaster.opts.
This file indicates the options currently in use by the Postmaster. It should look something like this:
I have found that 32 server processes just isn't enough and I will be changing this to 128. I will also be changing
the buffers to 512, which gives me 4M of buffer space.
To make this change happen on the next start or restart of postgres the file named postmaster.opts.default needs
to be edited. This is in the directory /var/lib/pgsql/data.
It should look something like this:
Go back to the beginning of Step 4 and restart postgres. Look at the file postmaster.opts again. It now should look something like this:
If it doesn't then something went wrong. I haven't found a need to change any of the other options.
| Comments: |
| Postgres & PHP | Jim Morrissey | 02/12/06 08:35 |
| RE: Setup linux Postgres but Windows 2k Client | devendra | 12/20/05 07:17 |
| How to connect postgresql | Prasobh T.K | 11/28/05 03:32 |
| RE: returning newly created primary key | Mile Zajkovski | 11/16/05 09:15 |
| Difference between Oracle and Postgres | Amol Kelkar | 07/28/05 06:50 |
| Postgres SQL and Java aplicatio liking | prasad | 07/13/05 03:21 |
| Stored Procedures which returns identity seed | Renjitha | 05/05/05 07:35 |
| password authontication | Ramzi | 05/04/05 05:34 |
| LINUX+POSTGRES+PHP | aminata | 03/15/05 12:11 |
| regarding configuring &starting Postgresql | hemant ambulgekar | 03/15/05 07:36 |
| problem on quick starting postmaster | shenxiuer | 03/07/05 04:02 |
| php problem | wahid | 01/17/05 06:44 |
| which mail server can work with php & how | shubhra | 12/31/04 01:29 |
| RE: Postgres+Windows+PHP | Drew McLain | 03/12/04 10:56 |
| How to Install Postgres in client mode | Bimal Kanti Dutta | 11/03/02 12:32 |
| RE: Migration from IRIX to Linux | David Bryan | 10/26/02 21:56 |
| how to store and access a bmp file in postgre | revathi | 10/26/02 08:34 |
| synonym | MichelRueher | 10/10/02 14:55 |
| Changing default user's passwd | Reshat Sabiq | 09/11/02 13:24 |
| RE: error when connecting to db | Fabio | 08/29/02 05:31 |
| error when connecting to db | christian fanzott | 08/02/02 04:40 |
| Material ? | Flavio Petit | 07/19/02 19:42 |
| just what I needed! | Richard | 07/11/02 22:50 |
| Newbie Stupid Question | Marsie | 07/11/02 09:04 |
| RE: how to migrate data from postgre to oracle | Denver G. Vender | 06/21/02 03:52 |
| how to migrate data from postgre to oracle | vinod | 06/13/02 14:34 |
| RE: libcrypto.so and libssl.so | Mike | 06/13/02 09:51 |
| Postgres Permissions | Mesonas | 06/13/02 07:07 |
| Using ODBC over LAN to Linux?postGreSQL | Andy Welch | 06/12/02 21:09 |
| examples won't compile on redhat6.2 | Joel Chen | 05/30/02 20:07 |
| Passwords | Gustavo Felisberto | 05/20/02 10:33 |
| Migration from IRIX to Linux | Jim | 05/06/02 10:41 |
| problemas al intalar postgres | Romeo Belleza | 05/02/02 17:41 |
| POSTGRES and HOST Language Interface | B.Vijayakumar | 04/08/02 00:49 |
| RE: Como desarrollo en WEb con Postgres | Raùl Giucich | 04/02/02 07:33 |
| Como desarrollo en WEb con Postgres | Postgres Web Enable | 03/26/02 13:31 |
| postgres user | Kristy | 03/17/02 10:49 |
| Postgres responding very slow on redhat7.0 | Mohit | 03/08/02 05:32 |
| RE: GUI windows interface for Postgres? | Hano de la Rouviere | 03/05/02 14:19 |
| RE: Compiling php with postgresql. | ângelo | 02/28/02 14:07 |
| libcrypto.so and libssl.so | Steve | 02/21/02 17:57 |
| RE: Setup linux Postgres but Windows 2k Client | Frank Seesink | 02/21/02 16:25 |
| RE: Postgres+Windows+PHP | Frank Seesink | 02/21/02 15:47 |
| How to select Date Data type from Postgres | Sunil B. Javeri | 02/15/02 07:06 |
| how to pg_dump | senthil kumar | 02/15/02 03:00 |
| how to php use mail server and mail facili | senthil kumar | 02/15/02 02:52 |
| RE: GUI windows interface for Postgres? | Ted Striker | 02/14/02 16:46 |
| returning newly created primary key | Brian | 02/14/02 01:39 |
| Setup linux Postgres but Windows 2k Client | Kok Leong | 02/07/02 21:10 |
| RE: The JDBC of Postgresql did not work! | Chris Carter | 02/07/02 00:48 |
| php + postgres | Souhir | 01/29/02 04:54 |
| About Postgres | Arthur | 01/24/02 06:16 |
| GUI windows interface for Postgres? | David Paper | 01/23/02 13:21 |
| copy file to email and check send message | Duong Tran | 01/18/02 21:32 |
| applet and postgres | aditya | 01/18/02 12:28 |
| Connecting | Frank | 01/04/02 06:20 |
| download postgresql | shailesh | 12/16/01 05:15 |
| RE: How can add information to a database | A K Maiti | 12/06/01 00:15 |
| windows INSTALLATION! | kamatis | 12/05/01 22:12 |
| What's phppgadmin? | dangyadang | 12/03/01 19:29 |
| Does Postgres support multiprocessing? | Sergio | 12/01/01 06:40 |
| postmaster -i problems | Justin | 11/30/01 15:17 |
| how to install php with java support | david | 11/29/01 01:48 |
| Postgres+Windows+PHP | Alexandro Laurent | 11/26/01 12:49 |
| RE: Interface for Windows to admin Postgres | Patrick Muldoon | 11/25/01 19:30 |
| RE: LINUX+POSTGRES+PHP | killerapp | 11/21/01 13:28 |
| RE: conversion from Ms-Access to postgresql | Miron | 11/16/01 18:11 |
| RE: Postgres | Julio Cesar Campos Borges | 11/14/01 11:57 |
| Question | Julio Cesar Campos Borges | 11/13/01 09:47 |
| LINUX+POSTGRES+PHP | nirmal | 11/08/01 07:04 |
| Any Good Books For Starters | Austin Joseph | 11/03/01 07:12 |
| RE: conversion from Ms-Access to postgresql | Jesper Hertel | 10/31/01 16:13 |
| Re: postmaster won't run | Anatharyll | 10/29/01 05:01 |
| error logging | ramesh | 10/19/01 08:20 |
| error on loging | ramesh | 10/19/01 07:50 |
| Re: postmaster won't run | Graham | 10/12/01 08:19 |
| Can't even install | Brent | 09/28/01 14:54 |
| Interface for Windows to admin Postgres | Mario | 09/26/01 18:06 |
| RE: The JDBC of Postgresql | D Tim Cummings | 09/10/01 20:38 |
| Recovering a deleted table | Ethan Galloway | 09/06/01 10:12 |
| RE: is there a table viewer for Postgres | Sherif Zaroubi | 09/06/01 07:50 |
| conversion from Ms-Access to postgresql | phani | 09/06/01 01:18 |
| RE: Postgres from PHP on RedHat 7.1 | Mike Fox | 09/05/01 07:26 |
| is there a table viewer for Postgres | Kiran | 08/25/01 10:51 |
| Postgres for windows EASY | John Schuhr | 08/14/01 12:02 |
| How to cancel a query running? | Point | 08/06/01 04:07 |
| RE: diff. between mySQL and postgreSQL | Ericson | 07/26/01 10:35 |
| Postgres from PHP on RedHat 7.1 | Lee Chua | 07/13/01 22:17 |
| how to format the time in query in postgres | kevin | 07/09/01 12:48 |
| RE: how to create a table in postgress? | Brendan Green | 07/04/01 15:25 |
| The JDBC of Postgresql | dangyadang | 07/03/01 04:24 |
| how to create a table in postgress? | NATARAJ | 06/19/01 23:58 |
| retrieving metadata from postgres | Jiby | 06/18/01 02:14 |
| RE: diff. between mySQL and postgreSQL | vher | 06/13/01 19:15 |
| Postgres | patrick | 06/08/01 15:32 |
| information | harpreet singh s | 06/05/01 21:16 |
| Compiling php with postgresql. | clark | 05/31/01 10:29 |
| How can add information to a database | Francisco | 04/27/01 12:24 |
| RE: great, kevin! now, about odbc? | Kevin | 04/27/01 06:51 |
| RE: Interesting, but... | Kevin | 04/25/01 22:43 |
| RE: great, kevin! now, about odbc? | Kevin | 04/25/01 22:39 |
| RE: problem starting postmaster | Kevin | 04/25/01 22:11 |
| RE: Excellent article | Kevin | 04/25/01 22:09 |
| RE: Postgres for windows, yes: | Kevin | 04/25/01 22:07 |
| great, kevin! now, about odbc? | Clayton Vernon | 04/23/01 18:56 |
| problem starting postmaster | Tim Caulder | 04/23/01 09:53 |
| Excellent article | Jeremy Pavier | 04/21/01 11:23 |
| RE: how to compile | Kevin | 04/21/01 10:52 |
| Postgres for windows, yes: | Matt | 04/21/01 09:26 |
| Interesting, but... | Sasa Markovic | 04/20/01 03:34 |
| how to compile | kasturi | 04/20/01 02:09 |
| RE: php = 4.0.1pl2 is needed ..??? | Kevin | 04/16/01 07:57 |
| RE: Thanks - well-aimed article | Kevin | 04/16/01 07:55 |
| Postgresql and SSL ??? | Maikel Verheijen | 04/13/01 09:57 |
| php = 4.0.1pl2 is needed ..??? | Casey Chambliss | 04/11/01 18:22 |
| Thanks - well-aimed article | Lee | 04/05/01 01:38 |
| RE: Running postgresql from a startup script | Michael Svazas | 04/04/01 20:29 |
| RE: Postgres for windows please | Rafael A. Borghi | 03/30/01 14:43 |
| pgsql-php | lehel | 03/29/01 05:11 |
| Running postgresql from a startup script | Eric | 03/27/01 23:20 |
| RE: What is it?? | Steve Brett | 03/21/01 11:12 |
| RE: Less GUI fluff.... More useful info | Brett Jones | 03/20/01 13:43 |
| RE: Postgres for windows please | jerry | 03/19/01 06:03 |
| RE: pgsql 7.1ß Benefits | Dirk | 03/18/01 10:08 |
| RE: pgsql 7.1ß Benefits | Kevin | 03/16/01 21:57 |
| RE: Less GUI fluff.... More useful info | Kevin | 03/16/01 21:53 |
| Less GUI fluff.... More useful info | Brett Jones | 03/15/01 22:16 |
| RE: pgsql 7.1ß Benefits | Brad Hubbard | 03/15/01 17:22 |
| RE: What is it?? | Andrew Dickinson | 03/15/01 16:17 |
| RE: What is it?? | bmpc | 03/15/01 15:56 |
| RE: Postgres for windows please | Phill Kenoyer | 03/15/01 14:07 |
| RE: What is it?? | Kevin Monroe | 03/15/01 11:53 |
| RE: Postgres for windows please | Simon Willison | 03/15/01 09:46 |
| What is it?? | ciaranmg | 03/15/01 06:38 |
| Postgres for windows please | Chris | 03/15/01 04:50 |
| pgsql 7.1ß Benefits | Tom Anderson | 03/14/01 23:29 |
|
If you are looking for help, please post on the appropriate forum here. Your questions will be answered much more quickly.
|