0
votes
1answer
19 views

Is there a tool to manipulate pg_hba.conf programmatically (if not what comes closest)? [closed]

I'm looking for anything above the level of programmatic file manipulation, a command or a python library. There seems to be no alternative to editing the file (assuming that ...
0
votes
1answer
5k views

How to reset the postgres super user password on mac os x

I installed postgres on my mac running 10.6.8 and I would like to reset the password for the postgres user (I believe this is the super user password) and then restart it. All the directions I found ...
0
votes
1answer
1k views

Why pg_dump 'trust' authentication fails under root and works under another user?

I have pg_dump command in cron that accesses PostgreSQL under user postgres and does not provide a password. pg_dump --username=postgres ... I have set in pg_hba.conf that user postgres should be ...