pgtcl way of specifying a user

From: Patrick Nelson <pnelson(at)neatech(dot)com>
To: "PostgreSQL List (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: pgtcl way of specifying a user
Date: 2003-02-13 22:22:48
Message-ID: 4165C48DE9A0D211B6400800095C585F172F4C@WASHINGTON
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

and this works, but I don't know what user it will use as part of init and I
can not figure out how to define a user. Can anyone shad some light on my
problems. IWAI

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2003-02-13 22:28:40 Re: index scan with index cond on first column doesn't
Previous Message Greg Stark 2003-02-13 22:10:17 Re: index scan with index cond on first column doesn't recognize sort order of second column