i'm will likely be working with a webhost that offers pgsql 7.3.3. will i run into problems if i develop using pgsql 7.4.5 and try to upload it to the 7.3.3 webhost?

i kind of think the answer is yes, but sometimes the "hail mary" connects... -lol-



---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!

I have an ssh server set up on my home linux box and can access my
postgresql server and database using puTTY from remote locations.

Is it possible to access the postgresql database on the home linux box
by way of ssh, and then use pgAccess in conjunction with ssh to run
queries, etc.

Thanks for your help.

Mike

P.S. -- heh, there appears to be some problem at sourceforge this
morning. The link to download the pgaccess.zip file is dead as of
10:20 am EST. Hmm, maybe I should move on to check out pgAdmin.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Mike wrote:
Yes, it is possible. The SSH protocol supports tunneling
of TCP connections. As far as I know, putty does not
support that feature, but OpenSSH does. As it seems you
have a Windows machine (not UNIX or Linux), the easiest
option is probably to install Cygwin which comes with
OpenSSH.

The follwoing command will establish such a tunnel:
ssh -L 5432:127.0.0.1:5432 your.host.com

Then you can use pgAccess (or other clients) to connect to
port 5432 on localhost, which is forwarded through the ssh
connection to port 5432 on your home machine. You can use
a different local port number if necessary. For the Post-
greSQL server, the connections appear to be originating
from localhost, so the same authentication applies.

Best regards
Oliver

--
Oliver Fromme, secnetix GmbH & Co KG, Oettingenstr. 2, 80538 München
Any opinions expressed in this message may be personal to the author
and may not necessarily reflect the opinions of secnetix in any way.

"Python tricks" is a tough one, cuz the language is so clean. E.g.,
C makes an art of confusing pointers with arrays and strings, which
leads to lotsa neat pointer tricks; APL mistakes everything for an
array, leading to neat one-liners; and Perl confuses everything
period, making each line a joyous adventure <wink>.
-- Tim Peters

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Putty does support forwarding arbitrary TCP connections - I use it all
the time (v 0.55).

Tim

Oliver Fromme wrote:


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

Oliver,

Thanks so much for your reply.
I appreciate the guidance.

I'm on my way to OpenSSH right now.

Take care,

Mike

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org