Hi Steven -
Thanks. Worked great. I assumed it would assume the dbname to be
import_dbms_db as import_dbms_user was granted admin privileges on it.
Also I do have import_dbms_user and import_dbms_db in my pg_hba.conf as:
local import_dbms_db import_dbms_user md5
I still need that - correct? And I will need to have another entry
specifying the ip addr of the machine to connect from if I am connecting
from a different machine?
So to connect from Python scripts (using psycopg2) do I need to specify the
database to connect to as well?
And if that python script is running from a different machine the ip addr of
that machine needs to be in the pg_hba.conf?
I ask as this is not connecting for me right now but I will check on the
psycopg forum as well.
Just wanted to confirm.
Thank you for your help.
Mono
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Trying-to-create-DB-user-to-import-some-data-tp5772568p5772622.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.