On 03/07/2007 13:47, Stefan Zweig wrote:
> i know already that there is a way to connect to a remote postgres
> using psql with the options --host 123.123.123.1 --port 5432
> --username --password
You can specify the username on the command line, but not the password:
the --password option only ensures the psql will prompt for the password.
The usual thing, as I understand it, is to use a .pgpass file: have a
look at the docs, here:
http://www.postgresql.org/docs/8.2/static/libpq-pgpass.html
> very large *.sql files to import) and more convenient to do the
> import directly via psql instead of using jdbc/odbc.
Also, if the files you're importing were created by pg_dump, they'll
contain various "backslash" commands that are psql-specific, so you
*have* to re-import them via psql.
HTH,
Ray.
---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------