Mark Hagger <[email protected]> writes: > That script works fine for me and the output looks good, although unless I > missed something I had to modify it slightly to allow setting of the postgres > host,user,port and database name for the varioous psql commands, ie making > them things like:<BR> > <BR> > RESULTSET=`psql $pgargs -qtA -F ":" -R " > " -c "${QUERY}" $pgdb`<BR> > <BR> > where pgargs="-h hostname -U username -p port"<BR> > and pgdb="dbname"<BR>
Ah. The script assumes the use of the standard libpq environment variables to control things: - PGPORT - PGHOST - PGDATABASE - PGUSER That way, you can connect however you like without there ever being any need to touch the script. -- let name="cbbrowne" and tld="ca.afilias.info" in String.concat "@" [name;tld];; <http://dba2.int.libertyrms.com/> Christopher Browne (416) 673-4124 (land) "Bother," said Pooh, "Eeyore, ready two photon torpedoes and lock phasers on the Heffalump, Piglet, meet me in transporter room three" _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
