jody <jody.xha@gmail.com> writes:
> I have a problem when creating a db dump from a php script in a html page.
> This used to work in previous PostgreSQL versions, but now (v, 9.1.5)
> it fails, and i have no idea why.
It might help to look in the postgres server's log to see if there are
any related messages. Based on the described symptoms I'm guessing a
user authentication failure, possibly related to the fact that the
dump is running as whatever-user-owns-the-webserver-process rather than
yourself. If it worked before, that probably means you had the older
server configured differently for authentication --- see pg_hba.conf
and related files.
Note in particular that "peer" and "ident" auth modes don't care about
password files, and instead directly check which OS user the client
program is running as ...
regards, tom lane