larry price wrote:
You're running the postgres client (psql) locally
using the database webbikedata as user bikefriday on host bikefriday.com
and you are feeding the file webtrans.sql to the client.
speed probably isn't an issue in most cases, copying the file in bulk
and then executing it's contents on the remote server is not faster
than copying it line by line and executing it as it arrives.
what you do need to be concerned about is security, by default
connections to the database are NOT ENCRYPTED.
take a look at pg_hba.conf and make sure that the connection type is
set to ssl, and that you are requiring authentication before access.
thanks Larry.... so it looks like I had it right....
the reason I'm even bothering with this is that something is breaking -
once last Thurs and again Sat morning or so....
We have a cron job that dumps portions of our postgres stuff to a system
file then that file gets sent up to the website. It controls some of the
menus and the details of bike designs.
Anyhoo, last Thurs for the first time since I've been here (about 5 mo)
that data transfer didn't complete.
For better or worse the update process uses a DELETE then COPY sequence
to update the tables on the site. The DELETE takes place, table is
updated, next DELETE, next table etc.... sometimes the process isn't
being completed as though something is timing out, so I was looking to
a) speed up the whole process and b) park at least a snapshot of the
data up on the server so I can just import it in and get the site back
to functionality.
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
