I was using the servoy 5.2.9 . I was having a database back up files of version postgres 9.0 and postgres 8.4 . Both the database files could not be restored because of the higher version of the database files . So what i did is i installed a fresh version of postgres 9.1 . I tried to restore the database file of version 9.0 in postgres 9.1 . It worked fine . It restored succesfully . But after that I noticed some text fields have become fields of unknown type and it throwing some exception . so now when I am trying to take a backup it is giving some exception that dump version 9.0.1 is not matching with postgres server 9.1.0 . So what is the solution ?.
ashutos:
Is there any GUI tool which can generate the .sql file for postgres database ? . PGAdmin doesnot generates .SQL file.
PgAdmin can generate SQL files just fine. Just select the backup format as ‘plain’.
See screenshot:
[attachment=0]pgadmin-backup-as-plain-sql.png[/attachment]
Just remember that you can’t use the restore function with those SQL files but need to execute them in a SQL editor (if they are large use psql instead).
Also if you want to make a full backup of your whole PosgreSQL install and restore it in a new PostgreSQL instance check out this post.
