On Fri, 2005-01-14 at 10:19, Rodolfo J. Paiz wrote: > On Thu, 2005-01-13 at 18:59 -0500, Scot L. Harris wrote: > > Since pg_dumpall reads tables from all databases you will most likely > > have to connect as a database superuser in order to produce a complete > > dump. > > I think you would be correct. However, in this case I'm only trying to > dump *one* database with "pg_dump". The user owns the database, so > permissions should not be a problem. > > Note that the database does have a password on it (which I need to > change and don't yet know how, but that's another issue). When I use > psql to access the database manually, I am prompted for a password; but > pg_dump does not prompt me for the password, even if I add the "-W" > parameter to force it. Could this have something to do with the problem? That sounds like a good place to start. If you don't have permissions then it probably won't run. -- Scot L. Harris webid@xxxxxxxxxx A witty saying proves nothing, but saying something pointless gets people's attention.
