Looking at the following code in a sh file on one of our servers (I've
snipped nonrelavant stuff):
#!/bin/sh
OUT_TO=/home/postgres/tmp/webtrans.sql
#load the data to the destination DB
DST_DB=webbikedata
DST_IP=bikefriday.com
DST_USER=bikefriday
/usr/local/pgsql/bin/psql $DST_DB -U $DST_USER --host=$DST_IP < $OUT_TO
Am I understanding this properly if I say that:
running postgress on a local server
using webbikedata as the db
user is bikefriday
data is going to bikefriday.com
and postgress is importing the contents of $OUT_TO (in this case,
webtrans.sql)
webtrans.sql is 9.2mb... is the above a good way to deal with this? I'd
think uploading webtrans.sql to the remote box THEN having postgres deal
with it would be faster.
Matthew S. Jarvis
IT Manager
Bike Friday - "Performance that Packs."
www.bikefriday.com
541/687-0487 x140
[EMAIL PROTECTED]
_______________________________________________
EUGLUG mailing list
[email protected]
http://www.euglug.org/mailman/listinfo/euglug
