bb.donnay-software.com

Hi all

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

Thanks

Joe

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

unixkd wrote: ↑Thu Mar 27, 2025 12:29 pm Hi all

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

Thanks

Joe

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:
It shows where the database physically resides on your machine. Backup this folder. In case, you may also restore those files.

This is not advisable method by Postgresql official documentation:

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

Tom wrote: ↑Mon Mar 31, 2025 3:52 am 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.

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