Faced pg_dump problem after release asp.net application

Question

User-1024418729 posted

I faced pg_dump problem after release asp.net application

I found the solution for pg_dump after releasing the asp.net application.

Need to set environment variable in code.

like System.Environment.SetEnvironmentVariable("PGPASSWORD", ViewState["password"].ToString());

Now you can execute pg_dump command it will work.

Regards,

Venugopal 

Answer 1

User470413944 posted

Hi, 

Thanks for share a sulotion for pg_dump after releasing the asp.net application.

For more convenience to others who will meet the same issue,  could you share more details?

I'm looking forward for your reply.

Answer 2

User-1024418729 posted

pg_dump used for taking database backup in PostgreSQL.  <o:p></o:p>

We need to set the environmentVariable for password other wise while working in development environmnet pg_dump gives database backup but after making msi file and deploy pg_dump exe will not work.<o:p></o:p>

Do you want full code for pg_dump?<o:p></o:p>