Database backup and restore in pg xbade++

[unixkd]

Hi all

Any member with xbase++ procedure/function/class for backup and restore of databases in postgresql.

Thanks

Joe

[k-insis]

- Backup is done with pg_dump utility
- Restore is done with psql / pg_restore utilities.
- Partial backups / restores on schema, table, procedures, views, etc are of course doable.

Those utils handle every complexity that is on server.

Interactive way can be done in dbeaver .

Just out of curiosity - Why would you need to have such utility in xpp ?

Hi all

Any member with xbase++ procedure/function/class for backup and restore of databases in postgresql.

Thanks

Joe

[Tom]

You may directly create a backup of the physical files where your database is stored. Open pgAdmin, select your database and open the query tool. Type this command:

Code: Select all

show data_directory;

It shows where the database physically resides on your machine. Backup this folder. In case, you may also restore those files.

[k-insis]

This is not advisable method by Postgresql official documentation:

https://www.postgresql.org/docs/16/backup-file.html

You may directly create a backup of the physical files where your database is stored. Open pgAdmin, select your database and open the query tool. Type this command:

Code: Select all

show data_directory;

It shows where the database physically resides on your machine. Backup this folder. In case, you may also restore those files.

[Tom]

Those limitations are easy to handle. And I didn't say that this is best practice; it's just a way to create a backup. You don't need to have an active connection to your server to do that. Besides, the statement can be used from inside an Xbase++-application (same with dump, I know).