Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Does it complain about something? Check the logs.</p> <p>If the only thing you changed was the shared_buffers, then you might have hit the limit of the OS, and in that case it will tell you in the log.</p> <p>If that is the case, then have a look at <a href="http://www.postgresql.org/docs/8.3/interactive/kernel-resources.html#SYSVIPC" rel="nofollow noreferrer">http://www.postgresql.org/docs/8.3/interactive/kernel-resources.html#SYSVIPC</a> how to set it to a correct value.</p> <p><em>Update:</em></p> <p>A lot of other parameters are depending on the <code>shared_buffers</code>, but not the opposite, so there is nothing else that you would have to change as well. However, only because the server have 32GB of RAM doesn't mean that the OS allow you to use it. You have to make sure that the output of <code>sysctl -a | grep kernel.shmmax</code> is higher than the value of what you have set the <code>shared_buffers</code> to.</p> <p>Does it stop working no matter how little you change the value, or do it work if you just add, say 1MB?</p> <p>Also, as John is saying, the support for named values were introduced in 8.2, so if you are using a version before that you have to specify it in blocks instead of memory.</p> <p>Another thing. It might be quite picky about the semantics. So, make sure that you have written <strong>MB</strong> and not Mb or mb.</p> <p>It is however strange that you only get an empty log file, try to start the process manually either by doing as John is suggesting, or the easier one <code>pg_ctl start</code> as the user postgres (as long as the silent mode is not enabled, it will still output things to your terminal)</p>
    singulars
    1. This table or related slice is empty.
    1. POpostgresql doesn't starts after editing the postgresql.conf
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJimmy Stenke
    1. USJimmy Stenke
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POpostgresql doesn't starts after editing the postgresql.conf
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COI've added that the log file is empty. I just get the message that "server starting" and nothing happens. The OS has 32Gb of RAM and enlarging the shared_buffers by number of Megas leads to that problem. Should I change any other setting that should suit the change in the shared_buffers?
      singulars
      1. PO
      1. USjutky
    2. COI've commented some things in the John's post. About the sysctl - I probably don't have permissions to run it I get "bash: sysctl: command not found". I don't have a root on the machine, so I'll talk to the system group about it. Thanks for the advices.
      singulars
      1. PO
      1. USjutky
    3. COhmm, I am not certain if you still can run it unless you are root, but it should be possible (you can just not set the values). The application should reside in either /sbin or /usr/sbin, so try adding those paths (like /sbin/sysctl -a). Or you can query the /proc directly by doing `cat /proc/sys/kernel/shmmax`
      singulars
      1. PO
      1. USJimmy Stenke
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload