SEO

#1 (**permalink**) 04-09-2008, 07:13 AM

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

Frank

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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

#2 (**permalink**) 04-09-2008, 07:13 AM

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

#3 (**permalink**) 04-09-2008, 07:13 AM

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/

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

How to check options PostgreSQL was started with