Hi,
On Thu, 14 Feb 2002, Laurent Patureau wrote:
>
> Hi,
>
> Anybody know a way to specifie a user when pg_dump ?
> I do a script with a system command "pg_dump dbname > out.sql" but my
> script run under user apache and apache is not granted to do it .
pg_dump dbname -u > out.sql
This is the syntax. However, if you want to do it in a shell script
(maybe in cron), use expect.
I have posted an example about a month ago. Please check the archives for
that.
Regards
Devrim
> rgds,
> Laurent.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
--
Devrim GUNDUZ
devrim@oper.metu.edu.tr
devrim.gunduz@linux.org.tr
devrimg@tr.net
Web : http://devrim.oper.metu.edu.tr
------------------------------------------------------------------