Compatibility Issue.

[ashutos]

Hi All ,

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 ?.



Please help . Thanks in advance.

[ashutos]

Hi All,

Please do reply . I am wiating for your feedback.

[ashutos]

Hi All ,

Is there any GUI tool which can generate the .sql file for postgres database ? . PGAdmin doesnot generates .SQL file.

[ROCLASI]

Hi 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:

pgadmin-backup-as-plain-sql.png (60.06 KiB) Viewed 2548 times

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.

Hope this helps.