pgtcl way of specifying a user

Patrick Nelson wrote:

I have cron and init scripts that call my PostgreSQL db for their data.
This worked fine until I moved the sql server off the system. Then I had to
specify the actual host and user in the case of pg_dumpall called from a tcl
script. Cron wasn't grabbing the proper variables of PGHOST PGUSER I guess.
No problem, just added them to the command of pg_dumpall and the script
works fine

I have another script that uses libpgtcl and this script runs as part of
init level 3 or level 5. It also don't connect to the database by utilizing
any variables in a .bash_profile config file. I can not figure out how to
make the connection. I used:

pg_connect $PGDBName -host $PGHostName

Try pg_connect $PGDBName -host $PGHostName -username Bob -password Secret

regards,

nicolas boretos

Nicolas Boretos wrote:
----------------->>>>
Try pg_connect $PGDBName -host $PGHostName -username Bob -password Secret
----------------->>>>

-username and -password are not options of pg_connect and result in an
error. That's the problem there seems to be no way of specifying a specific
user.

Patrick Nelson <pnelson@neatech.com> writes:

-username and -password are not options of pg_connect and result in an
error. That's the problem there seems to be no way of specifying a specific
user.

Use the pg_connect -conninfo style, -conninfo "user=foo dbname=bar ..."
The other syntax is obsolete and not really being supported.

regards, tom lane

Tom Lane wrote:
----------------->>>>
Use the pg_connect -conninfo style, -conninfo "user=foo dbname=bar ..."
The other syntax is obsolete and not really being supported.
----------------->>>>

The following solved my problem:

pg_connect -conninfo "host=$PGHostName user=$PGUserName dbname=$PGDBName"