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

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