Dick Davies <[EMAIL PROTECTED]> writes:
> I notice pg_dump does'nt have a '-P' flag to provide a password,
~/.pgpass is the preferred solution.
http://www.postgresql.org/docs/8.0/static/libpq-pgpass.html
regards, tom lane
---(end of broadcast)-
I notice pg_dump does'nt have a '-P' flag to provide a password, so I assume
you generally use it to pull data through a socket.
I need to run it remotely (to dump a live db and clone its structure to a test
db for unit testing), has anyone got a way to do this?
I've tried 'echo pass | pg_dump -h
