Using PgSqlDump to backup and restore a database

trentin · Post by **trentin** » Wed 10 Oct 2007 09:54

Version :2.55.27.0 professional
I’m would like to use pgsqldump to backup and restore an entire database. Here is a sample of the code I’m using

pgSqlDump.Mode = DumpMode.All
pgSqlDump.Backup()
Dim stream_d As StreamWriter = New StreamWriter(“c:\temp\backup4.sql”)
stream_d.WriteLine(pgSqlDump.DumpText)
stream_d.Close()

This method doesn’t re-create any schemes when restoring to a clean database

Am I missing something?

Thanks in advance

Alexey · Post by **Alexey** » Wed 10 Oct 2007 12:37

This functionality is not implemented, unfortunately.
We are going to add it in the future versions of 3.20 series.

Alexey · Post by **Alexey** » Mon 15 Oct 2007 08:53

We've implemented this in 3.20 version.
Look forward to the next build.

Alexey · Post by **Alexey** » Tue 30 Oct 2007 16:40

Please try new version of PostgreSQLDirect .NET 3.25.