PostgreSQL Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me

The Shed is going Social! Join us on FaceBook and Twitter and chime in on the conversation.

Go Back   Dev Shed Forums > Databases > PostgreSQL Help
Reload this Page

Configure database to use with PUTTY


Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old March 7th, 2012, 06:20 PM
eponcedeleon eponcedeleon is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: May 2009
Posts: 19 eponcedeleon User rank is Private First Class (20 - 50 Reputation Level)eponcedeleon User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 3 h 25 m 3 sec
Reputation Power: 0
Configure database to use with PUTTY
I have my database setup and I want to access it and run commands via putty.

the database is not local and I´ve been trying differente configurations but I always get the Network Error in putty. What do I need to do to login to a remote server and have access to my database.

thank you..
Reply With Quote
  #2  
Old March 7th, 2012, 11:53 PM
E-Oreo's Avatar
E-Oreo E-Oreo is offline
Lost in code
Click here for more information.
  
Join Date: Dec 2004
Posts: 7,947 E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)  Folding Points: 945 Folding Title: Novice Folder
Time spent in forums: 2 Months 10 h 55 m 23 sec
Reputation Power: 7053
putty is not a postgresql client, you cannot connect directly to a postgresql server using it.

If you have SSH access to the server then you can connect to the server using putty and either use the postgresql client that is (probably) installed on the server, or use a local postgresql client and tunnel over the SSH connection.

If your postgresql server is accessible remotely then you can use a local postgresql client to connect directly to it.
__________________
PHP FAQ
How to program a basic, secure login system using PHP
Connect with me on LinkedIn


Quote:
Originally Posted by Spad
Ah USB, the only rectangular connector where you have to make 3 attempts before you get it the right way around
Reply With Quote
  #3  
Old March 8th, 2012, 08:42 AM
eponcedeleon eponcedeleon is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: May 2009
Posts: 19 eponcedeleon User rank is Private First Class (20 - 50 Reputation Level)eponcedeleon User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 3 h 25 m 3 sec
Reputation Power: 0
my question was more towards, now to I accomplish that!
Reply With Quote
  #4  
Old March 8th, 2012, 08:46 AM
shammat shammat is offline
Contributing User
Dev Shed Frequenter (2500 - 2999 posts)
  
Join Date: Oct 2003
Location: Germany
Posts: 2,685 shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 1 Month 3 Weeks 3 Days 19 h 59 m 5 sec
Reputation Power: 284
Quote:
Originally Posted by eponcedeleon
my question was more towards, now to I accomplish that!
Accomplish what?
Reply With Quote
  #5  
Old March 8th, 2012, 09:05 AM
eponcedeleon eponcedeleon is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: May 2009
Posts: 19 eponcedeleon User rank is Private First Class (20 - 50 Reputation Level)eponcedeleon User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 3 h 25 m 3 sec
Reputation Power: 0
Quote:
Originally Posted by shammat
Accomplish what?


I can access my DB with pgAdmin software but cannot configure putty to access it, I want to know how to configure putty to access my database
Reply With Quote
  #6  
Old March 8th, 2012, 09:48 AM
shammat shammat is offline
Contributing User
Dev Shed Frequenter (2500 - 2999 posts)
  
Join Date: Oct 2003
Location: Germany
Posts: 2,685 shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level)shammat User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 1 Month 3 Weeks 3 Days 19 h 59 m 5 sec
Reputation Power: 284
Quote:
Originally Posted by eponcedeleon
I can access my DB with pgAdmin software but cannot configure putty to access it, I want to know how to configure putty to access my database
Again: putty does not "access" the database.

It's a tool to open a commandline to a remote computer. From that commandline you can e.g. start psql if that is installed on the remove computer.
Reply With Quote
  #7  
Old March 8th, 2012, 05:15 PM
E-Oreo's Avatar
E-Oreo E-Oreo is offline
Lost in code
Click here for more information.
  
Join Date: Dec 2004
Posts: 7,947 E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)E-Oreo User rank is General 91st Grade (Above 100000 Reputation Level)  Folding Points: 945 Folding Title: Novice Folder
Time spent in forums: 2 Months 10 h 55 m 23 sec
Reputation Power: 7053
Do you have SSH access to the server?
Reply With Quote
Reply

Viewing: Dev Shed Forums > Databases > PostgreSQL Help > Configure database to use with PUTTY

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates



Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.

© 2003-2013 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap