Skip site navigation (1) Skip section navigation (2)

Re: psql, pg_dumpall, remote server questions...

From: <operationsengineer1(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: psql, pg_dumpall, remote server questions...
Date: 2005-09-13 15:15:41
Message-ID: 20050913151542.95390.qmail@web33307.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
John,

nice concise article!  i will give it a shot
(hopefully, this feature is enabled on my webhost).

i use pgadmin3 to admin my dev db.  if i use pgadmin3
to connect to the remote db, how can i be sure that
the following migration rule of thumb is followed:

1. always use the most up to date database's psql
program b/c it may have increased functionality.

tia...

--- John DeSoi <desoi(at)pgedit(dot)com> wrote:

> 
> On Sep 12, 2005, at 7:46 PM,
> <operationsengineer1(at)yahoo(dot)com>  
> <operationsengineer1(at)yahoo(dot)com> wrote:
> 
> > i think i log log into pgsql like so...
> >
> > psql dbname -h [full url to db on webhost here -
> is
> > this possible?] -U [username goes here] -p [port
> goes
> > here]
> >
> > will this work?  can i access my webhost in this
> > manner (putting url in as host option)?
> 
> 
> The -h parameter is not a URL, it is just a host
> name (or IP  
> address). Yes, you can run psql (and other
> PostgreSQL utilities) this  
> way, but it assumes the proper permissions have been
> setup in the  
> pg_hba.conf file to allow it (see
> http://www.postgresql.org/docs/8.0/ 
> interactive/client-authentication.html).
> 
> SSH access may be an alternative for you. I put a
> tip here about  
> setting up SSH tunneling for PostgreSQL:
> 
> http://pgedit.com/tip/postgresql/ssh_tunneling
> 
> 
> 
> John DeSoi, Ph.D.
> http://pgedit.com/
> Power Tools for PostgreSQL
> 
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
> 
>                http://archives.postgresql.org
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

In response to

Responses

pgsql-novice by date

Next:From: operationsengineer1Date: 2005-09-13 15:32:51
Subject: Re: Database Migration
Previous:From: Tom LaneDate: 2005-09-13 15:14:24
Subject: Re: server process was terminated by signal 11 postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group