Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 8DAAB63242D for ; Fri, 9 Jul 2010 21:51:08 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 10459-03 for ; Sat, 10 Jul 2010 00:51:01 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-iw0-f174.google.com (mail-iw0-f174.google.com [209.85.214.174]) by mail.postgresql.org (Postfix) with ESMTP id 50D76633384 for ; Fri, 9 Jul 2010 21:51:01 -0300 (ADT) Received: by iwn7 with SMTP id 7so2791079iwn.19 for ; Fri, 09 Jul 2010 17:50:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:content-type; bh=DhR0aJMLdJP5hER0SXL6wZvnsPJ544uL6hTCKfrdtqI=; b=XNVYHj5OvLmazJMn6qLcbj7LWRLL3s24C/kyyWOwHebWWHJab3kt68oRsjr1KqgZ0C CvmadXWIAg+XpkRGG6Ono3bNDQaN3DH5S80ndCkZdEMnyTiRtpMLTa5ZtUNRpVDntqO6 onk77nx1GsFiJZ+MGiYl3YTpfNQ/UotSyqha4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=nlEjcJR+Qmytu564OysxKkG54QoPW0QxZwm2useiuq7Dawa7YzYnpjm4NMeiDQ3HsA BVslM/mGphJlXWeW+urzR3fEY6ZSfV36V5QXM4tldVT8kGfTqZv/p4dqR764iPmM3EdC l0NuVevTPkWyJq1e2QGugPDYlPNjKA6ibS0lw= MIME-Version: 1.0 Received: by 10.231.30.129 with SMTP id u1mr11280121ibc.63.1278723059446; Fri, 09 Jul 2010 17:50:59 -0700 (PDT) Received: by 10.231.30.131 with HTTP; Fri, 9 Jul 2010 17:50:59 -0700 (PDT) In-Reply-To: References: <1278349811-sup-6775@alvh.no-ip.org> Date: Fri, 9 Jul 2010 20:50:59 -0400 Message-ID: Subject: Re: [PATCH] Clarify that "psql -c" ignores psqlrc files From: Robert Haas To: pgsql-docs@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201007/88 X-Sequence-Number: 5744 On Tue, Jul 6, 2010 at 8:38 AM, Tim Landscheidt wrote: > Balkrishna Sharma wrote on -admin: > >> 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. > >> 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. >> [...] > > Patch attached to clarify the latter. Committed. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company