Re: db dump from php - Mailing list pgsql-novice

From Tom Lane
Subject Re: db dump from php
Date
Msg-id 7056.1357508043@sss.pgh.pa.us
Whole thread Raw
In response to db dump from php  (jody <jody.xha@gmail.com>)
List pgsql-novice
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


pgsql-novice by date:

Previous
From: jody
Date:
Subject: db dump from php
Next
From: Christian Hammers
Date:
Subject: Re: db dump from php