Frequently Asked Questions (FAQ) for PostgreSQL

Last updated:Tue Sep4 01:14:28 EDT 2001

Last updated:Thu Sep6 20:51:03 EDT 2001

Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)

You need to increase the postmaster's limit on how many concurrent

backend processes it can start.

In PostgreSQL 6.5 and up, the default limit is 32 processes. You can

increase it by restarting the postmaster with a suitable -N value.

With the default configuration you can set -N as large as 1024. If you

need more, increase MAXBACKENDS in include/pg_config.h and rebuild.

You can set the default value of -N at configuration time, if you

like, using configure's --with-maxbackends switch.

The default limit is 32 processes. You can increase it by restarting

the postmaster with a suitable -N value or modifying postgresql.conf.

Note that if you make -N larger than 32, you must also increase -B

beyond its default of 64; -B must be at least twice -N, and probably

};

staticchar*backslash_commands[]= {

"\\connect","\\copy","\\d","\\di","\\di","\\ds","\\dS","\\dv",

"\\da","\\df","\\do","\\dt","\\e","\\echo","\\encoding",

"\\g","\\h","\\i","\\l",

"\\connect","\\copy","\\d","\\da","\\dd","\\df","\\di",

"\\dl","\\do","\\dp","\\ds","\\dS","\\dt","\\dT","\\dv",

"\\e","\\echo",

"\\encoding","\\g","\\h","\\i","\\l",

"\\lo_import","\\lo_export","\\lo_list","\\lo_unlink",

"\\o","\\p","\\pset","\\q","\\qecho","\\r","\\set","\\t","\\unset",

"\\x","\\w","\\z","\\!",NULL