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.
--- John DeSoi <desoi(at)pgedit(dot)com> wrote:
> On Sep 12, 2005, at 7:46 PM,
> <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 -
> > this possible?] -U [username goes here] -p [port
> > 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
> SSH access may be an alternative for you. I put a
> tip here about
> setting up SSH tunneling for PostgreSQL:
> John DeSoi, Ph.D.
> Power Tools for PostgreSQL
> ---------------------------(end of
> TIP 4: Have you searched our list archives?
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
In response to
pgsql-novice by date
|Next:||From: operationsengineer1||Date: 2005-09-13 15:32:51|
|Subject: Re: Database Migration|
|Previous:||From: Tom Lane||Date: 2005-09-13 15:14:24|
|Subject: Re: server process was terminated by signal 11 postgres |