If you run it on the same server, with a user who has permission to
access the db using ident (e.g. user "postgres"),
i.e. you have a pg_hba.conf entry like:
local allpostgres ident sameuser
Then pg_dump and pg_dumpall will not require a password.
Alternatively, you can creat
Title: Nachricht
Hm,
depends on how the security settings of the database are set. For local users
you could set in the pg_hba.conf ident as authentication method. Then they won't
need a password anymore.
See
the pg_hba.conf documentation for more infos.
Another way could be to execute the d
Hi,is there a way to backup the database thanks a command script, without postgresql requesting the user password ?thanks a lot,Alain