Execute command in ubuntu terminal from an aspnet application

Question

I have a command to drop postgresql database:

sudo -u myuser psql -c "drop database my_databse"

How I could execute this sentence from an aspnet website(c#)? Is it possible to execute without introducing a password?

This app is running in another server: I have a windows server running aspnet website. I have an ubuntu server running postgresql database.

this might help : http://codeabout.wordpress.com/2012/03/08/working-with-postgres-database-and-c-by-using-npgsql-and-reflection/ — Krunal Patil, Jun 16 '14 at 09:32
I am using npgsql, but I want directly drop the databse from command in the server. THanks — Za7pi, Jun 16 '14 at 09:34

score 1 · Answer 1 · answered Jun 16 '14 at 11:47

1

drop database my_databse is an SQL command. You can run it directly from nPgSQL. There is no need to run psql, and no point doing so.

If your usual user account doesn't have the access rights for it, you can make a new temporary connection in nPgSQL just for that command. You might find SET SESSION AUTHORIZATION or SET ROLE useful, too.

answered Jun 16 '14 at 11:47

Craig Ringer

307,061
76
688
778

But, it is giving me problems: It is giving me some errors: there are open connections – Za7pi Jun 16 '14 at 15:17
I tried it too, but If I do this, It disconnect me. – Za7pi Jun 16 '14 at 16:08
Did you add an exception for your own connection? If not, then yes, it'll disconnect you. – Craig Ringer Jun 16 '14 at 17:26
Yes, I have exception added – Za7pi Jun 18 '14 at 11:53
I think you'll need to show the query then, because it should work, and always has in the past... – Craig Ringer Jun 18 '14 at 13:02

Execute command in ubuntu terminal from an aspnet application

1 Answers1