Backup database through function in PostgreSQL

Question

Here i have sql server query to take backup of database using stored procedure as shown below:

Example:

 CREATE procedure DISKBACKUP  @location_dump varchar(255), @databasename varchar(255)                 
   AS                  
  backup Database @databasename to disk=@location_dump          
  ...

Can I do the same in PostgreSQL?

No, but you can use pg_dump or simple GUI tool PostgreSQL-backup (postgresql-backup.com) to make PostgreSQL backups — user6128263
– user6128263, Commented Sep 7, 2016 at 10:15

Craig Ringer · Accepted Answer · 2014-05-14 13:58:46Z

2

No, it is not.

pg_dump must be used.

It's often requested, but it's not supported at present, and nobody who requests it ever goes on to do any work to actually make it happen.

answered May 14, 2014 at 13:58

Craig Ringer

329k83 gold badges742 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Backup database through function in PostgreSQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related