Andre, et al -- ...and then Andre Dubuc said... % % Soon, I will be transferring my site to go on-line with my IP. Since I've % never managed anything off-site, I have a very fundamental question: % % What are the usual procedures with respect to maintaining a site, that is, % accessing the PostgreSQL database for corrections, deletions, etc?
While I'm the type who uses ssh to connect and does work on the server, not everyone is. I know how I'd take care of the problem, though :-) Since you're not on the server, I'd either write some management code as has been suggested (be sure to encrypt your connection, strongly authenticate who is making the changes, and so on) or just let the database handle it. I haven't used PostgreSQL but I have to imagine it will let you connect to a remote server (hey, MySQL will), so just fire up your DB client on your local machine, connect to the remote DB, and make your changes; the only security you need is an ssh [forwarding?] port for the DB (or use a VPN tunnel). You *definitely* shouldn't have to transfer entire copies of your DB via ftp; that's just way too painful. HTH & HAND :-D -- David T-G * It's easier to fight for one's principles (play) [EMAIL PROTECTED] * than to live up to them. -- fortune cookie (work) [EMAIL PROTECTED] http://www.justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg!
msg76393/pgp00000.pgp
Description: PGP signature
