Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 817FA632EFC for ; Mon, 5 Jul 2010 16:40:57 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 33528-02 for ; Mon, 5 Jul 2010 19:40:49 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from bay0-omc1-s19.bay0.hotmail.com (bay0-omc1-s19.bay0.hotmail.com [65.54.190.30]) by mail.postgresql.org (Postfix) with ESMTP id 6C9C363274F for ; Mon, 5 Jul 2010 16:40:49 -0300 (ADT) Received: from BAY149-W7 ([65.54.190.61]) by bay0-omc1-s19.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.4675); Mon, 5 Jul 2010 12:40:47 -0700 Message-ID: Content-Type: multipart/alternative; boundary="_aab748b3-5cf0-42bd-8aa9-5ad86b924587_" X-Originating-IP: [69.243.212.79] From: Balkrishna Sharma To: CC: Subject: Re: Change to 'timing on' globally Date: Mon, 5 Jul 2010 15:40:47 -0400 Importance: Normal In-Reply-To: <1278349811-sup-6775@alvh.no-ip.org> References: , <1278349811-sup-6775@alvh.no-ip.org> MIME-Version: 1.0 X-OriginalArrivalTime: 05 Jul 2010 19:40:47.0370 (UTC) FILETIME=[F72C7EA0:01CB1C79] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.909 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201007/11 X-Sequence-Number: 35030 --_aab748b3-5cf0-42bd-8aa9-5ad86b924587_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thanks. If I want to do at system-wide level=2C where do I store the psqlrc= file (assuming I want to change the timing behavior system-wide)? (CentOS 5=2C 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 creatin= g the directory and putting a psqlrc file over there does not seem to work. On a side-note=2C I observered that timing value in ~/.psqlrc was ignored b= y psql -c "..." command but not by echo "...."|psqlThought it was strange. > CC: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] Change to 'timing on' globally > From: alvherre@commandprompt.com > To: b_ki@hotmail.com > Date: Mon=2C 5 Jul 2010 13:10:30 -0400 >=20 > Excerpts from Balkrishna Sharma's message of lun jul 05 13:00:44 -0400 20= 10: > >=20 > > I know that we can toggle the timing at session level by using \timing = in psql. > > Is there a way to set the default to 'timing on' globally across the da= tabase or atleast across all psql statements by a specificied user ? >=20 > .psqlrc ? >=20 > --=20 > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin =20 _________________________________________________________________ Hotmail has tools for the New Busy. Search=2C chat and e-mail from your inb= ox. http://www.windowslive.com/campaign/thenewbusy?ocid=3DPID28326::T:WLMTAGL:O= N:WL:en-US:WM_HMP:042010_1= --_aab748b3-5cf0-42bd-8aa9-5ad86b924587_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thanks. If I want to do at system-wide level=2C where do I store the psqlrc= file (assuming I want to change the timing behavior system-wide)?

=
(CentOS 5=2C Postgres 8.4)

$ ./pg_config= --sysconfdir
/opt/PostgreSQL/8.4/etc/postgresql

But I don't have =3B/opt/PostgreSQL/8.4/etc/postgresql directo= ry. Just creating the directory and putting a psqlrc file over there does n= ot seem to work.


On a side-note=2C = I observered that timing value in ~/.psqlrc was ignored by psql -c "..." co= mmand but not by echo "...."|psql
Thought it was strange.




>=3B CC: pgsql-admin@postg= resql.org
>=3B Subject: Re: [ADMIN] Change to 'timing on' globally
= >=3B From: alvherre@commandprompt.com
>=3B To: b_ki@hotmail.com
&= gt=3B Date: Mon=2C 5 Jul 2010 13:10:30 -0400
>=3B
>=3B Excerpts = from Balkrishna Sharma's message of lun jul 05 13:00:44 -0400 2010:
>= =3B >=3B
>=3B >=3B I know that we can toggle the timing at sessio= n level by using \timing in psql.
>=3B >=3B Is there a way to set th= e default to 'timing on' globally across the database or atleast across all= psql statements by a specificied user ?
>=3B
>=3B .psqlrc ?
= >=3B
>=3B --
>=3B Sent via pgsql-admin mailing list (pgsql-ad= min@postgresql.org)
>=3B To make changes to your subscription:
>= =3B http://www.postgresql.org/mailpref/pgsql-admin
=
Hotmail has tools for the New Busy. Search=2C chat and e-mai= l from your inbox. L= earn more. = --_aab748b3-5cf0-42bd-8aa9-5ad86b924587_--