Using PgSqlDump to backup and restore a database

Using PgSqlDump to backup and restore a database

Postby 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
trentin
 
Posts: 5
Joined: Fri 25 Aug 2006 07:17

Postby 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
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Alexey » Mon 15 Oct 2007 08:53

We've implemented this in 3.20 version.
Look forward to the next build.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Alexey » Tue 30 Oct 2007 16:40

Please try new version of PostgreSQLDirect .NET 3.25.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for PostgreSQL