Обсуждение: How to check options PostgreSQL was started with

How do you check the options a PosgreSQL service was started with?

Frank


----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

On Wed, Nov 30, 2005 at 06:18:01PM +0000, frank church wrote:
>
> How do you check the options a PosgreSQL service was started with?
>
> Frank

Easiest way is to do show all; from psql.

--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

frank church <pgsql@adontendev.net> writes:

> How do you check the options a PosgreSQL service was started with?

If you're wanting to know if postmaster was started with any command
line args, such as an admin might do on a ad hoc basis from pg_ctl
etc;

cat $PGDATA/postmaster.opts

If you do a simple 'pg_ctl start' all you'll get is the path to the
postmaster or postgres executable.  OTOH, 'pg_ctl -o-F start' and the
path plus your -F option will show up there.

HTH

--
-------------------------------------------------------------------------------
Jerry Sievers   305 854-3001 (home)     WWW ECommerce Consultant
                305 321-1144 (mobile    http://www.JerrySievers.com/