Backup postgreSQL database through ODBC (windows, .NET)

Question

I'm trying to backup my database through ODBC with vb.net but can't find a way.
Some of many approaches:

        Try
            btCommand = New OdbcCommand("pg_dump '" + mydatabase + "' > 'all.sql'", mCon)
            'OR
            ' btCommand = New OdbcCommand("BACKUP DATABASE '" + mydatabase + "',  'all.sql'", mCon)
            btCommand.ExecuteNonQuery()
        Catch ex As Exception
            MsgBox(ex.Message, MsgBoxStyle.Critical + MsgBoxStyle.OkOnly)
        End Try

But no one works. Please advice on how to do this.

kgrittn · Accepted Answer · 2012-06-30 17:38:41Z

3

pg_dump is a command line executable, not a SQL command.

There are many different options for backing up a PostgreSQL database system. You should probably read through the documentation to see which one is the best fit for you.

answered Jun 30, 2012 at 17:38

kgrittn

19.8k4 gold badges41 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Wine Too Over a year ago

After reading, still can't find or don't understand usable way for backing up through odbc command. Any closer recommendation?

kgrittn Over a year ago

You could try to emulate what pg_dump does by running a lot COPY statements and such, but why not use one of the tools already written and available? Surely you have some way to access the database besides ODBC?

Wine Too Over a year ago

Yes, I can access (and backup) my database by few ways. I can also shell from my program to pg_dump.exe. But I am just curious if here becomes some totally programatic way covered by ODBC. Never mind if not. Thanks for helping!

Collectives™ on Stack Overflow

Backup postgreSQL database through ODBC (windows, .NET)

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related