Skip site navigation (1) Skip section navigation (2)

Re: connect to postgres from shell scripts

From: Devrim GUNDUZ <devrim(at)gunduz(dot)org>
To: Hemapriya <priyam_1121(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: connect to postgres from shell scripts
Date: 2005-08-22 17:34:54
Message-ID: Pine.LNX.4.63.0508222031520.30926@emo.org.tr (view raw or flat)
Thread:
Lists: pgsql-admin
  This message is in MIME format.  The first part should be readable text,
  while the remaining parts are likely unreadable without MIME-aware tools.

--8323328-932793750-1124732087=:30926
Content-Type: TEXT/PLAIN; CHARSET=iso-8859-9; FORMAT=flowed
Content-Transfer-Encoding: 8BIT
Content-ID: <Pine(dot)LNX(dot)4(dot)63(dot)0508222034501(dot)30926(at)emo(dot)org(dot)tr>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

On Mon, 22 Aug 2005, Hemapriya wrote:

> I would like to know how to connect to postgres from
> shell scripts using a password protected user.
>
> Is there a way to embed the password in psql login.
> It keeps prompting for the passwords.

psql checks for PGUSER, PGPASSWORD, PGHOST, PGPORT, PGDATABASE and some 
other environmental variables. Export relevant values to the parameters.

http://www.postgresql.org/docs/8.0/static/libpq-envars.html

Also there's a .pgpass file thing:

http://www.postgresql.org/docs/8.0/static/libpq-pgpass.html

Regards,
- --
Devrim GUNDUZ
Kivi Bili┼čim Teknolojileri - http://www.kivi.com.tr
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
                      http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFDCgzAtl86P3SPfQ4RAo5PAJ9y9Pm7ii8z50ZrSB7Bws1qhQU++gCfUepu
C3ErI3WBVLPIJ8ShVPE29Dk=
=dCI+
-----END PGP SIGNATURE-----
--8323328-932793750-1124732087=:30926--

In response to

Responses

pgsql-admin by date

Next:From: jose fuenmayorDate: 2005-08-22 17:37:34
Subject: Indexes (Disk space)
Previous:From: Bruce MomjianDate: 2005-08-22 16:24:17
Subject: Re: sleep?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group