|
|
How can I backup database from database itself
Is there a way to backup a database by issuing an SQL statement from the
database?
I would like user to be able to create a backup from database itself,
and not by telnetting to server and typing 'pg_dump' or 'pg_dumpall'.
Tnx in advance
Dragan
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
|
|
0
|
|
|
|
Reply
|
 mlists
|
6/24/2004 11:56:58 AM |
|
On Thu, Jun 24, 2004 at 13:56:58 +0200,
Dragan Matic <mlists@panforma.co.yu> wrote:
> Is there a way to backup a database by issuing an SQL statement from the
> database?
> I would like user to be able to create a backup from database itself,
> and not by telnetting to server and typing 'pg_dump' or 'pg_dumpall'.
> Tnx in advance
They don't have to telnet to the server to run pg_dump or pg_dumpall.
Those can be run from their machine. (Though they should be running a
version as least as recent as the server version.) Take a look at the
man page, in particular the -h option.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
|
|
|
0
|
|
|
|
Reply
|
bruno
|
6/24/2004 5:56:57 PM
|
|
|
1 Replies
148 Views
(page loaded in 0.039 seconds)
Similiar Articles: Database corrupt...how to backup? - comp.databases.mysql ...If the installation crashed, you can't have that much valuable data in the phpBB3 database ... How can I backup database from database itself - comp.databases ... Database ... Copy-on-write for real/imaginary parts of complex data? - comp ...> > > > > > Suppose @fun creates a shared data copy of the input off to the side (e ... How can I backup database from database itself - comp.databases ... Copy-on-write for real ... How do I copy recordsets from one database table to another ...I am using the Database Connectivity Toolset, and would like to copy either one recordset or multiple recordsets from one Access table to a table in a... Restoring data only from backup using CCC? - comp.sys.mac.apps ...If I have a complete backup (OS and data files) of my main hard drive made using CCC, how can I restore the data only, after I install a new OS onto ... How to export Saved figure data points to Matlab work space ...... Amy Hi Amy, Could you please let me know how we can retrieve the data itself from the figure? ... How to export Saved figure data points to Matlab work space ... copy ... SQL 2008 Enterprise - Deny access to database for even ...I am not interested in encrypting the data itself, just keeping people out of database 'A', while ... However, he could still stop the service and copy the database files ... Importing with TransferDatabase from ODBC and including Indexes ...I've been trying to figure out how to make a copy of a database newly upsized to SQL Server, and asked how to do it on StackOverflow.com: http:/... How can I rename a structure name inside a loop? - comp.soft-sys ...Hi I have a database of structures with similar fields ... Saving data in for loop - comp.soft-sys.matlab How can I ... SSIS Foreach Loop to copy, rename files within folders ... Column headers for exported data - comp.databases.filemaker ...... All: One more question on exporting data: How can ... "File Open" by itself does the job. Thus ... Share database ... following: - Export data to a CSV file with field ... How to delete files two days older from system - comp.unix.admin ...Hi, I have database backup which is running daily basis and storeing in some directory. I want to keep two current consecutive days backup file and w... IBackup - Online Backup, Storage, Sharing and Disaster Recovery ...IBackup Online Backup is the industry-leading solution for multi-platform online backup, storage, sharing and advanced database backup for PC, Mac, Linux Copying Databases in Windows Azure SQL DatabaseYou can copy a database to the same SQL Database server, using a different database name, or you can copy the database to a different SQL Database server. 7/15/2012 8:29:19 AM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
1 followers. 