Horton

Re: [GENERAL] Optimizations for busy DB??

Karl DeBisschop <kdebisschop@spaceheater.infoplease.com>

View thread View on postgr.es
From: Karl DeBisschop <kdebisschop@spaceheater.infoplease.com>
To: signal@shreve.net
Cc: bmccoy@lan2wan.com, pgsql-general@postgreSQL.org
Date: 1999-05-13T16:58:34Z
Lists: pgsql-general 
> it works.  Make sure you preface these backend options with -o, since the 
> postmaster has its own options distinct from the backend.  Your complete 
> invocation might look like
> 
> postmaster -i -S -D/var/lib/pgsql -o -F -B 256 -S 1024

>From the man page for postmaster:

       -o backend_options
            The  postgres(1) options specified in backend_options
            are passed to all backend server processes started by
            this  postmaster.   If the option string contains any
            spaces, the entire string must be quoted.


So therefore:

postmaster -i -S -D/var/lib/pgsql -o '-F -S 1024'

-- 
Karl DeBisschop <kdebisschop@spaceheater.infoplease.com>
617.832.0332 (Fax: 617.956.2696)

Information Please - your source for FREE online reference
http://www.infoplease.com  - Your Ultimate Fact Finder
http://kids.infoplease.com - The Great Homework Helper