From: Bruce Momjian <bruce@momjian.us>
Message-Id: <201007061448.o66EmmF10095@momjian.us>
Subject: Re: Change to 'timing on' globally
In-Reply-To: <BAY149-w7B72F20DF56F3177081E8F0B10@phx.gbl>
To: Balkrishna Sharma <b_ki@hotmail.com>
Date: Tue, 6 Jul 2010 10:48:48 -0400 (EDT)
CC: alvherre@commandprompt.com, pgsql-admin@postgresql.org
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset="US-ASCII"

Balkrishna Sharma wrote:
> 
> Thanks. If I want to do at system-wide level, where do I store the
> psqlrc file (assuming I want to change the timing behavior system-wide)?

> (CentOS 5, Postgres 8.4)
> $ ./pg_config --sysconfdir/opt/PostgreSQL/8.4/etc/postgresql

> But I don't have /opt/PostgreSQL/8.4/etc/postgresql directory. Just
> creating the directory and putting a psqlrc file over there does not
> seem to work.

I just tested it here on Ubuntu and it worked:

	$ sudo mkdir etc
	$ sudo mkdir etc/postgresql
	$ cd etc/postgresql/
	$ sudo vi psqlrc
	# add \echo test
	$ pwd
	/opt/PostgreSQL/8.4/etc/postgresql
	$ ../../bin/psql -U postgres postgres
-->	test
	psql (8.4.2)
	Type "help" for help.
	
	postgres=# 

> On a side-note, I observered that timing value in ~/.psqlrc was
> ignored by psql -c "..." command but not by echo "...."|psqlThought
> it was strange.

Yeah, that is odd.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + None of us is going to be here forever. +