Page 1 of 1

Using PgSqlDump to backup and restore a database

Posted: Wed 10 Oct 2007 09:54
by trentin
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

Posted: Wed 10 Oct 2007 12:37
by Alexey
This functionality is not implemented, unfortunately.
We are going to add it in the future versions of 3.20 series.

Posted: Mon 15 Oct 2007 08:53
by Alexey
We've implemented this in 3.20 version.
Look forward to the next build.

Posted: Tue 30 Oct 2007 16:40
by Alexey
Please try new version of PostgreSQLDirect .NET 3.25.