backup and restore

On 09.05.2007 09:45, anhtin wrote:

hi all
I am developing web site use database is PostGres and now i must build
function backup and Restore database on Web
My web develop on framework 2.0(asp.net 2.0)
I know have two file on forder bin use backup and restore is: pg_restore.exe
, pg_dump.exe
I have plan is write function or procedures on Database can backup and
restore database.
How can i write this function ???
Some body show for me?

Well, a good start might be to take a look at the manual of the
application in question?

See http://www.postgresql.org/docs/current/static/backup.html

--
Regards,
Hannes Dorbath

thanks reply for me
but have propblem:
the function pg_start_backup()
i dont run this function
Can u send me example is a procedure or function can backup and restore for
me ????

--
View this message in context: http://www.nabble.com/backup-and-restore-tf3714247.html#a10391372
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Anybody show for me ?????
i want backup database and i read on Internet have function
pg_start_backup(C:\Program Files\MicrosoftSQLServer\MSSQL\BACKUP\abc.backup)
but i not run
Some body show me. How will i do run this function ??
--
View this message in context: http://www.nabble.com/backup-and-restore-tf3714247.html#a10426698
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Anybody show for me ?????
i want backup database and i read on Internet have function
pg_start_backup(C:\Program Files\MicrosoftSQLServer\MSSQL\BACKUP\abc.backup)
but i not run
Some body show me. How will i do run this function ??
--
View this message in context: http://www.nabble.com/backup-and-restore-tf3714247.html#a10426702
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Anybody show for me ?????
i want backup database and i read on Internet have function
pg_start_backup(C:\Program Files\MicrosoftSQLServer\MSSQL\BACKUP\abc.backup)
but i not run
Some body show me. How will i do run this function ??
--
View this message in context: http://www.nabble.com/backup-and-restore-tf3714247.html#a10426704
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

anhtin wrote:

Anybody show for me ?????
i want backup database and i read on Internet have function
pg_start_backup(C:\Program Files\MicrosoftSQLServer\MSSQL\BACKUP\abc.backup)
but i not run
Some body show me. How will i do run this function ??

See:

http://www.postgresql.org/docs/8.2/static/continuous-archiving.html

--
Paul Lambert
Database Administrator
AutoLedgers

anhtin wrote:

Anybody show for me ?????
i want backup database and i read on Internet have function
pg_start_backup(C:\Program Files\MicrosoftSQLServer\MSSQL\BACKUP\abc.backup)
but i not run
Some body show me. How will i do run this function ??

Read the documentation!

http://www.postgresql.org/docs/current/static/backup-dump.html

pg_start_backup is NOT for creating full backups - it is for creating
partial backups (as you would see here:
http://www.postgresql.org/docs/8.2/static/continuous-archiving.html).

--
Postgresql & php tutorials
http://www.designmagick.com/

Thank reply for me
Can u show me
How will i backup database on Function or proc on Database??
--
View this message in context: http://www.nabble.com/backup-and-restore-tf3714247.html#a10427265
Sent from the PostgreSQL - general mailing list archive at Nabble.com.