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@xxxxxxxxxxxxxxxx devrim.gunduz@xxxxxxxxxxxx devrimg@xxxxxx Web : http://devrim.oper.metu.edu.tr ------------------------------------------------------------------
