PHP with PostgreSQL - exec format

Author

exec format

enzo venegas palacios

2005-09-28, 8:25 pm

hi, I am trying to execute a line of commands of DOS and need to put ""
inside the sequence, for the format of the instruction exec it does not
leave me, someone can solve like this
Ej:
Exec (" C:\Program Files\PostgreSQL\8.0.0-rc2\bin \> pg_dump -i - or - or
postgres -Fc-b-v-f c:\path\res " .$name. ".backup name_db ");

Here the variable is supposed q happens well, but the correct instruction is:

Exec (" C:\Program Files\PostgreSQL\8.0.0-rc2\bin \> pg_dump-i - or - or
postsgres -Fc-b-v-f "c:\path\res" .$name. ".backup" name_db");

And here it throws the mistake to me, it q am trying to do it is to execute
pg_dump from php, any idea in the matter, thank you
enzo
---------------------------------------------------------
Juega y llévate una PS2 two: http://juegos.ya.com/consolas_y_pc/...ncurso-ps2.html
Ya.com ADSL 2MB + Llamadas 24 horas: desde 26,95 €/mes + IVA. Navega y habla de forma ilimitada. Sin compromiso de permanencia. http://acceso.ya.com/ADSLllamadas/2mb

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Christopher Kings-Lynne

2005-09-29, 7:25 am

You have to set the PGPASSWORD environmental variable using setenv() or
whatever it's called in PHP before calling exec().

Check the phpPgAdmin datadump.php file to see how it's done.

Chris

enzo venegas palacios wrote:
> hi, I am trying to execute a line of commands of DOS and need to put ""
> inside the sequence, for the format of the instruction exec it does not
> leave me, someone can solve like this
> Ej:
> Exec (" C:\Program Files\PostgreSQL\8.0.0-rc2\bin \> pg_dump -i - or - or
> postgres -Fc-b-v-f c:\path\res " .$name. ".backup name_db ");
>
> Here the variable is supposed q happens well, but the correct instruction is:
>
> Exec (" C:\Program Files\PostgreSQL\8.0.0-rc2\bin \> pg_dump-i - or - or
> postsgres -Fc-b-v-f "c:\path\res" .$name. ".backup" name_db");
>
> And here it throws the mistake to me, it q am trying to do it is to execute
> pg_dump from php, any idea in the matter, thank you
> enzo
> ---------------------------------------------------------
> Juega y llévate una PS2 two: http://juegos.ya.com/consolas_y_pc/...ncurso-ps2.html
> Ya.com ADSL 2MB + Llamadas 24 horas: desde 26,95 €/mes + IVA. Navega y habla de forma ilimitada. Sin compromiso de permanencia. http://acceso.ya.com/ADSLllamadas/2mb
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Sponsored Links