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
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 |